Learn the Essentials of Microsoft Excel 2019/365

This 7-hour Microsoft Excel 2019 course is perfect for those brand new to Excel and who are using Excel 2019 or Excel 365 editions. In this course, your expert author gives you a solid grounding in the basics of Excel and guides you towards becoming more confident with spreadsheets.

What You'll Learn

  • What's new in Excel 2019
  • Creating workbooks
  • Entering text, numbers and working with dates
  • Navigating workbooks
  • Page setup and print options
  • Working with rows, columns and cells
  • Cut, Copy and Paste
  • Introduction to Functions and Formulas
  • Formatting in Excel, including formatting cells and numbers
  • Creating charts and graphs
  • Sorting and Filtering
  • Introduction to PivotTables
  • Logical and lookup formulas - the basics

Course curriculum

  • 1

    Intro to Excel

    • Intro to Excel

    • What's New In Excel 2019

    • Course Overview

    • Overview of the Excel window

    • Mouse-Features

    • Back Stage View
  • 2

    Creating Workbooks

    • Entering Text and Numbers

    • Creating Basic Formulas

    • Relative References

    • Relative References

    • Order of Operations

    • Working with Ranges

    • Module 2 - Practice Exercise
  • 3

    Saving Workbooks

    • Working with the Save and Save-As Commands

    • File Extensions, Share, Export & Publish Files

    • Module 3 - Practice Exercise
  • 4

    Navigating Workbooks

    • Opening a File

    • Working with Larger Files

    • Freeze Panes Option

    • Split Screen Option

    • Module 4 - Practice Exercise
  • 5

    Page Setup & Print Options

    • Headers and Footers

    • Print Titles

    • Comments

    • Page Setup Options

    • Fit to Print on One Page

    • Printing Workbooks

    • Module 5 - Practice Exercise
  • 6

    Working with Rows, Columns and Cells

    • Adding and deleting rows colum

    • Changing Column and Row Width

    • Module 6 - Practice Exercise
  • 7

    Moving Data

    • Cut Copy and Paste

    • Copying Formulas

    • Module 7 - Practice Exercise
  • 8

    Formulas & Functions

    • Overview of Formulas

    • Create Formulas Using Functions - Part 1

    • Create Formulas Using Functions - Part 2

    • Absolute Values

    • Module 8 - Practice Exercise
  • 9

    Working with Sheets

    • Adding Deleting and Renaming

    • Additional Sheet Tab Options

    • 3 Dimensional Formulas

    • Module 9 - Practice Exercise
  • 10

    Formatting Worksheets

    • Formatting Cells part 1

    • Formatting Cells part 2

    • Formatting Numbers

    • Borders and Shading

    • Format as Table

    • Using Styles

    • Using Format Painter

    • Protecting Sheets

    • Fill Handle and Custom Lists

    • Module 10 - Practice Exercise
  • 11

    Charts

    • Creating Charts

    • Types of Charts

    • Editing Charts part 1

    • Editing Charts part 2

    • Using Graphics to Enhance Charts

    • Linking Chart Titles

    • Module 11 - Exercise
  • 12

    Working with Names

    • Creating Range Names

    • Managing Names

    • Using Names in Formulas

    • Module 12 - Exercise
  • 13

    Sorting and Filtering

    • Remove Duplicates

    • Sort Data

    • Filter Data

    • Advanced Filters

    • Module 13 - Exercise
  • 14

    Outlining and Subtotaling

    • Creating an Outline

    • Subtotals

    • Module 14- Exercise
  • 15

    Working with Views

    • Arranging Files

    • New Window Option

    • Custom Views

    • Module 15 - Exercise
  • 16

    Linking Files

    • Creating Formulas Between Files

    • Working with Links

    • Consolidating Data

    • Module 16 - Exercise
  • 17

    Advanced Formula Creation

    • If Statements

    • VLookups

    • Data Validation

    • Formula Auditing

    • Module 17 - Exercise
  • 18

    PivotTables

    • Pivot Tables

    • Pivot Charts

    • Module 18 - Exercise
  • 19

    Additional Excel Features

    • Slicers

    • Goal Seeker

    • Text to Columns

    • Watch Window

    • Customizing Ribbons and Tabs

    • Module 19 - Exercise
  • 20

    Shortcuts

    • Excel Shortcuts Every User Should Know
  • 21

    Exercise Files

    • Exercise Files