Intermediate Microsoft Excel 2019 Training - 8:07 hoursThis Intermediate Microsoft Excel 2019 training class is meant for students using Excel 2019 or Excel 365 who want to advance their skill set by learning to work with advanced formulas, lists, and illustrations. Students will also work with charts and advanced formatting including styles.
Advanced Formulas
Using Named Ranges in Formulas
Naming a Single Cell
Naming a Range of Cells
Naming Multiple Single Cells Quickly
Exercise: Using Named Ranges in Formulas
Using Formulas That Span Multiple Worksheets
Exercise: Entering a Formula Using Data in Multiple Worksheets
Using the IF Function
Using AND/OR Functions
Using the SUMIF, AVERAGEIF, and COUNTIF Functions
Exercise: Using the IF Function
Using the PMT Function
Exercise: Using the PMT Function
Using the LOOKUP Function
Using the VLOOKUP Function
Exercise: Using the VLOOKUP Function
Using the HLOOKUP Function
Using the CONCAT Function
Exercise: Using the CONCAT Function
Using the TRANSPOSE Function
Using the PROPER, UPPER, and LOWER Functions
The UPPER Function
The LOWER function
The TRIM Function
Exercise: Using the PROPER Function
Using the LEFT, RIGHT, and MID Functions
The MID Function
Exercise: Using the LEFT and RIGHT Functions
Using Date Functions
Using the NOW and TODAY Functions
Exercise: Using the YEAR, MONTH, and DAY Functions
Creating Scenarios
Utilize the Watch Window
Consolidate Data
Enable Iterative Calculations
What-If Analyses
Use the Scenario Manager
Use Financial Functions
Working with Lists
Converting a List to a Table
Exercise: Converting a List to a Table
Removing Duplicates from a List
Exercise: Removing Duplicates from a List
Sorting Data in a List
Exercise: Sorting Data in a List
Filtering Data in a List
Exercise: Filtering Data in a List
Adding Subtotals to a List
Grouping and Ungrouping Data in a List
Exercise: Adding Subtotals to a List
Working with Illustrations
Working with Clip Art
Exercise 15:Working with Clip Art
Using Shapes
Exercise: Adding Shapes
Working with Icons
Working with SmartArt
Using Office Ink
Visualizing Your Data
Inserting Charts
Using the Chart Recommendation Feature
Exercise: Inserting Charts
Editing Charts
Changing the Layout of a Chart
Using Chart Tools
Changing the Style of a Chart
Adding a Shape to a Chart
Adding a Trendline to a Chart
Adding a Secondary Axis to a Chart
Adding Additional Data Series to a Chart
Switch between Rows and Columns in a Chart
Positioning a Chart
Modifying Chart and Graph Parameters
Using the Quick Analysis Tool
Watching Animation in a Chart
Showing, Hiding, or Changing the Location of the Legend in a Chart
Showing or Hiding the Title of a Chart
Changing the Title of a Chart
Showing, Hiding, or Changing the Location of Data Labels in a Chart..211
Changing the Style of Pieces of a Chart
Exercise: Editing Charts
Add and Format Objects
Insert a Text Box
Create a Custom Chart Template
Working with Tables
Format Data as a Table
Move between Tables and Ranges
Modify Tables
Add and Remove Cells within a Table
Change Table Styles
Define Titles
Band Rows and Columns
Total Row Option
Remove Styles from Tables
Exercise: Creating and Modifying a Table in Excel
Advanced Formatting
Applying Conditional Formatting
Exercise: Using Conditional Formatting
Working with Styles
Applying Styles to Tables
Applying Styles to Cells
Exercise 21:Working with Styles
Creating and Modifying Templates
Modify a Custom Template |