Excel 2013 Level 2

Microsoft® Office Excel® 2013: Part 2

Course Length: 1 day

Course Content:

Chapter 1: Managing workbooks
Module A: Managing worksheets
Module B: Customizing Excel

Chapter 2: Named ranges
Module A: Using names in formulas

Chapter 3: Tables
Module A: Sorting
Module B: Filtering tables
Module C: Validation
Module D: Transposing data

Chapter 4: Summarizing data
Module A: Consolidation
Module B: Subtotals

Chapter 5: PivotTables
Module A: Creating and formatting PivotTables
Module B: Manipulating PivotTables
Module C: PivotCharts

Chapter 6: Presentation features
Module A: Conditional formats
Module B: Graphics

Chapter 7: Advanced charts
Module A: Special chart types
Module B: Sparklines

Chapter 8: Collaboration
Module A: Permissions
Module B: Shared workbooks
Module C: Web features