Microsoft Excel Beginners 2019

Video description

Discover Excel 2019 and become confident in using spreadsheets

About This Video

  • Learn Excel 2019 with practice exercises
  • Learn Creating workbooks, Entering text, numbers, Creating charts and graphs and lot more in this practical course

In Detail

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.

Publisher resources

Download Example Code

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

Product information

  • Title: Microsoft Excel Beginners 2019
  • Author(s): Simon Sez IT
  • Release date: August 2019
  • Publisher(s): Packt Publishing
  • ISBN: 9781839217654