Excel Intermediate Training Class
This course builds on the basic concepts and skills of our Excel Intro course to provide more advanced tools for analysis and presentation of complex, realistic data in Microsoft Excel: 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. You will benefit most from this course if you want to use Excel to perform real-world tasks, such as rearranging and presenting complex data.
Managing Workbooks
- Managing Worksheets
- Customizing Excel
Named Ranges
- Using Names In Formulas
Tables
- Sorting
- Filtering Tables
- Structured References
- Validation
- Transposing Data
Summarizing Data
- Consolidation
- Subtotals
PivotTables
- Creating And Formatting PivotTables
- Manipulating PivotTables
- PivotCharts
Presentation Features
- Conditional Formats
- Custom Formats
- Graphics
Advanced Charts
- Special Chart Types
- Sparklines
- Quick Analysis
Collaboration
- Permissions
- Shared Workbooks
Prerequisites:
- Familiarity with the Microsoft Office Ribbon.
- Understanding of cell references, formulas and functions.