2021 Microsoft Excel from A-Z: Beginner To Expert Course

Master pivot tables, formulas, macros, vba, data analysis and learn how to land your first job as an Excel expert!
Enroll Now $199 $19.99

Why Enroll?

Check out just a few key highlights for:
2021 Microsoft Excel from A-Z: Beginner To Expert Course.

15,501 Students

Join a community of other students taking this course.


Each lecture is recorded in HD 1920x1080p with clear audio.

4.8/5 Stars

All courses are rated by fellow community members.

More Benefits

Learning with YouAccel has several exciting benefits.

Clear HD Video

All YouAccel courses are recorded and produced in 1920x1080p HD Quality.

Live Support

Have a question? Contact our support team at any time using our chat feature, or built-in messaging console.


All YouAccel courses come with a Certificate of Completion. This helps Showcase your proficiency in a subject to prospective employers.

Lifetime Access

All YouAccel courses include lifetime on-demand access. Class lecture are also available for offline viewing.


Join a community of over 600,000 learners. Connect & Communicate through YouAccel's networking tools.

Job Pool

YouAccel's integration with Indeed makes it easy to search through thousands of jobs and apply with just a click.

Course Outline

A comprehensive list of all sections & lectures for this course can be found below.

Excel from A-Z Course Introduction

Introduction - 02:40 [Play]

Excel from A-Z Course Intro - 03:21

What is Microsoft Excel - 04:16

Who is This Course For - 03:30

Microsoft Excel Marketplace - 04:09

Excel Job Opportunities - 02:43

Excel Job Types - 03:51

Finding and Opening Excel - 01:04 [Play]

Excel_s Start Screen - 03:15

Explaining the Excel Interface - 02:43

Excel Interface Cont - 01:26

Excel Workbook vs. Excel Worksheet - 02:13

Saving and Opening Excel Documents - 03:33

Customizing the Quick Access Toolbar - 02:15

Customizing the Excel Ribbon - 03:04

Excel Shortcut Keys - 01:43

Creating Excel Labels - 02:32 [Play]

Entering Numeric Data in Excel - 03:25

Formatting Date Values in Excel - 05:19

Building Basic Formulas in Excel - 04:44

Order of Operation - 06:28

Relative vs Absolute Cell References - 07:24

Excel Functions Explained - 02:35 [Play]

The SUM Function - 07:31

The MIN and MAX Function - 03:44

The AVERAGE Function - 02:01

COUNT Functions - 04:57

Moving and Copying Data - 06:45 [Play]

Insert and Delete Rows and Columns - 05:04

Adjusting the Width and Height of Cells - 04:34

Hiding and Unhiding Excel Rows and Columns - 04:28

Renaming Moving and Deleting Excel Worksheets - 05:27

Adding Protection to Specific Cells - 04:24

Protecting the Structure of a Workbook - 02:11

Adding a Workbook Password to Open File - 02:10

Formatting Fonts and Cell Background Color - 04:55 [Play]

Adding Cell Borders - 04:47

Formatting Data Appropriately - 05:21

The Magic Behind Excel_s Format Painter - 03:30

Creating Styles for Formatting Efficiency - 05:56

Merging Cells for a Cleaner Look - 03:27

The Power of Conditional Formatting - 06:09

Grab Users Attention using Illustrations - 08:39 [Play]

Customizing Icons - 04:41

Create Compelling Graphics with SmartArt - 05:36

The Commonly Used Column Chart - 02:46 [Play]

Changing the Chart Design - 01:58

Formatting Elements of a Chart - 06:24

Modifying the Data Type and Location of a Chart - 06:06

Little Slice of Pie Charts - 05:12

Print Preview Options - 04:26 [Play]

Excels Page Layout View - 06:37

Printing a Specific Range of Cells - 02:38

Converting Spreadsheets to PDF Files - 02:28

Why Create an Excel Template - 01:23 [Play]

How to Create an Excel Template - 05:22

How to Prepare Data for Analysis - 04:01 [Play]

How to Sort Data in Excel - 02:38

Multi Level Sorting - 02:34

Custom Sorting Datasets in Excel - 02:27

Applying Filters to Datasets - 04:44

Creating Subtotals within a Dataset - 05:39

Converting Datasets into Tables - 05:55

Finding and Removing Duplicate Values - 07:29

The SUMIF Function - 08:42 [Play]

The DSUM Function - 07:47

The DSUM Function Cont - 07:06

The SUBTOTAL Function - 06:29

What is Excel Data Validation - 01:56 [Play]

Creating a Drop Down List with Data Validation - 07:09

Different Types of Data Validation - 05:39

Adding Custom Alerts to Data Validation - 06:53

Creating a Dynamic Drop Down List - 03:09

Complex Validation: Dependent Drop Down List! - 08:39

Creating an Excel Pivot Table - 05:31 [Play]

Modifying Excel Pivot Tables - 05:39

Grouping Filtering PivotTable Data - 06:30

Drilling Down into PivotTable Data - 02:00

Creating PivotCharts and Slicers - 08:00

What is PowerPivot - 03:46 [Play]

Activating the Excel PowerPivot Add-In - 01:34

Creating Relationships between Data Tables - 06:22

Using Data Models to Create PivotTables - 04:31

How to Create PowerPivot KPIs - 08:26

Excels IF Function - 05:17 [Play]

IF() Function with AND() Criteria - 05:23

IF() Function with OR() Criteria - 05:14

Nesting Multiple IF Functions - 07:24

The COUNTIF Function - 04:06

Key Benefits of Using Named Ranges - 04:11

VLOOKUP() Function - 09:00 [Play]

The Beauty of Excel's IFERROR() Function - 03:56

HLOOKUP() Function - 06:21

INDEX() Function - 04:43

MATCH() Function - 04:56

INDEX() and MATCH() Combined - 05:08

Two-Way Lookup with INDEX() and MATCH() - 04:10

LEFT(), RIGHT() and MID() Function - 07:08 [Play]

Extracting Specific Text using LEN() and SEARCH() - 12:44

Combining Text with CONCATENATE - 06:05

Quick Tips and Other Text Based Functions - 05:49

Tracing Precedents and Dependents in Formulas - 04:28 [Play]

Showing Formulas - 01:53

Grouping Data - 02:42

3D Referencing in Formulas - 05:04

Utilizing the Watch Window in Excel - 02:44

How to Freeze Panes in Excel - 02:56

Excel's Scenario Manager Tool - 05:55 [Play]

Goal Seek in Excel - 06:15

Compare Results with Excel Data Tables - 04:24

Solver Tool - 10:59

The Power Behind Excel VBA - 02:35 [Play]

A Look Inside the Visual Basic Editor (VBE) - 03:57

Recording a Macro - 09:11

Saving and Opening a Macro Enabled Workbook - 02:14

Modules and Procedures - 06:34 [Play]

Objects, Methods, and Properties - 05:59

Excel VBA Variables - 04:39

Referencing a Range - 13:30 [Play]

InputBox and MsgBox - 05:33

Using Variables in VBA Code - 04:32

If Then Else Statement - 10:23

Worksheet Functions inside VBA - 07:32

Creating User Defined Functions - 09:19

User Defined Functions within VBA Scripts - 06:09

Find Last Row of Data - 05:46 [Play]

Find Last Column of Data - 03:12

With Statement - 04:51

Debugging and Error Handling - 06:36

Debugging and Error Handling Cont - 06:45

For Next Loop - 09:12 [Play]

Do Until Loop - 06:03

For Each Loop - 03:36

Assigning Macros to Shapes - 03:33 [Play]

Form Controls vs Active X Controls - 07:50

Workbook Events - 02:54

Worksheet Events - 03:44

Fun with VBA Events - 06:55

Creating an Excel UserForm - 03:15 [Play]

Adding Controls to UserForms - 10:00

How to Show an UserForm - 03:01

Passing TextBox Values to Desired Cells - 06:37

Passing Option Buttons Values to Desired Cells - 06:50

UserForm ComboBoxes - 08:08

Clearing Values from UserForm Controls - 03:06

How to Close an UserForm - 01:34

UserForms and Protected Sheets - 04:40

Creating an Excel Resume - 04:51 [Play]

Getting Started with Freelancing - 06:16

How to Become an Excel Freelancer - 05:12

Top Freelance Sites - 05:12

Getting Your First Client - 07:45

Personal Branding - 06:47

Networking Do’s and Don’ts - 04:22

Importance of Website - 04:24

Course Description

Welcome to the Learn Microsoft Excel from A-Z: Beginner To Expert Course

In this practical, hands-on course our main objective is to give you the education not just to understand the ins and outs of Microsoft Excel, but also to learn exactly how to master pivot tables, formulas, macros, vba, data analysis, and how to land your first job as an Excel expert!

This course will fully prepare you for virtually any Excel related career path, including those that require advanced skills with this software. Once you complete the course, you will have access to the full functionality of Excel, and will know how to use all formulas, functions, and capabilities.

You will also learn about calculating depreciation, calculating interest, and even calculating EMI for loans, all by using Excel functions. The course also features information on INDEX and MATCH functions as well as using the CHOOSE formula, and how to create special charts.

Whether you are brand new to the world of Excel, or you have training and knowledge of the software and are looking to improve your skills, this masterclass will take you to the next level. By the time you finish the beginner, intermediate and advanced portions, you too will be an expert in Excel.

We understand that theory is important to build a solid foundation, we understand that theory alone isn't going to get the job done so that's why this course is packed with practical hands-on examples that you can follow step by step. Even if you already have some experience, or want to learn about the advanced features of Excel, this course is for you!

Together we're going to give you the foundational education that you need to know not just on how to use Excel at an expert level, but also how to get paid for your newly developed skills.

2021 Microsoft Excel from A-Z: Beginner To Expert Course

All course reviews are written by students who have completed the course or are currently enrolled.

Course Instructor - Juan Galvan

juan galvan
Teaching 12 Courses

juan galvan is currently teaching 12 courses. All courses are currently open for enrollment.

215,500 Enrollments

juan galvan currently has 215,500 global enrollments across 12 courses that are active on the platform.

4.5 Star Rating

juan galvan has an average rating of 4.5/5 stars, across 12 courses.

Hi I'm Juan. I've been an Entrepreneur since grade school. My background is in the tech space from Digital Marketing, E-commerce, Web Development to Programming. I believe in continuous education with the best of a University Degree without all the downsides of burdensome costs and inefficient methods. I look forward to helping you expand your skillsets.

All Courses include a 30-Day Satisfaction Guarantee.

You have nothing to lose. Give the course a try. If it's not what you expected, get a full refund within 30 days of purchase.