Microsoft Excel Beginners 2019

Table of contents

1. Chapter 1 : Intro to Excel
   1. Intro to Excel
   2. What's New In Excel 2019
   3. Course Overview
   4. Overview of the Excel window
   5. Mouse-Features
   6. Back Stage View
2. Chapter 2 : Creating Workbooks
   1. Entering Text and Numbers
   2. Creating Basic Formulas
   3. Relative References
   4. Order of Operations
   5. Working with Ranges
   6. Module 2 - Practice Exercise
3. Chapter 3 : Saving Workbooks
   1. Working with the Save and Save As Commands
   2. File Extensions, Share, Export and Publish Files
   3. Module 3 - Practice Exercise
4. Chapter 4 : Navigating Workbooks
   1. Opening a File
   2. Working with Larger Files
   3. Freeze Panes Option
   4. Split Screen Option
   5. Module 4 - Practice Exercise
5. Chapter 5 : Page Setup Print Options
   1. Headers and Footers
   2. Print Titles
   3. Comments
   4. Page Setup Options
   5. Fit to Print on One Page
   6. Printing Workbooks
   7. Module 5 - Practice Exercise
6. Chapter 6 : Working with Rows, Columns and Cells
   1. Adding and deleting rows columns and cells
   2. Changing Column and-Row Widths
   3. Module 6 - Practice Exercise
7. Chapter 7 : Moving Data
   1. Cut Copy and Paste
   2. Copying Formulas
   3. Module 7 - Practice Exercise
8. Chapter 8 : Formulas Functions
   1. Overview of Formulas
   2. Create Formulas Using Functions part1
   3. Create Formulas Using Functions part 2
   4. Absolute Values
   5. Module 8 - Practice Exercise
9. Chapter 9 : Working with Sheets
   1. Adding Deleting and Renaming Sheets
   2. Additional Sheet Tab Options
   3. 3 Dimensional Formulas
   4. Module 9 - Practice Exercise
10. Chapter 10 : Formatting Worksheets
    1. Formatting Cells part 1
    2. Formatting Cells part 2
    3. Formatting Numbers
    4. Borders and Shading
    5. Format as Table
    6. Using Styles
    7. Using Format Painter
    8. Protecting Sheets
    9. Fill Handle and Custom Lists
    10. Module 10 - Practice Exercise
11. Chapter 11 : Charts
    1. Creating Charts
    2. Types of Charts
    3. Editing Charts Part 1
    4. Editing Charts Part 2
    5. Using Graphics to Enhance Charts
    6. Linking Chart Titles
    7. Module 11 - Practice Exercise
12. Chapter 12 : Working with Names
    1. Creating Range Names
    2. Managing Names
    3. Using Names in Formulas
    4. Module 12 - Practice Exercise
13. Chapter 13 : Sorting and Filtering
    1. Remove Duplicates
    2. Sort Data
    3. Filter Data
    4. Advanced Filters
    5. Module 13 - Practice Exercise
14. Chapter 14 : Outlining and Subtotaling
    1. Creating an Outline
    2. Subtotals
    3. Module 14 - Practice Exercise
15. Chapter 15 : Working with Views
    1. Arranging Files
    2. New Window Option
    3. Custom Views
    4. Module 15 - Practice Exercise
16. Chapter 16 : Linking Files
    1. Creating Formulas Between Files
    2. Working with Links
    3. Consolidating Data
    4. Module 16 - Practice Exercise
17. Chapter 17 : Advanced Formula Creation
    1. If Statements
    2. VLookups
    3. Data Validation
    4. Formula Auditing
    5. Module 17 - Practice Exercise
18. Chapter 18 : PivotTables
    1. PivotTables
    2. Pivot Charts
    3. Module 18 - Practice Exercise
19. Chapter 19 : Additional Excel Features
    1. Slicers
    2. Goal Seeker
    3. Text to Columns
    4. Watch Window
    5. Customizing Ribbons and Tabs
    6. Module 18 - Practice Exercise
20. Chapter 20 : Shortcuts
    1. Excel Shortcuts Every User Should Know
21. Chapter 21 : Closing
    1. Closing Video