Mastering Excel 2019 - Advanced
Mastering Excel 2019 – Advanced
What you will 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.
Why take this course?
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 interface
Creating and saving workbooks
Selecting and entering data
Performing calculations
Formatting data
Managing multiple worksheets
Customizing your options
Objectives. You will be able to:
Navigate the interface including creating and saving workbooks, quickly accessing commands, and selecting and entering data
Perform calculations using formulas and functions
Insert and delete rows and columns
Apply formatting to text, numbers, and cells including using Cell Styles and Conditional Formatting
Control how your worksheets print using Page Layout options, Page Breaks, and Headers and Footers
Manage multiple worksheets within a workbook including adding, removing, renaming, reordering, copying, and color-coding worksheets
Use View features to compare workbooks, compare worksheets, or save Custom Views
Customize Excel by adding Groups to the Ribbon and modifying the Quick Access Toolbar
Course 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!
Reviews
Charts
Price
Rating
Enrollment distribution
