0

ecommerce/course.login

ecommerce/course.or, ecommerce/course.create_accountCreate an account in checkout page
Excel

Excel Beginners

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.

4.2
(313 ratings) 1030 students



Enroll now


What 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

Who should take this training

Prerequisites

  • No ! This course gets you started from Beginning if you are unfamiliar with Excel

Target audience

  • This course is suitable for Windows users

About this training

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.

Course Format

This is a video-led training course. You can preview some videos in the pane above. This course includes practice exercises so you can practice as you learn. This course is suitable for Windows users.This course is also suitable for Office 365 users.

Course Language : EN
On-demand video
Full lifetime access to videos
Downloadable resources
Assignments
Certificate of Completion
Enroll now

Training options

Only Videos

$ 30

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • Hours of Individual Coaching

Blended

$ 290

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • 10 Hours of Individual Coaching
Save 10%

Blended

$ 520 $ 495

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • 20 Hours of Individual Coaching
Save 20%

Blended

$ 810 $ 648

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • 30 Hours of Individual Coaching

Course Content

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

Request more information

Similar courses

Join our mail list for news