Topics covered include:
- Using range names in formulas
- Creating nested functions
- Working with forms, form controls, and data validation
- Using lookup functions
- Combining multiple functions
- Creating, modifying, and formatting charts
- Using sparklines, trendlines, and dual-axis charts
- Creating a Pivot Table and analyzing Pivot Table data
- Presenting data with Pivot Charts
- Filtering data with slicers
Curriculum
- 20 Sections
- 0 Lessons
- 169 Minutes
Expand all sectionsCollapse all sections
- Creating Range Names0
- Using Defined Names in a Formula0
- Using Specialized Functions, Part 10
- Using Specialized Functions, Part 20
- 8 Applying Data Validation0
- Using a Data Form0
- Adding Form Controls0
- Using Lookup Functions0
- Combining Functions0
- Creating a Chart0
- Formatting and Modifying Charts0
- Dual Axis Charts0
- Forecasting with Trend Lines0
- Creating Chart Templates0
- Creating Sparklines0
- Inserting Pivot Tables0
- Analyzing Pivot Table Data, Part 10
- Analyzing Pivot Table Data, Part 20
- Filtering Data with Slicers0
- Presenting Data with Pivot Charts0
Instructor
