Microsoft Excel Beginners 2019

Table of Contents

Chapter 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

Chapter 2 : Creating Workbooks

Entering Text and Numbers

Creating Basic Formulas

Relative References

Order of Operations

Working with Ranges

Module 2 - Practice Exercise

Chapter 3 : Saving Workbooks

Working with the Save and Save As Commands

File Extensions, Share, Export and Publish Files

Module 3 - Practice Exercise

Chapter 4 : Navigating Workbooks

Opening a File

Working with Larger Files

Freeze Panes Option

Split Screen Option

Module 4 - Practice Exercise

Chapter 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

Chapter 6 : Working with Rows, Columns and Cells

Adding and deleting rows columns and cells

Changing Column and-Row Widths

Module 6 - Practice Exercise

Chapter 7 : Moving Data

Cut Copy and Paste

Copying Formulas

Module 7 - Practice Exercise

Chapter 8 : Formulas Functions

Overview of Formulas

Create Formulas Using Functions part1

Create Formulas Using Functions part 2

Absolute Values

Module 8 - Practice Exercise

Chapter 9 : Working with Sheets

Adding Deleting and Renaming Sheets

Additional Sheet Tab Options

3 Dimensional Formulas

Module 9 - Practice Exercise

Chapter 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

Chapter 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 - Practice Exercise

Chapter 12 : Working with Names

Creating Range Names

Managing Names

Using Names in Formulas

Module 12 - Practice Exercise

Chapter 13 : Sorting and Filtering

Remove Duplicates

Sort Data

Filter Data

Advanced Filters

Module 13 - Practice Exercise

Chapter 14 : Outlining and Subtotaling

Creating an Outline

Subtotals

Module 14 - Practice Exercise

Chapter 15 : Working with Views

Arranging Files

New Window Option

Custom Views

Module 15 - Practice Exercise

Chapter 16 : Linking Files

Creating Formulas Between Files

Working with Links

Consolidating Data

Module 16 - Practice Exercise

Chapter 17 : Advanced Formula Creation

If Statements

VLookups

Data Validation

Formula Auditing

Module 17 - Practice Exercise

Chapter 18 : PivotTables

PivotTables

Pivot Charts

Module 18 - Practice Exercise

Chapter 19 : Additional Excel Features

Slicers

Goal Seeker

Text to Columns

Watch Window

Customizing Ribbons and Tabs

Module 18 - Practice Exercise

Chapter 20 : Shortcuts

Excel Shortcuts Every User Should Know

Chapter 21 : Closing

Closing Video