Choose your timezone
Register Below or Call (888) 804-1132
and Talk to a Training Specialist Today
$50 off each course when you book more than one course or more than one person per course. Discount will be applied at checkout.
Class sizes are kept small for a better learning experience. Limited to 15 people per class.
Have more than 6 people for a course? Call us at (888) 804-1132 and ask about our group rates.Want to run this as a private class for your team? Enquire about running this event as a private class
Description
This course builds on the basic concepts and skills of our Level 1 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, and make an impact with powerful chart and presentation features.
Using Multiple Worksheets and Workbooks
- Working with Multiple Worksheets
- Freezing Panes
- Viewing and Arranging Multiple Worksheet Windows
- Navigating in Multiple Workbooks
- Selecting and Viewing Multiple Workbooks
- Moving and Copying Data Between Worksheets
- Working with Named Ranges
Basic and Advanced Charting
- Creating a Chart
- Changing Chart Type, Style and Chart Sub-Type
- Changes to the Chart Source Data
- Add Data to an Existing Chart
- Remove Data from a Chart
- Managing Chart Objects
- Moving and Resizing Chart Objects
- Deleting Chart Objects
- Adding Data Series
- Formatting Chart Objects
- Printing Charts
Working with Lists and Tables
- Sorting and Filtering Data
- Creating a Table
- Quick Format a Table
- Using Structured References
- Using Data Validation
Summarizing Data
- Using Consolidation
- Getting Subtotals
PivotTables and PivotCharts
- Working with PivotTables and PivotCharts
- Identifying the Parts of a Basic PivotTable
- PivotTable Reports
- Create a PivotTable from Worksheet Data
- Create a PivotChart Report from an Existing PivotTable Report
Using Slicers in PivotTables
- Using Slicers
- Formatting Slicers for a Consistent Look
Using Sparklines to Analyze Data
- Types of Sparklines
- Create a Sparkline
- Customize Sparklines
- Control which Value Points are Shown
- Change the Style and Format Sparklines
Prerequisites
The course assumes you know how to use a computer, that you're familiar with Microsoft Windows, and that you've taken the Level 1 course or have equivalent introductory experience with Excel.
Who should attend?
Those who want to use Excel to perform real-world tasks, such as rearranging and presenting complex data.
