Juan E. Galvan

Learn 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!

2 enrolled

$9.99 $129.99

Limited time offer.

watching now

5 Students

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’ll have access to the full functionality of Excel, and will know how to use all formulas, functions, and capabilities.

You’ll 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.

The course covers 4 main areas:

1: INTRO TO EXCEL

This intro section gives you a full introduction to Microsoft Excel, the data analyst industry and marketplace, job opportunities and salaries, and the various Excel-related job roles.

Intro to Microsoft Excel
Excel Industry and Marketplace
Excel Job Opportunities
Getting Started with Excel
Excel Functions

2: INTERMEDIATE EXCEL

This section gives you a full introduction to the Intermediate Excel functions with hands-on step by step training.

Data Visualization
Datasets
Databases
Data Validation
PivotTables
Conditional Functions
Lookup Functions
Formulas, + more!

3: EXCEL MACROS & VBA

This section gives you a full introduction to the Excel Macros and VBA with hands-on step by step training.

VBA Language
VBA Code
VBA Loops
Macros
User Forms

4: STARTING AN EXCEL CAREER

This section gives you a full introduction to starting a career as an Excel Programmer with hands-on step by step training.

Creating a Resume
Freelancing + Freelance websites
How To Get Your 1st Client
Personal Branding
Importance of Having a Website
Networking
By the end of the course you’ll be a professional Excel programmer and confidently apply for jobs and feel good knowing that you have the skills and knowledge to back it up.

Show More Show Less

What Will You Learn?

Learn to master Excel from A-Z

How to be a better, faster, stronger Excel user

How to save hours of time and boost your productivity in Excel

How to use math, statistical, logic and text functions

How to use VLOOKUP/HLOOKUP in formulas

Requirements

Basic computer skills

NFT Certificate

153 Lessons

Beginner

English

+100 XP

Share Course on Social media

Curriculum

Course consist of total 12h 45min of content, in total.

Section 1: Introduction

23:16

Intro To Excel Course Section Overview

03:21

What is Microsoft Excel?

04:16

Who is this course for?

03:30

Microsoft Excel Marketplace

04:09

Microsoft Excel Job Opportunities

04:09

Microsoft Excel Job Roles

03:51

Section 2: Getting Started with Excel

21:04

Finding & Opening Microsoft Excel

01:04

Excel's Start Screen

03:15

Explaining the Excel Interface

02:43

Excel Interface Continued

01:26

Excel Workbook vs Excel Worksheet

02:13

Saving & Opening Excel Documents

03:21

Customizing the Excel Quick Access Toolbar

02:15

Customizing the Excel Ribbon

03:04

Excel Shortcut Keys

01:43

Section 3: Values, Referencing and Formulas

27:56

Creating Excel Labels

01:43

Entering Numeric Values in Excel

03:25

Formatting Date Values in Excel

05:19

Building Basic Formulas in Excel

04:44

Order of Operations

05:21

Relative vs Absolute Cell References

07:24

Section 4: Intro to Excel Functions

13:17

Excel Functions Explained

02:35

The MIN() & MAX() Function

03:44

The AVERAGE() Function

02:01

COUNT() Functions

04:57

Section 5: Adjusting Excel Worksheets

35:03

Moving & Copying Data

06:45

Insert & Delete Rows/Columns

05:04

Adjusting the Width & Height of Cells

04:34

Hiding and Unhiding Excel Rows and Columns

04:28

Renaming, Moving & 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

Section 6: Visually Pleasing Cell Formatting

34:05

Formatting Fonts and Cell Background Color

04:55

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

Section 7: How to insert Images and Shapes!

18:56

Grab User’s Attention using Illustrations

08:39

Customizing Icons

04:41

Create Compelling Graphics with SmartArt

05:36

Section 8: Visualize Data with Charts

22:26

The Commonly used Column Chart

02:46

Changing the Chart Design

01:58

Formatting Elements of a Chart

06:24

Modifying the Data, Type & Location of a Chart

06:06

Little Slice of Pie Charts

05:12

Section 9: Excel's Printing Options

16:09

Print Preview Options

04:26

Excel's Page Layout View

06:37

Printing a Specific Range of Cells

02:38

Converting Spreadsheets to PDF Files

02:28

Section 10: Benefits of Using Excel Templates

06:45

Why Create an Excel Template

01:23

How to Create an Excel Template

05:22

Section 11: Working with Excel Datasets

35:27

How to Prepare Data for Analysis

04:01

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 & Removing Duplicate Values

07:29

Section 12: Excel Database Functions

30:04

The SUMIF() Function

08:42

The DSUM() Function

07:47

DSUM() Function Cont.

07:06

The SUBTOTAL() Function

06:29

Section 13: Excel Data Validation

33:25

What is Excel Data Validation?

01:56

Creating a Drop Down List with Data Validation

07:09

Different Types of Excel 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

Section 14: Excel PivotTables

27:32

Creating an Excel Pivot Table

05:31

Modifying Excel PivotTables

05:31

Grouping & Filtering PivotTable Data

06:30

Drilling Down into PivotTable Data

02:00

Creating PivotCharts & Utilizing Slicers

08:00

Section 15: Excel's PowerPivot Add-In

24:39

What is PowerPivot?

03:46

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 KPI’s

08:26

Section 16: Excel's Conditional Functions

31:35

Excel’s IF() Function

05:17

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 Named Ranges

04:11

Section 17: Excel's Lookup Functions

38:14

VLOOKUP() Function

09:00

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

Section 18: Text Based Functions in Excel

31:46

LEFT(), RIGHT() and MID() Function

07:08

Extracting Specific Text using LEN() & SEARCH()

12:44

Combining Text with CONCATENATE()

06:05

Quick Tips & Other Text Based Functions

05:49

Section 19: Auditing Formulas & Custom Views in Excel

19:47

Tracing Precedents & Dependents in Formulas

04:28

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

Section 20: Excel’s “What If?” Tools

27:33

Excel’s Scenario Manager Tool

05:55

Goal Seek in Excel

06:15

Compare Results with Excel Data Tables

04:24

Solver Tool

10:59

Section 21: Welcome to Excel VBA!

17:57

The Power Behind Excel VBA

02:35

A Look Inside the Visual Basic Editor (VBE)

03:57

Recording a Macro

09:11

Saving & Opening a Macro-Enabled Workbook

02:14

Section 22: The VBA Language

17:12

Modules and Procedures

06:34

Objects, Methods and Properties

05:59

Excel VBA Variables

04:39

Section 23: Writing VBA Code

55:11

Referencing a Range

13:30

InputBox & 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

07:32

User Defined Functions within VBA Scripts

06:09

Section 24: Important VBA Tools and Logic

27:10

Find Last Row of Data

05:46

Find Last Column of Data

03:12

With Statement

04:51

Debugging & Error Handling

06:36

Debugging & Error Handling Cont.

06:45

Section 25: Excel VBA Loops

18:51

For Next Loop

09:12

Do Until Loop

06:03

For Each Loop

03:36

Section 26: Triggering Macros

24:56

Assigning Macros to Shapes

03:33

Form Controls vs ActiveX Controls

07:50

Worksheet Events

03:44

Workbook Events

02:54

Fun with VBA Events!

06:55

Section 27: Excel UserForms

47:11

Creating an Excel UserForm

03:15

Adding Controls to UserForms

10:00

How to Show an UserForm

03:01

Passing TextBox Values to Desired Cells

06:37

Passing Option Buttons 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

Section 28: Starting a Career in Excel

38:02

Creating an Excel Resume

04:51

Getting Started with Freelancing

06:16

Top Freelance Websites

05:12

Personal Branding

00:00

Networking Do's and Don'ts

04:22

Importance of Having a Website

04:24

How to Become an Excel Freelancer

05:12

Getting your First Client

07:45

About the Instructor

Juan E. Galvan

Hi I'm Juan. I've been an Entrepreneur since grade school. I've started several companies, created many products and sold on various online marketplaces with great success.

I've learned the strategies, philosophies, methodologies, principles and core values from the most successful people in the world.

I believe in continuous education with the best of a University Degree without all the downsides of burdensome costs and inefficient methods.

See All Instructor Courses

BitDegree platform reviews

EXCLUSIVE OFFER: GET 25% OFF

Save Big With DataCamp Promo Code

Days

Hours

Minutes

Seconds

GET 25% OFF