Professional DevelopmentMastering Excel 2019 – Advanced

Mastering Excel 2019 – Advanced

SKU: RVBB-3332
Duration: 4.37 Hrs

Become an expert in using the world’s most popular software tool for organizing and analyzing data.

When you master Excel, you have one of the most practical and valuable skillsets in modern business. You 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. 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.

This course builds on your existing Excel knowledge and teaches you how to use links, Lookup functions, Data Validation, Macros, data tables, and more.

Request a demo

Course Details

Learning Objectives

By the end of this course, you will be able 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.

Specs

Course Level Fundamental
Languages English
Compatibility Audio, Video, MobileReady

Bigger Brains

In 2009, Bigger-Brains founder Chip Reaves was tasked with creating an online training platform for Computer Troubleshooters, a global franchise network. As is the case with most companies, some of the training content was unique to their business, but others (Quickbooks, Online Marketing, Microsoft Office, etc) could be used by many companies. Frustrated with the poor quality, high prices, and lack of selection in the eLearning marketplace, Chip brought together a team to research the characteristics of effective training. The result is Bigger Brains" "Uniquely Engaging" teacher/learner format, which replicates the dialogue, interaction, humor, and personal connection of traditional classroom training with the "always available" convenience and searchability of eLearning. Today Bigger-Brains continues to create the "Absolute Best Online Training" from our studios in Anderson, South Carolina.

Course Applies To

Demos + Pricing

Learn more about our courses, get pricing, and see our platform.

Trusted by 24,000+ Industry Leaders