Udemy

Mastering Excel 2019 - Advanced

Enroll Now
  • 10,201 Students
  • Updated 2/2025
  • Certificate Available
4.4
(81 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
4 Hour(s) 21 Minute(s)
Language
English
Taught by
Bigger Brains
Certificate
  • Available
  • *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
4.4
(81 Ratings)

Course Overview

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!

Course Content

  • 7 section(s)
  • 47 lecture(s)
  • Section 1 Linking and Consolidating
  • Section 2 Sharing and Protecting
  • Section 3 Automating
  • Section 4 Using Lookup Functions
  • Section 5 Auditing Formulas
  • Section 6 Forecasting Data
  • Section 7 More Features

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.

Skills covered in this course


Reviews

  • V
    Vivian Liang
    4.0

    I am familiar most of the features, but it's to know those legacy functions and file protection

  • I
    Ignacio Alfredo Panighetti
    4.0

    Excelent course, but, the only thing I can say is It hadn´t the correct resources for each section.

  • V
    Viviana Ochoa
    5.0

    really well explain with the most useful info for excel users

  • M
    Mark Grindol
    4.5

    This course is similar to the beginning and intermediate courses. Good coverage of advanced features in Excel and I learned things I didn't know about Excel. Covers creating Macros but not using VBA.

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed