Mastering Excel 2019 - Advanced

If you are looking for a course that will teach you the Advanced features in Excel 2019, this is it! This course will prepare you to...

• Use multiple worksheets and workbooks to track, retrieve, consolidate and report on data using features like cell links, Group Mode, 3D Reference formulas, and Consolidate.
• Collaborate with others using Comments, Track Changes, Sharing, Co-Authoring, and Compare and Merge.
• Prepare a document for sharing by checking for accessibility and sensitive information and adding a digital signature, as well as multiple ways to protect your worksheets and workbooks from changes.
• Keep your data consistent and accurate with Data Validation and automate tasks with Macros.
• Perform complex calculations by developing a deep understanding of Excel’s Lookup functions like VLOOKUP, MATCH, and INDEX.
• Quickly find and address errors in your formulas with Tracing, Evaluate Formula, and the Watch Window, as well as add error handling with the IFNA and IFERROR functions.
• Use your data to plan and forecast trends and explore a variety of outcomes based on variables and scenarios.
• Visualize geographic data with Map Charts and 3D Map Tours.

Certificate of completion

Digital certificate - Included

Reed Courses Certificate of Completion

Digital certificate - Included

• Linking and Consolidating 33:41

  • 1: Introduction Preview 01:59
  • 2: Creating Internal Links 04:07
  • 3: Creating External Links 09:00
  • 4: Using Paste Special 05:50
  • 5: Using Group Mode 03:18
  • 6: Using 3D References 02:31
  • 7: Consolidating Data 06:56

• Sharing and Protecting 59:03

  • 8: Adding Comments 05:04
  • 9: Tracking Changes 06:04
  • 10: Co-Authoring, Part 1 06:12
  • 11: Co-Authoring, Part 2 04:44
  • 12: Using Compare and Merge 03:04
  • 13: Preparing to Share 07:19
  • 14: Adding Digital Signatures 05:55
  • 15: Protecting Worksheets 10:33
  • 16: Protecting Workbook Structure 03:00
  • 17: Protecting a Workbook File 07:08

• Automating 39:39

  • 18: Applying Data Validation 07:18
  • 19: Adding a Dropdown List 04:56
  • 20: Customizing Data Validation 05:18
  • 21: Recording a Macro 08:08
  • 22: Running a Macro 05:32
  • 23: Editing a Macro 08:27

• Using Lookup Functions 26:38

  • 24: Using VLOOKUP, Part 1 05:40
  • 25: Using VLOOKUP, Part 2 05:14
  • 26: More Lookup Functions 09:44
  • 27: Using Array Formulas 06:00

• Auditing Formulas 28:10

  • 28: Tracing Formulas 06:22
  • 29: Addressing Formula Errors 07:16
  • 30: Watching and Evaluating Formulas 04:46
  • 31: Adding Error Handling 04:34
  • 32: Working with Information Functions 05:12

• Forecasting Data 26:59

  • 33: Using Goal Seek 03:30
  • 34: Forecasting with Data Tables 05:04
  • 35: Using Solver 06:46
  • 36: Forecasting with Scenarios 08:16
  • 37: Forecasting Data Trends 03:23

• More Features 47:30

  • 38: Inserting Symbols and Characters 02:31
  • 39: Creating Sparklines 03:58
  • 40: Creating a Map Chart 03:47
  • 41: Creating 3D Maps 08:27
  • 42: Creating Custom Lists 05:34
  • 43: Importing and Exporting Data 03:19
  • 44: Creating a Web Query 03:52
  • 45: Working with Forms 09:54
  • 46: Using ActiveX Controls 04:02
  • 47: Ideas in Office 365 02:06

There are two kinds of people: Those who are masters at Excel 2019 or Excel 365, and those who wish they were

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.

This is our most requested training course!

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!

People who have a working knowledge of Excel 2019 or Excel 365, but want to use more complex functions and features to analyze data.

Currently there are no Q&As for this course. Be the first to ask a question.