Class time: 8:30am - 4:30pm
Length: 7 hours (1 day)
Location:
Lubbock Classroom
Melonie Park Meeting Space
3502 74th Street
Lubbock, TX 79423
Prerequisites
Students must have an Intermediate to Advanced understanding of Microsoft Excel.
Course Description
In the course, you will learn how to create and modify charts. Once you have modified the charts we will create chart templates to make creating future charts faster. We will also look at the new Sparkline feature in Excel.
In this class, you will also learn PivotTables and Pivot Charts. Learn how using the Table feature can help make PivotTables and charts more dynamic.
Detailed Course Outline
Understanding Charting
- Create Excel Charts
- Understanding the different types of Charts
- Using the Chart Ribbon
- Use the new Recommended Charts
- Changing the Chart Type and Moving the Chart
- Modifying charts
- Work with Chart Elements
- Create and use Chart Templates
- Look at the Excel’s new Sparkline feature
Understanding Tables and PivotTables
- Learn how to design your spreadsheet to make it easier to create Tables and PivotTables
- Learn various ways to Filter data
- Understand the difference between Filtering data and using Tables
- Create Tables and Understand their benefits
- Create and Modify PivotTables
- Create and Modify Pivot Charts
- Work with Slicers
- Understand how Slicers can help with Dashboards
- Work with PivotTable Timelines
- Work with Recommended PivotTables
Conditional Formatting
- Understand how to apply and modify Conditional Formatting
- Understand how to use new features like Data Bars and Icon Sets
Combine Your Knowledge and Create a Dashboard
- Use your knowledge of PivotTables, Charts. Slicers, Timelines, and Conditional Formatting to create a simple dashboard.
- Learn Basic Drawing options and Excel Options to help with dashboards.
Who Should Attend
Intermediate to Advanced Excel users that would like to expand their knowledge of Excel
The class must be canceled 10 days before start date