Brief Introduction
Expand your Excel abilities with charts, outlines, workbooks and much more.Description
This course is designed to be the intermediate level of Excel 2016. Students will learn how to link workbooks and worksheets, create named ranges and utilize them in formulas, build Logical functions such as IF, AND, and OR, and use Lookup functions to locate and compare data. Students will also be introduced to and work with Excel’s Table feature, learning to create and modify Tables. Students will also create and modify PivotTables and PivotCharts to analyze large data sets, sort the data, and use Slicers and Timeline Slicers to filter the data. Additionally, students will create and modify Charts, work with Flash Fill, work with subtotals and outlining, and learn how to customize the Excel environment.
This IAAP-certified counts for 4.0 recertification points for the CAP certification under the Technology and Information Distribution content area.
Email info@intellezy.com with proof of completion of the course to obtain your certificate.
Requirements
- Requirements
- Excel 2016 Introduction course or equivalent knowledge or experience
Knowledge
- Custom Excel
- Link Workbooks and Worksheets
- Work with Range Names
- Analyze Data with Common Logical Functions
- Analyze Data with Common Lookup Functions
- Sort and Filter Range Data
- Analyze and Organize with Tables
- Use Conditional Formatting
- Outline with Subtotals and Grouping
- Display Data Graphically
- Understand PivotTables and PivotCharts and Filter with Slicers
- Work with Flash Fill
- Work with Date and Time Functions
- Work with Common Text Functions
Microsoft Office Basic to Advance Training Course Bundle2021
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Microsoft Office Basic to Advance Training Course Bundle2021 which includes Word , Excel , Powerpoint , Outlook and more Learn Microsoft Office 2013 and 2016 with this comprehensive course....
The Ultimate Microsoft Office 2016 Training Bundle
- 4.6
-
![]()
![]()
![]()
![]()
![]()
The Most Convenient Way to Boost Your Confidence And Learn MS Office 2016 Inside And Out—Quickly, No Travel or Classes. Practice exercises included**...
Microsoft Excel 2016 Training: Beginner to Intermediate
- 4.6
-
![]()
![]()
![]()
![]()
![]()
The Most Convenient Way to Boost Your Confidence And Learn Microsoft Excel 2016 Inside And Out. Learn Microsoft Excel 2016 Inside and Out...
Microsoft Excel Course - Intermediate Training
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Real life exercises from banking and finance Microsoft Excel Course Intermediate Training + 15 mins live online consultation with the tutor Course Overview...
