Excel Courses for beginners| Learn Excel Online from beginners to advanced level

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

Created by : Rated :4.8 29046 views

Last Updated: 2024-11-13 05:11:37 English Course Type: Self Learning

Learn to master Excel from A-Z
How to become a professional Data Analyst
How to be a better, faster, stronger Excel user
How to land your first job as an Excel Expert
How to save hours of time and boost your productivity in Excel
How to find a value with VLOOKUP, HLOOKUP, INDEX, MATCH
How to use math, statistical, logic and text functions
How to use VBA and Macros
How to use VLOOKUP/HLOOKUP in formulas
How to create basic and advanced formulas
Mastering Pivot Tables
Creating Charts from your data

Early Bird Release for the full upcoming 2024 Microsoft Excel from A-Z: Beginner To Expert Course!

Please note! This is currently in Early Bird Beta access, meaning we are still going to be continually adding content to the course (even though we are already at over 13 hours of content!) Since we're still adding content and taking student feedback as we complete the course through the start of 2023, students who enroll now will get access to a wide variety of benefits!

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.

Basic Computer Skills

Students who want to learn and master Microsoft Excel

Section 1 : Introduction 7 Lectures 00:21:48
Lecture 1 :
Section Overview Preview
Lecture 2 :
What is Microsoft Excel?
Lecture 3 :
Who is this course for?
Lecture 4 :
Microsoft Excel Marketplace
Lecture 5 :
Microsoft Excel Job Opportunities
Lecture 6 :
Microsoft Excel Job Roles
Lecture 7 :
Course Resources
Section 2 : Getting Started with Excel 8 Lectures 00:20:09
Lecture 1 :
Excel's Start Screen
Lecture 2 :
Explaining the Excel Interface
Lecture 3 :
Excel Interface Continued
Lecture 4 :
Excel Workbook vs Excel Worksheet
Lecture 5 :
Saving & Opening Excel Documents
Lecture 6 :
Customizing the Excel Quick Access Toolbar
Lecture 7 :
Customizing the Excel Ribbon
Lecture 8 :
Excel Shortcut Keys
Section 3 : Values, Referencing and Formulas 6 Lectures 00:29:49
Lecture 1 :
Creating Excel Labels
Lecture 2 :
Entering Numeric Values in Excel
Lecture 3 :
Formatting Date Values in Excel
Lecture 4 :
Building Basic Formulas in Excel
Lecture 5 :
Order of Operations
Lecture 6 :
Relative vs Absolute Cell References
Section 4 : Intro to Excel Functions 5 Lectures 00:20:45
Lecture 1 :
Excel Functions Explained
Lecture 2 :
The SUM() Function
Lecture 3 :
The MIN() & MAX() Function
Lecture 4 :
The AVERAGE() Function
Lecture 5 :
COUNT() Functions
Section 5 : Adjusting Excel Worksheets 8 Lectures 00:35:01
Lecture 1 :
Moving & Copying Data
Lecture 2 :
Insert & Delete Rows/Columns
Lecture 3 :
Adjusting the Width & Height of Cells
Lecture 4 :
Hiding and Unhiding Excel Rows and Columns
Lecture 5 :
Renaming, Moving & Deleting Excel Worksheets
Lecture 6 :
Adding Protection to Specific Cells
Lecture 7 :
Protecting the Structure of a Workbook
Lecture 8 :
Adding a Workbook Password to Open File
Section 6 : Visually Pleasing Cell Formatting 7 Lectures 00:34:00
Lecture 1 :
Formatting Fonts and Cell Background Color
Lecture 2 :
Adding Cell Borders
Lecture 3 :
Formatting Data Appropriately
Lecture 4 :
The Magic behind Excel's Format Painter
Lecture 5 :
Creating Styles for Formatting Efficiency
Lecture 6 :
Merging Cells for a Cleaner Look
Lecture 7 :
The Power of Conditional Formatting
Section 7 : How to insert Images and Shapes! 3 Lectures 00:18:55
Lecture 1 :
Grab User’s Attention using Illustrations
Lecture 2 :
Customizing Icons
Lecture 3 :
Create Compelling Graphics with SmartArt
Section 8 : Visualize Data with Charts 5 Lectures 00:22:23
Lecture 1 :
The Commonly used Column Chart
Lecture 2 :
Changing the Chart Design
Lecture 3 :
Formatting Elements of a Chart
Lecture 4 :
Modifying the Data, Type & Location of a Chart
Lecture 5 :
Little Slice of Pie Charts
Section 9 : Excel's Printing Options 4 Lectures 00:16:07
Lecture 1 :
Print Preview Options
Lecture 2 :
Excel's Page Layout View
Lecture 3 :
Printing a Specific Range of Cells
Lecture 4 :
Converting Spreadsheets to PDF Files
Section 10 : Benefits of Using Excel Templates 2 Lectures 00:06:44
Lecture 1 :
Why Create an Excel Template
Lecture 2 :
How to Create an Excel Template
Section 11 : Working with Excel Datasets 8 Lectures 00:35:22
Lecture 1 :
How to Prepare Data for Analysis
Lecture 2 :
How to Sort Data in Excel
Lecture 3 :
Multi-Level Sorting
Lecture 4 :
Custom Sorting Datasets in Excel
Lecture 5 :
Applying Filters to Datasets
Lecture 6 :
Creating Subtotals within a Dataset
Lecture 7 :
Converting Datasets into Tables
Lecture 8 :
Finding & Removing Duplicate Values
Section 12 : Excel Database Functions 4 Lectures 00:30:43
Lecture 1 :
The SUMIF() Function
Lecture 2 :
The DSUM() Function
Lecture 3 :
DSUM() Function Cont.
Lecture 4 :
The SUBTOTAL() Function
Section 13 : Excel Data Validation 6 Lectures 00:33:22
Lecture 1 :
What is Excel Data Validation?
Lecture 2 :
Creating a Drop Down List with Data Validation
Lecture 3 :
Different Types of Excel Data Validation
Lecture 4 :
Adding Custom Alerts to Data Validation
Lecture 5 :
Creating a Dynamic Drop Down List
Lecture 6 :
Complex Validation: Dependent Drop Down List!
Section 14 : Excel Pivot Table 5 Lectures 00:27:35
Lecture 1 :
Creating an Excel Pivot Table
Lecture 2 :
Modifying Excel PivotTables
Lecture 3 :
Grouping & Filtering PivotTable Data
Lecture 4 :
Drilling Down into PivotTable Data
Lecture 5 :
Creating Pivot Charts & Utilizing Slicers
Section 15 : Excel's PowerPivot Add--In 5 Lectures 00:24:36
Lecture 1 :
What is PowerPivot?
Lecture 2 :
Activating the Excel PowerPivot Add-In
Lecture 3 :
Creating Relationships between Data Tables
Lecture 4 :
Using Data Models to Create PivotTables
Lecture 5 :
How to Create PowerPivot KPI’s
Section 16 : Excel's Condtionals Functions 6 Lectures 00:31:31
Lecture 1 :
Excel’s IF() Function
Lecture 2 :
IF() Function with AND() Criteria
Lecture 3 :
IF() Function with OR() Criteria
Lecture 4 :
Nesting Multiple IF() Functions
Lecture 5 :
The COUNTIF() Function
Lecture 6 :
Key Benefits of Named Ranges
Section 17 : Excel's Lookup Functions 7 Lectures 00:38:09
Lecture 1 :
VLOOKUP() Function
Lecture 2 :
The Beauty of Excel’s IFERROR() Function
Lecture 3 :
HLOOKUP() Function
Lecture 4 :
INDEX() Function
Lecture 5 :
MATCH() Function
Lecture 6 :
INDEX() and MATCH() Combined
Lecture 7 :
Two-Way Lookup with INDEX() and MATCH()
Section 18 : Text Based Functions in Excel 4 Lectures 00:31:45
Lecture 1 :
LEFT(), RIGHT() and MID() Function
Lecture 2 :
Extracting Specific Text using LEN() & SEARCH()
Lecture 3 :
Combining Text with CONCATENATE()
Lecture 4 :
Quick Tips & Other Text Based Functions
Section 19 : Auditing Formulas & Custom Views in Excel 6 Lectures 00:19:45
Lecture 1 :
Tracing Precedents & Dependents in Formulas
Lecture 2 :
Showing Formulas
Lecture 3 :
Grouping Data
Lecture 4 :
3D Referencing in Formulas
Lecture 5 :
Utilizing the Watch Window in Excel
Lecture 6 :
How to Freeze Panes in Excel
Section 20 : Excel's What if? Tools 4 Lectures 00:27:32
Lecture 1 :
Excel’s Scenario Manager Tool
Lecture 2 :
Goal Seek in Excel
Lecture 3 :
Compare Results with Excel Data Tables
Lecture 4 :
Solver Tool
Section 21 : Welcome to Excel VBA! 4 Lectures 00:17:55
Lecture 1 :
The Power Behind Excel VBA
Lecture 2 :
A Look Inside the Visual Basic Editor (VBE)
Lecture 3 :
Recording a Macro
Lecture 4 :
Saving & Opening a Macro-Enabled Workbook
Section 22 : The VBA Language 3 Lectures 00:17:09
Lecture 1 :
Modules and Procedures
Lecture 2 :
Objects, Methods and Properties
Lecture 3 :
Excel VBA Variables
Section 23 : Writing VBA Code 5 Lectures 00:42:04
Lecture 1 :
Referencing a Range
Lecture 2 :
Using Variables in VBA Code
Lecture 3 :
If Then Else Statement
Lecture 4 :
Worksheet Functions inside VBA
Lecture 5 :
User Defined Functions within VBA Scripts
Section 24 : Important VBA Tools and Logic 5 Lectures 00:27:08
Lecture 1 :
Find Last Row of Data
Lecture 2 :
Find Last Column of Data
Lecture 3 :
With Statement
Lecture 4 :
Debugging & Error Handling
Lecture 5 :
Debugging & Error Handling cont.
Section 25 : Excel VBA Loops 3 Lectures 00:18:51
Lecture 1 :
For Next Loop
Lecture 2 :
Do Until Loop
Lecture 3 :
For Each Loop
Section 26 : Triggering Macros 5 Lectures 00:24:53
Lecture 1 :
Assigning Macros to Shapes
Lecture 2 :
Form Controls vs ActiveX Controls
Lecture 3 :
Worksheet Events
Lecture 4 :
Workbook Events
Lecture 5 :
Fun with VBA Events!
Section 27 : Excel User Forms 7 Lectures 00:42:35
Lecture 1 :
Creating an Excel UserForm
Lecture 2 :
Adding Controls to UserForms
Lecture 3 :
Passing TextBox Values to Desired Cells
Lecture 4 :
Passing Option Buttons to Desired Cells
Lecture 5 :
UserForm ComboBoxes
Lecture 6 :
Clearing Values from UserForm Controls
Lecture 7 :
UserForms and Protected Sheets
Section 28 : Starting a Career in Excel 8 Lectures 00:44:47
Lecture 1 :
Creating an Excel Resume
Lecture 2 :
Getting Started with Freelancing
Lecture 3 :
How to Become an Excel Freelancer
Lecture 4 :
Top Freelance Websites
Lecture 5 :
How to Get Your First Client
Lecture 6 :
Personal Branding
Lecture 7 :
Networking Do's and Don'ts
Lecture 8 :
Importance of Having a Website

How do i access the course after purchase?
It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time.
Are these video based online self-learning courses?
Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
Can i play & pause the course as per my convenience?
Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
How do i contact the instructor for any doubts or questions?
Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
Do i need a pc to access the course or can i do it on mobile & tablet as well?
Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
Do i get any certificate for the courses?
Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.
For how long can i access my course on the platform?
You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions.
Is there any free trial?
Currently, we do not offer any free trial.
Can i cancel anytime?
Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?

Juan Galvan,

680820 Course Views

16 Courses

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'm currently a Digital Marketing Consultant and help businesses all over the world generate more leads and sales through digital marketing strategies. â€‹ 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.