Mastering Excel 2019 - Advanced

Mastering Excel 2019 - Advanced

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!

Mastering Excel 2019 – Advanced

Url: View Details

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.

Rating: 4.4

Level: Expert Level

Duration: 4.5 hours

Instructor: Bigger Brains