Mastering Excel 2019 - Advanced

Mastering Excel 2019 – Advanced

What you'll learn
Use multiple worksheets and workbooks to track, retrieve, consolidate and report on data using features like cell links, Group Mode, and more!
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.
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 more!
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.

Requirements
An intermediate knowledge of Excel is recommended.

Description
Learn how to use 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. This course is your first step towards becoming an expert at using Excel.This is our most requested training course!Topics covered include:Navigating the interfaceCreating and saving workbooksSelecting and entering dataPerforming calculationsFormatting dataManaging multiple worksheetsCustomizing your optionsObjectives. You will be able to:Navigate the interface including creating and saving workbooks, quickly accessing commands, and selecting and entering dataPerform calculations using formulas and functionsInsert and delete rows and columnsApply formatting to text, numbers, and cells including using Cell Styles and Conditional FormattingControl how your worksheets print using Page Layout options, Page Breaks, and Headers and FootersManage multiple worksheets within a workbook including adding, removing, renaming, reordering, copying, and color-coding worksheetsUse View features to compare workbooks, compare worksheets, or save Custom ViewsCustomize Excel by adding Groups to the Ribbon and modifying the Quick Access ToolbarCourse Goal: By the end of this course, you will be able to use to create your own workbooks and analyze your data.Learn how to use the world’s most popular software tool for organizing and analyzing data.Over four hours of high-quality HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style!

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