Log in
Log inBook a demo

Microsoft Excel 2019 Beginners

COURSE
Simon Sez IT
7 hrs 30 mins

Microsoft Excel 2019 Beginners

COURSE
Simon Sez IT
7 hrs 30 mins
Included in GO1 PremiumStarting from $12 per user for teamsLearn moreTry for free
Included in GO1 PremiumStarting from $12 per user for teamsLearn moreTry for free

Course Overview

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.

Target Audience

Administrators, Graduates, people in Financial Services, Accountancy.

Learning Objectives

In this course you will 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
Learning
Chapter 1: Intro to Excel
Intro to Excelvideo
What's New In Excel 2019video • 8 mins
Course Overviewvideo
Overview of the Excel windowvideo • 9 mins
Mouse-Featuresvideo • 4 mins
Back Stage Viewvideo • 3 mins
Course Exercise Filestext
Chapter 2: Creating Workbooks
Entering Text and Numbersvideo • 5 mins
Creating Basic Formulasvideo • 7 mins
Relative Referencesvideo • 4 mins
Order of Operationsvideo • 5 mins
Working with Rangesvideo • 5 mins
Module 2 - Practice Exercisevideo
Chapter 3: Saving Workbooks
Working with the Save and Save As Commandsvideo • 5 mins
File Extensions, Share, Export and Publish Filesvideo • 4 mins
Module 3 - Practice Exercisevideo
Chapter 4: Navigating Workbooks
Opening a Filevideo • 6 mins
Working with Larger Filesvideo • 6 mins
Freeze Panes Optionvideo • 4 mins
Split Screen Optionvideo • 4 mins
Module 4 - Practice Exercisevideo
Chapter 5: Page Setup & Print Options
Headers and Footersvideo • 8 mins
Print Titlesvideo • 3 mins
Commentsvideo • 6 mins
Page Setup Optionsvideo • 8 mins
Fit to Print on One Pagevideo • 4 mins
Printing Workbooksvideo • 4 mins
Module 5 - Practice Exercisevideo
Chapter 6: Working with Rows, Columns and Cells
Adding and deleting rows columns and cellsvideo • 7 mins
Changing Column and Row Widthsvideo • 4 mins
Module 6 - Practice Exercisevideo
Chapter 7: Moving Data
Cut Copy and Pastevideo • 8 mins
Copying Formulasvideo • 6 mins
Module 7 - Practice Exercisevideo
Chapter 8: Formulas & Functions
Overview of Formulasvideo • 3 mins
Create Formulas Using Functions part1video • 11 mins
Create Formulas Using Functions part-2video • 6 mins
Absolute Valuesvideo • 6 mins
Module 8 - Practice Exercisevideo
Chapter 9: Working with Sheets
Adding Deleting and Renaming Sheetsvideo • 5 mins
Additional Sheet Tab Optionsvideo • 6 mins
3 Dimensional Formulasvideo • 6 mins
Module 9 - Practice Exercisevideo
Chapter 10: Formatting Worksheets
Formatting Cells part 1video • 11 mins
Formatting Cells part 2video • 4 mins
Formatting Numbersvideo • 10 mins
Borders and Shadingvideo • 8 mins
Format as Tablevideo • 7 mins
Using Stylesvideo • 4 mins
Using Format Paintervideo • 5 mins
Protecting Sheetsvideo • 10 mins
Fill Handle and Custom Listsvideo • 8 mins
Module 10 - Practice Exercisevideo
Chapter 11: Charts
Creating Chartsvideo • 10 mins
Types of Chartsvideo • 6 mins
Editing Charts Part 1video • 11 mins
Editing Charts Part 2video • 4 mins
Using Graphics to Enhance Chartsvideo • 6 mins
Linking Chart Titlesvideo • 3 mins
Module 11 - Practice Exercisevideo
Chapter 12: Working with Names
Creating Range Namesvideo • 8 mins
Managing Namesvideo • 4 mins
Using Names in Formulasvideo • 6 mins
Module 12 - Practice Exercisevideo
Chapter 13: Sorting and Filtering
Remove Duplicatesvideo • 8 mins
Sort Datavideo • 11 mins
Filter Datavideo • 8 mins
Advanced Filtersvideo • 8 mins
Module 13 - Practice Exercisevideo
Chapter 14: Outlining and Subtotaling
Creating an Outlinevideo • 7 mins
Subtotalsvideo • 8 mins
Module 14 - Practice Exercisevideo
Chapter 15: Working with Views
Arranging Filesvideo • 4 mins
New Window Optionvideo • 3 mins
Custom Viewsvideo • 6 mins
Module 15 - Practice Exercisevideo
Chapter 16: Linking Files
Creating Formulas Between Filesvideo • 7 mins
Working with Linksvideo • 5 mins
Consolidating Datavideo • 6 mins
Module 16 - Practice Exercisevideo
Chapter 17: Advanced Formula Creation
If Statementsvideo • 8 mins
VLookupsvideo • 8 mins
Data Validationvideo • 9 mins
Formula Auditingvideo • 6 mins
Module 17 - Practice Exercisevideo
Chapter 18: PivotTables
PivotTablesvideo • 10 mins
Pivot Chartsvideo • 4 mins
Module 18 - Practice Exercisevideo
Chapter 19: Additional Excel Features
Slicersvideo • 5 mins
Goal Seekervideo • 3 mins
Text to Columnsvideo • 3 mins
Watch Windowvideo • 3 mins
Customizing Ribbons and Tabsvideo • 4 mins
Module 19 - Practice Exercisevideo
Chapter 20: Shortcuts
Excel Shortcuts Every User Should Knowvideo • 12 mins
Chapter 21: Closing
Closing Videovideo
Chapter 22: Quiz
Course Quizquiz