Mastering Excel 2019 - Basics
4.4 (16 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,658 students enrolled

Mastering Excel 2019 - Basics

There are two kinds of people: Those who are masters at Excel, and those who wish they were
4.4 (16 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,658 students enrolled
Created by Chip Reaves
Last updated 5/2020
English
English
Current price: $27.99 Original price: $39.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4.5 hours on-demand video
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • 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 Conditional Formatting, Comparative Analysis Formatting, Cell Styles, and Themes
  • 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 multiple View features to compare multiple workbooks, compare worksheets, or save Custom Views.
  • Customize your instance of Excel including adding Groups to the Ribbon and modifying the Quick Access Toolbar.
Requirements
  • A copy of Microsoft Excel 2019 is recommended.
Description

There are two kinds of people: Those who are masters at Excel, and those who wish they were

When you master Excel, you have one of the most practical and valuable skillsets in modern business. A spreadsheet guru 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 2019.

Who this course is for:
  • People who have a basic knowledge of Microsoft® Windows® and want to learn beginner Excel 2019 skills to create and modify spreadsheets.
Course content
Expand all 41 lectures 04:26:03
+ Getting Started
9 lectures 55:18
Selecting Data
08:47
Using Commands
07:14
Creating a New Workbook
08:04
Entering Cell Data
05:59
Using AutoFill
07:27
Using Flash Fill
04:59
using Excel Help
02:05
+ Performing Calculations
4 lectures 33:11
Creating Formulas
07:57
Inserting Functions
08:14
Copying Formulas and Functions
07:09
Using Absolute Reference
09:51
+ Modifying Worksheets
3 lectures 23:41
Inserting and Deleting Cells
08:50
Searching and Replacing
07:54
Using Proofing and Research Tools
06:57
+ Formatting Worksheets
11 lectures 01:14:44
Applying Text Format
08:35
Applying Number Formats
07:24
Customizing Number Formats
07:46
Aligning Cell Contents
07:17
Applying Cell Styles
05:20
Applying Themes
03:48
Inserting Hyperlinks
06:30
Applying Conditional Formatting
06:45
Applying Conditional Formatting to Text and Dates
07:56
Applying Comparitive Analysis Formatting
07:22
Using Templates
06:01
+ Printing Workbooks
5 lectures 28:37
Printing Workbooks
04:12
Setting the Page Layout
06:34
Inserting page Breaks
08:38
Configuring Headers and Footers, Part 1
05:09
Configuring Headers and Footers, Part 2
04:04
+ Managing Workbooks
6 lectures 33:05
Managing Worksheets, Part 1
05:02
Managing Worksheets, Part 2
07:39
Creating a Custom View
03:47
Managing Worksheet Views
06:01
Managing Workbook Views
06:22
Managing Workbook Properties
04:14
+ Customizing options
3 lectures 17:27
Customizing General Options
04:35
Customizing the Ribbon
07:02
Customizing the Quick Access Toolbar
05:50