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 |