 |
|
Microsoft Excel 365 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 365 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