Mastering Excel 2019 – Advanced
Course details
- No. of Lessons: 47
- Duration: 4:21:41
- Skill level: Advanced
- Captions: English, Spanish
- Also included: Handout, Practice Files, Knowledge Check, High-quality HD content in the “Uniquely Engaging™” Bigger Brains Teacher-Learner style!
When you master Excel 2019 or Excel 365, you have one of the most practical and valuable skillsets in modern business. A spreadsheet guru can work wonders—from organizing lists; to creating multi-layered, interactive reports; to answering critical business questions like ROI, budget allocations, expense tracking, and more. This course builds on your existing Excel knowledge and teaches you how to use links, Lookup functions, Data Validation, Macros, data tables, and more.
If you are comfortable with using Excel for a variety of tasks, let our Microsoft Certified Trainer, Kathy Jones, walk you through more advanced topics that will take your spreadsheets to the next level and help you to be more efficient in analyzing your data.
Topics covered include:
- Linking cells and consolidating data
- Sharing and protecting worksheets
- Automating data validation and tasks
- Using Lookup functions
- Auditing formulas
- Forecasting data
- Creating geographic visuals like Map Charts and 3D Map Tours
- Importing and exporting data
- Creating a Web Query
- Working with Forms and ActiveX controls
Over four hours of high-quality HD content in the “Uniquely Engaging” TM Bigger Brains Teacher-Learner style!
Taught by top subject matter experts, Bigger Brains courses are professionally designed around key learning objectives, and include captions and transcripts in 29 languages, downloadable handouts, and optional LinkedIn digital badges on course completion.
Course Contents:
| # | Section | # | Lesson | Length |
| 1 | Getting Started | 1 | Introduction | 2:09 |
| 2 | Navigating the Interface | 8:34 | ||
| 3 | Selecting Data | 9:15 | ||
| 4 | Using Commands | 7:13 | ||
| 5 | Creating a New Workbook | 8:03 | ||
| 6 | Entering Cell Data | 5:59 | ||
| 7 | Using AutoFill | 7:26 | ||
| 8 | Using Flash Fill | 4:59 | ||
| 9 | Using Excel Help | 2:04 | ||
| 2 | Performing Calculations | 10 | Creating Formulas | 7:57 |
| 11 | Inserting Functions | 8:13 | ||
| 12 | Copying Formulas and Functions | 7:08 | ||
| 13 | Using Absolute References | 9:51 | ||
| 3 | Modifying Worksheets | 14 | Inserting and Deleting Cells | 8:50 |
| 15 | Searching and Replacing | 7:54 | ||
| 16 | Using Proofing and Researching Tools | 6:57 | ||
| 4 | Formatting Worksheets | 17 | Applying Text Formats | 8:34 |
| 18 | Applying Number Formats | 7:23 | ||
| 19 | Customizing Number Formats | 7:46 | ||
| 20 | Aligning Cell Contents | 7:16 | ||
| 21 | Applying Cell Styles | 5:20 | ||
| 22 | Applying Themes | 3:48 | ||
| 23 | Inserting Hyperlinks | 6:30 | ||
| 24 | Applying Conditional Formatting to Numbers | 6:44 | ||
| 25 | Applying Conditional Formatting to Text and Dates | 7:55 | ||
| 26 | Applying Comparative Analysis Formatting | 7:22 | ||
| 27 | Using Templates | 6:00 | ||
| 5 | Printing Workbooks | 28 | Printing Workbooks | 4:11 |
| 29 | Setting the Page Layout | 6:34 | ||
| 30 | Inserting Page Breaks | 8:38 | ||
| 31 | Configuring Headers and Footers, Part 1 | 5:09 | ||
| 32 | Configuring Headers and Footers, Part 2 | 4:04 | ||
| 6 | Managing Workbooks | 33 | Managing Worksheets, Part 1 | 5:02 |
| 34 | Managing Worksheets, Part 2 | 7:39 | ||
| 35 | Creating a Custom View | 3:47 | ||
| 36 | Managing Worksheet Views | 6:00 | ||
| 37 | Managing Workbook Views | 6:22 | ||
| 38 | Managing Workbook Properties | 4:13 | ||
| 7 | Customizing Options | 39 | Customizing General Options | 4:35 |
| 40 | Customizing the Ribbon | 7:02 | ||
| 41 | Customizing the Quick Access Toolbar | 6:50 |
