Microsoft Excel Beginners 2019

Microsoft Excel Beginners 2019

by Simon Sez IT
Released August 2019
Publisher(s): Packt Publishing
ISBN: 9781839217654

Explore a preview version of Microsoft Excel Beginners 2019 right now.

O’Reilly members get unlimited access to live online training experiences, plus books, videos, and digital content from 200+ publishers.

Start your free trial

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 00:01:01
    2. What's New In Excel 2019 00:07:53
    3. Course Overview 00:01:17
    4. Overview of the Excel window 00:08:26
    5. Mouse-Features 00:03:13
    6. Back Stage View 00:02:37
  2. Chapter 2 : Creating Workbooks
    1. Entering Text and Numbers 00:04:32
    2. Creating Basic Formulas 00:06:49
    3. Relative References 00:03:01
    4. Order of Operations 00:04:48
    5. Working with Ranges 00:04:13
    6. Module 2 - Practice Exercise 00:01:36
  3. Chapter 3 : Saving Workbooks
    1. Working with the Save and Save As Commands 00:04:34
    2. File Extensions, Share, Export and Publish Files 00:03:44
    3. Module 3 - Practice Exercise 00:00:59
  4. Chapter 4 : Navigating Workbooks
    1. Opening a File 00:05:33
    2. Working with Larger Files 00:05:34
    3. Freeze Panes Option 00:03:16
    4. Split Screen Option 00:03:22
    5. Module 4 - Practice Exercise 00:02:50
  5. Chapter 5 : Page Setup & Print Options
    1. Headers and Footers 00:07:24
    2. Print Titles 00:02:52
    3. Comments 00:05:23
    4. Page Setup Options 00:07:30
    5. Fit to Print on One Page 00:03:59
    6. Printing Workbooks 00:03:55
    7. Module 5 - Practice Exercise 00:01:53
  6. Chapter 6 : Working with Rows, Columns and Cells
    1. Adding and deleting rows columns and cells 00:06:12
    2. Changing Column and-Row Widths 00:03:46
    3. Module 6 - Practice Exercise 00:01:12
  7. Chapter 7 : Moving Data
    1. Cut Copy and Paste 00:07:08
    2. Copying Formulas 00:05:09
    3. Module 7 - Practice Exercise 00:01:21
  8. Chapter 8 : Formulas & Functions
    1. Overview of Formulas 00:02:48
    2. Create Formulas Using Functions part1 00:10:04
    3. Create Formulas Using Functions part 2 00:05:23
    4. Absolute Values 00:05:16
    5. Module 8 - Practice Exercise 00:01:20
  9. Chapter 9 : Working with Sheets
    1. Adding Deleting and Renaming Sheets 00:04:09
    2. Additional Sheet Tab Options 00:05:19
    3. 3 Dimensional Formulas 00:05:28
    4. Module 9 - Practice Exercise 00:01:32
  10. Chapter 10 : Formatting Worksheets
    1. Formatting Cells part 1 00:10:04
    2. Formatting Cells part 2 00:03:37
    3. Formatting Numbers 00:09:23
    4. Borders and Shading 00:07:08
    5. Format as Table 00:06:07
    6. Using Styles 00:03:48
    7. Using Format Painter 00:04:28
    8. Protecting Sheets 00:08:59
    9. Fill Handle and Custom Lists 00:07:18
    10. Module 10 - Practice Exercise 00:01:10
  11. Chapter 11 : Charts
    1. Creating Charts 00:09:48
    2. Types of Charts 00:05:59
    3. Editing Charts Part 1 00:11:00
    4. Editing Charts Part 2 00:03:10
    5. Using Graphics to Enhance Charts 00:05:04
    6. Linking Chart Titles 00:02:47
    7. Module 11 - Practice Exercise 00:00:54
  12. Chapter 12 : Working with Names
    1. Creating Range Names 00:07:46
    2. Managing Names 00:03:17
    3. Using Names in Formulas 00:05:59
    4. Module 12 - Practice Exercise 00:01:21
  13. Chapter 13 : Sorting and Filtering
    1. Remove Duplicates 00:07:46
    2. Sort Data 00:10:28
    3. Filter Data 00:07:38
    4. Advanced Filters 00:04:47
    5. Module 13 - Practice Exercise 00:00:55
  14. Chapter 14 : Outlining and Subtotaling
    1. Creating an Outline 00:06:01
    2. Subtotals 00:08:00
    3. Module 14 - Practice Exercise 00:01:08
  15. Chapter 15 : Working with Views
    1. Arranging Files 00:03:14
    2. New Window Option 00:02:45
    3. Custom Views 00:05:32
    4. Module 15 - Practice Exercise 00:01:07
  16. Chapter 16 : Linking Files
    1. Creating Formulas Between Files 00:06:35
    2. Working with Links 00:04:01
    3. Consolidating Data 00:05:16
    4. Module 16 - Practice Exercise 00:01:31
  17. Chapter 17 : Advanced Formula Creation
    1. If Statements 00:07:49
    2. VLookups 00:07:40
    3. Data Validation 00:08:13
    4. Formula Auditing 00:05:29
    5. Module 17 - Practice Exercise 00:01:20
  18. Chapter 18 : PivotTables
    1. PivotTables 00:09:36
    2. Pivot Charts 00:03:16
    3. Module 18 - Practice Exercise 00:00:56
  19. Chapter 19 : Additional Excel Features
    1. Slicers 00:04:41
    2. Goal Seeker 00:02:56
    3. Text to Columns 00:02:49
    4. Watch Window 00:02:32
    5. Customizing Ribbons and Tabs 00:03:25
    6. Module 18 - Practice Exercise 00:01:23
  20. Chapter 20 : Shortcuts
    1. Excel Shortcuts Every User Should Know 00:12:00
  21. Chapter 21 : Closing
    1. Closing Video 00:00:29

Product Information

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