Excel Level 2

1-DAY COURSE

Excel Level 2 is a one-day instructor-led course that provides 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.

WHO SHOULD ATTEND:

Appropriate for all levels

LEARNING OBJECTIVES

Chapter 1: Managing workbooks, Managing worksheets, Customizing Excel
Chapter 2: Named ranges, Using names in formulas
Chapter 3: Tables, Sorting, Filtering tables, Structured references, Validation Transposing data
Chapter 4: Summarizing data, Consolidation Subtotals
Chapter 5: PivotTables Creating and formatting PivotTables, Manipulating PivotTables PivotCharts
Chapter 6: Presentation features, Conditional formats, Custom Formats Graphics
Chapter 7: Advanced charts, Special chart types, Sparklines Quick Analysis
Chapter 8: Collaboration Permissions Shared workbooks