Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

Mastering Excel 2019 - Advanced

via Udemy

Overview

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.

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!

Taught by

Chip Reaves

Reviews

4.2 rating at Udemy based on 80 ratings

Start your review of Mastering Excel 2019 - Advanced

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.