Mastering Excel 2019 – Advanced
There are two kinds of people: Those who are masters at Excel, and those who wish they were
Target Audience: People who have a working knowledge of Excel 2019 or Excel 365, but want to use more complex functions and features to analyze data. By the end of this course, you will feel empowered to use Excel’s most advanced features to create professional, secure, and accurate workbooks in Excel 2019 or Excel 365
Teacher: Kathy Jones
Learner: Alexa Botelho
• 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, 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.
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. 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
High-quality HD content in the “Uniquely Engaging” Bigger Brains Teacher-Learner style!
What You'll Learn
Linking & Consolidating
Creating Internal Links (4:08)
Creating External Links (9:00)
Using Group Mode (3:18)
Using 3D References (2:32)
Consolidating Data (6:56)
Sharing and Protecting
Adding Comments (5:04)
Tracking Changes (6:04)
Co-Authoring, Part 1 (6:12)
Co-Authoring, Part 2 (4:44)
Using Compare and Merge (3:04)
Preparing to Share (7:19)
Protecting Worksheets (10:33)
Protecting Workbook Structure (3:01)
Protecting a Workbook File (7:08)
Applying Data Validation (7:18)
Adding a Dropdown List (4:56)
Customizing Data Validation (5:18)
Recording a Macro (8:08)
Running a Macro (5:32)
Editing a Macro (8:27)
Using Lookup Functions
Using VLOOKUP, Part 1 (5:40)
Using VLOOKUP, Part 2 (5:14)
More Lookup Functions (9:44)
Using Array Formulas (6:00)
Tracing Formulas (6:22)
Addressing Formula Errors (7:16)
Watching and Evaluating Formulas (4:46)
Adding Error Handling (4:51)
Using Goal Seek (3:30)
Forecasting with Data Tables (5:04)
Using Solver (6:46)
Forecasting with Scenarios (8:16)
Forecasting Data Trends (3:23)
Creating Sparklines (3:58)
Mapping Data (3:47)
Creating 3D Maps (8:27)
Creating Custom Lists (5:34)
Importing and Exporting Data (3:19)
Creating a Web Query (3:52)
Working with Forms (9:54)
Ideas in Office 365 (2:06)
Lessons : 43
Seat Time : 3 Hours 58 Minutes
Versions Available : SCORM 1.2, SCORM 2004, AICC, xAPI, MP4, reseller HTML
Produced by : Bigger Brains