Description
Excel Level 2 is a one-day instructor-led class that builds upon the basic knowledge of Microsoft Excel learned in our Excel Level 1 class. Excel Level 2 covers more advanced features and tools that are used to organize and analyze. With topics in customization, named ranges, and tables. Participants learn advanced formatting techniques and data visualization using charts and graphics. Culminating with an introduction to PivotTables. Upon successful completion of the course, participants will be able to perform an array of common tasks more confidently and effectively like working with named ranges, tables, advanced formats, and charts. This course features units on:
Customizing Excel
- Ribbon, Quick Access Toolbar, Status Bar, Options
Managing Worksheets
- Inserting/Deleting/Hiding/Rearranging
Named Ranges
- Creating Named Ranges
- Naming a Value
- Using Named Ranges in Formulas/Functions
- Managing Named Ranges
Tables
- Benefits of the Excel Table Structure
- Creating a Table
- Sorting/Filtering
- Structured References in Tables
Advanced Formatting & Graphics
- Conditional Formats
- Custom Formats
- Graphics
Charting
- Basic Charting
- Combination Charts
- Saving a Chart as a Template
- Sparklines
- Recommended Charts
Introduction to Pivot Tables
- Overview