Microsoft Excel 2019
Beginner
9h
By: Ashley Hunt
Overview
In this instructor-led, online training course, students will be provided with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation.
Modules
1. What's New in Excel 2019?
1.1 Excel Overview For Newer Users41 min
1.2 Flash Fill & Quick Analysis15 min
1.3 New Features30 min
2. ABC's of Sort & Filter
2.1 Apply A Simple Filter To a Range19 min
2.2 Apply A Top 10 And Custom Filter To a Range
2.3 Apply an Advanced Filter With Multiple OR Criteria7 min
2.4 Apply an Advanced Filter With Complex Criteria7 min
2.5 Apply an Advanced Filter With Function-Driven Criteria22 min
2.6 Convert A Range into A Table and Add a Total Row6 min
2.7 Format A Table Using Table Styles8 min
2.8 Conditional formatting and help7 min
3. Clean Your Data!
3.1 Text to Columns9 min
3.2 Consolidate Data from Multiple Data Ranges13 min
3.3 Use Data Consolidation to Generate Quick Subtotals from Tables4 min
3.4 Remove Duplicate Values from A Table18 min
4. Get inFORMed!
4.1 Setting Up a Form16 min
4.2 Conditional Formatting Part 17 min
4.3 Conditional Formatting Part 211 min
4.4 Add Group Box and Option Button Controls to A Worksheet Form10 min
4.5 Add A Combo Box Control to A Worksheet Form7 min
4.6 Add Forms to Quick Access Toolbar7 min
5. Mathematically Challenged?
5.1 Named ranges15 min
5.2 SUM15 min
5.3 TRIM4 min
5.4 SUMIF12 min
5.5 COUNTIF / AND7 min
5.6 LEFT/ RIGHT7 min
5.7 TEXTJOIN8 min
5.8 PROPER, UPPER, LOWER7 min
5.9 Move or copy formula sheets8 min
5.10 CONCATINATE6 min
5.11 VLOOKUP12 min
5.12 Use the Watch Window to Monitor Cell Values7 min
6. Hands Off My Work!
6.1 Prevent Unauthorized Users from Opening or Modifying Workbooks/password protect7 min
6.2 Control The Changes Users Can Make to Workbooks7 min
6.3 Restrict The Cells Users Are Allowed to Change6 min
6.4 Allow Different Levels of Access to A Worksheet with Multiple Passwords4 min
6.5 Digital Signatures4 min
6.6 Accept and Reject Changes to Shared Workbooks12 min
6.7 Totally Hide Cell Content from Prying Eyes14 min
7. Let Macros do it
7.1 Record A Macro14 min
7.2 Record A Macro with Absolute/Relative References 7 min
7.3 Use Shapes to Run Macros8 min
7.4 Run A Macro from A Button Control /Intro to VBA11 min
8. Chart, Spark and Pivot
8.1 Intro to charts and sparklines10 min
8.2 Use Pictograms and Blow Their Mind!6 min
8.3 Create A Pivot Table Because Your Boss Loves Them!7 min
8.4 Filter A Pivot Table Visually Using Slicers5 min
8.5 Add A Timeline Control to A Pivot Table4 min
8.6 Use Slicers to Create a Custom Timeline3 min
8.7 Format A Pivot Table Using Pivot Table Styles6 min
8.8 Create A Custom Pivot Table Style4 min
8.9 Understand Pivot Table Report Layouts4 min
8.10 Add/Remove Subtotals and Apply Cell Styles to Pivot Table Fields7 min
8.11 Display Multiple Summations Within a Single Pivot Table5 min
8.12 Add A Calculated Field to A Pivot Table4 min
8.13 Pivot charts4 min
Ready to Elevate Your Team's Learning?
Talk with our sales team to see how StormWind can transform the way your organization trains and grows.
CONTACT SALES