Microsoft Office Instructor-led Training and Support
Home     Classes and Prices     Course Catalog     About Our Classes     Registration     Your Instructor     Locations     Sitemap  

Microsoft Excel 2013/2016 Advanced - Analyzing Data - Course Content

Duration:
One day


Description:
This Instructor-led Training course covers the basic skills and concepts students need to use Microsoft Excel 2013/2016 productively and efficiently. After taking Excel Level I - III, students will learn how to analyze data with advanced Excel formulas and learn how to take advantage of Excel’s built-in tools for summarizing data.  They will also learn how to work with larger workbooks and “clean up” data downloaded from other sources.


Table of Contents
Lesson 1:     Calculate with advanced functions

Vlookup (exact match)
Vlookup (approximate match)
Hlookup (exact match)
Hlookup (approximate match)
IF
OR
NOT
AND
SumIf
Min
Max
Proper
Concatenate
Average
AverageIf
Count
CountA
CountIf

 

Lesson 2:     Organize worksheet and table data using various tools
Conditional formatting
Grouping and outlining
Using the subtotals tool
Advanced sorting techniques
Using the filter tool
Using formulas with custom filters


Lesson 3:     Working with 3 dimensional formulas (formulas that calculate values across worksheets).


Lesson 4:     Analyze data using PivotTables, Pivot Charts, Slicers and Sparklines.


Lesson 5:     Charting and Graphing
Creating a pie chart
Creating a column chart
Manipulating chart data
Troubleshooting