Overview:
This 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.
Audience:
Students who have basic skills with Microsoft Excel 2019 who want to learn intermediate-level skills or students who want to learn the topics covered in this course in the 2019 interface.
Pre-Requisites:
Experience in the following is required for this Microsoft Excel class:
- Basic Excel
Course Curriculum
| Advanced Formulas | |||
| Using Named Ranges in Formulas Details | 00:00:00 | ||
| Using Formulas That Span Multiple Worksheets Details | 00:00:00 | ||
| Entering a Formula Using Data in Multiple Worksheets Details | 00:00:00 | ||
| Using the IF Function Details | 00:00:00 | ||
| Using the PMT Function Details | 00:00:00 | ||
| Using the LOOKUP Function Details | 00:00:00 | ||
| Using the VLOOKUP Function Details | 00:00:00 | ||
| Using the HLOOKUP Function Details | 00:00:00 | ||
| Using the CONCAT Function Details | 00:00:00 | ||
| Using the TRANSPOSE Function Details | 00:00:00 | ||
| Using the PROPER, UPPER, and LOWER Functions Details | 00:00:00 | ||
| Using the PROPER Function Details | 00:00:00 | ||
| Using the LEFT, RIGHT, and MID Functions Details | 00:00:00 | ||
| Using the LEFT and RIGHT Functions Details | 00:00:00 | ||
| Using Date Functions Details | 00:00:00 | ||
| Using the YEAR, MONTH, and DAY Functions Details | 00:00:00 | ||
| Utilize the Watch Window Details | 00:00:00 | ||
| Consolidate Data Details | 00:00:00 | ||
| Enable Iterative Calculations Details | 00:00:00 | ||
| What-If Analyses Details | 00:00:00 | ||
| Use the Scenario Manager Details | 00:00:00 | ||
| Use Financial Functions Details | 00:00:00 | ||
| Working with Lists | |||
| Converting a List to a Table Details | 00:00:00 | ||
| Removing Duplicates from a List Details | 00:00:00 | ||
| Sorting Data in a List Details | 00:00:00 | ||
| Filtering Data in a List Details | 00:00:00 | ||
| Adding Subtotals to a List Details | 00:00:00 | ||
| Grouping and Ungrouping Data in a List Details | 00:00:00 | ||
| Working with Illustrations | |||
| Working with Clip Art Details | 00:00:00 | ||
| Using Shapes Details | 00:00:00 | ||
| Adding Shapes Details | 00:00:00 | ||
| Working with Icons Details | 00:00:00 | ||
| Working with SmartArt Details | 00:00:00 | ||
| Using Office Ink Details | 00:00:00 | ||
| Visualizing Your Data | |||
| Inserting Charts Details | 00:00:00 | ||
| Using the Chart Recommendation Feature Details | 00:00:00 | ||
| Editing Charts Details | 00:00:00 | ||
| Using Chart Tools Details | 00:00:00 | ||
| Changing the Style of Pieces of a Chart Details | 00:00:00 | ||
| Adding a Shape to a Chart Details | 00:00:00 | ||
| Adding a Trendline to a Chart Details | 00:00:00 | ||
| Adding a Secondary Axis to a Chart Details | 00:00:00 | ||
| Adding Additional Data Series to a Chart Details | 00:00:00 | ||
| Switch between Rows and Columns in a Chart Details | 00:00:00 | ||
| Positioning a Chart Details | 00:00:00 | ||
| Modifying Chart and Graph Parameters Details | 00:00:00 | ||
| Using the Quick Analysis Tool Details | 00:00:00 | ||
| Watching Animation in a Chart Details | 00:00:00 | ||
| Showing, Hiding, or Changing the Location of the Legend in a Chart Details | 00:00:00 | ||
| Showing or Hiding the Title of a Chart Details | 00:00:00 | ||
| Changing the Title of a Chart Details | 00:00:00 | ||
| Showing, Hiding, or Changing the Location of Data Labels in a Chart..162 Details | 00:00:00 | ||
| Changing the Style of Pieces of a Chart Details | 00:00:00 | ||
| Editing Charts Details | 00:00:00 | ||
| Add and Format Objects Details | 00:00:00 | ||
| Create a Custom Chart Template Details | 00:00:00 | ||
| Working with Tables | |||
| Format Data as a Table Details | 00:00:00 | ||
| Move between Tables and Ranges Details | 00:00:00 | ||
| Modify Tables Details | 00:00:00 | ||
| Define Titles Details | 00:00:00 | ||
| Creating and Modifying a Table in Excel Details | 00:00:00 | ||
| Advanced Formatting | |||
| Applying Conditional Formatting Details | 00:00:00 | ||
| Using Conditional Formatting Details | 00:00:00 | ||
| Working with Styles Details | 00:00:00 | ||
| Creating and Modifying Templates Details | 00:00:00 | ||
Course Reviews
No Reviews found for this course.
0 STUDENTS ENROLLED