Description
Overview:
The course builds on the basic concepts and skills of the Level 1 course to provide more advanced tools for analysis and presentation of complex, realistic data in Microsoft Excel. Lessons including how to manage complex workbooks, build more complex functions, use data analysis tools, make an impact with powerful chart and presentation features, and collaborate with other users.
Prerequisite(s):
Excel Level 1
Audience:
Outline:
Lesson 1: Managing workbooks
- Managing worksheets
- Customizing Excel
Lesson 2: Named ranges
- Using names in formulas
Lesson 3: Tables
- Sorting
- Filtering tables
- Structured references
- Validation
- Transposing data
Lesson 4: Summarizing data
- Consolidation
- Subtotals
Lesson 5: PivotTables
- Creating and formatting PivotTables
- Manipulating PivotTables
- PivotCharts
Lesson 6: Presentation features
- Conditional formats
- Custom Format
- Graphics
Lesson 7: Advanced charts
- Special chart types
- Sparklines
- Quick Analysis
Lesson 8: Collaboration
- Permissions
- Comments
Reviews
There are no reviews yet.