Complete Excel Foundation Course
Master fundamentals of Excel without the overwhelm with step-by-step tutorial videos. Covers Formulas, Functions, Pivot Table, Conditional Formatting and more.
What this Course Covers:
* 15.5 hours of step by step Excel tutorials
* 90 Excel project Files to follow along the video lessons
* Quizzes to review what you learn
* Follow along with any recent version of Excel. Specific Excel 365 features are clearly identified
Get started on this deep-dive course today!
What you will find in this Course:
Click to watch video below:
Comprehensive Training Program on Excel with Step by Step Videos, Exercise Files and Quiz.
What customers are saying about this Excel course:
Explained in very simple language. Easy to understand
Vishal Poddar
I have just started the training course and complete a few of the exercises. I can see, however, that this is going to be nothing short of an awesome program.
James Rapp
I am getting the complete basic knowledge of Excel
Yogiraj Chandratre, Computer Teacher
What others are saying about our Excel tutorials:
Yes, this is one of the best videos on Pivot Tables but beyond that, the way this information is arranged and the method used to convey it is clear and concise. Excellent material presented in an outstanding manner.
Mark Frank
I could not understand Index and Match although I watched many videos, but after watching this video, I’m not going to forget it in my life, this video made it so crystal clear.
Ganesh Prasad T P
Excellent videos !! Have watched so many videos but this one indeed best one and easy to understand with practical knowledge..
Prince Kamboj
Very exciting videos. You have a fabulous talent in Excel. Keep it rolling and sharing, so many more can learn.
Bwebwentekai Bob Kabuati
Well, I wasn't expecting that. I just love clever little tips like this.
Martin Craig
WHY THIS COURSE:
Hi! Welcome to Complete Excel Masterclass for Beginners.
Right up, let me answer the Big question you may have on your mind…
“Why another course on Excel, when there are tons of online excel courses already available, not to mention dozens of books and websites on Excel?”
Fair question.
The answer is… “This course is entertaining and practical – while most Excel courses on the market are boring and bookish”.
Let me explain…
There is no dearth of Excel experts in the market - who know the program inside and out.
But, can they teach you the program in a way you can understand and remember?
Can they make the subject simple enough for a beginner like you?
Unfortunately, the answer is ‘No’.
That’s why I made this course called ‘Complete Excel Masterclass for Beginners’.
It’s a fun and easy way to master Excel.
The course teaches you all that you need to learn about Excel as a Data professional, without the overwhelm.
WHAT THIS COURSE COVERS:
The course is massive with 15.5 hours of comprehensive video content, yet you’ll find that every topic is relevant to your work.
You can find the detailed course content when you scroll down. We purposely left out advanced topics like Excel VBA and Macros in this program, as the course is meant for beginners.
The course is easy to follow. I breakdown complex topics into simple, understandable, and useful lessons. The lessons are short and systematic, so you can easily fit them in your busy work schedule.
Every tool, formula and function in Excel is explained with simple analogies, practical examples, exercises and quizzes. I don’t stop at teaching you how to write a formula, I show you where you’d use it in real applications. You can watch some sample lessons from the program to evaluate my teaching style.
By the time you complete this course, you’ll feel confident of tackling any work assignment on Excel with ease.
You’ll save time on your work projects.
ABOUT ME
I did my MBA from a premier Management Institute in India.
I worked as a Senior Vice President and Head of two functions in a multinational bank.
I’ve been a professional trainer and an online course creator for the past 12 years.
I’ve been using Excel for the past 2 decades, and I bring all that experience to this course.
If after going through the course, you find that the content doesn’t live up to your expectation, you can ask for a 100% refund within 30 days.
So go ahead, enroll for this course and let's get started with Excel!
Sign Up Now: Complete Excel Masterclass for Beginners
Master fundamentals of Excel without the overwhelm with step-by-step tutorial videos. Covers Formulas, Functions, Pivot Table, Conditional Formatting and more.
Course Curriculum
Available in
days
days
after you sign up
- Welcome and Important Information
- All about getting Started with Excel (12:12)
- All About Working With Worksheets (8:43)
- All About Copy and Paste Functions (11:12)
- All About Free Excel Templates (5:16)
- [Excel Trick] Set Up Quick Access Toolbar (7:23)
- [Excel Trick] Create Your Own Tab (7:19)
- Quiz to Review Excel Basics
- Important Update for Customers Only
Available in
days
days
after you sign up
Available in
days
days
after you sign up
- How to Freeze Split Or Hide Rows & Columns (9:28)
- View 2 Excel Worksheets From the Same File (4:47)
- Arrange or View 2 Files Side by Side (5:18)
- [Excel Trick] Custom View in Excel (4:29)
- How to Hyperlink To Another Sheet (7:48)
- [Excel Trick] Create Table of Contents Fast (5:00)
- Quiz on Control Worksheet View
Available in
days
days
after you sign up
- Understanding Cell Reference In Excel (12:55)
- How to Use Autofill in Excel (14:29)
- 4 Things To Know About Flash Fill (12:42)
- Creating and Working with Named Ranges (12:51)
- How to Insert Cell Comments And Notes (7:01)
- Adding Excel Tooltip for Cells (3:57)
- Excel Speak Cells Feature (5:28)
- [Excel Trick] How to Remove Numbers from Text Strings (4:39)
- Quiz on Cells and Ranges
Available in
days
days
after you sign up
- Basics of Data Sorting (12:18)
- Data Sorting with Custom Lists (4:58)
- Filters in Excel 2016 (Basic & Advanced) (9:30)
- How to Filter Blank Cells in Excel (6:03)
- How to do Advanced Filter (10:58)
- How To Delete Duplicates (6:04)
- How to Extract Unique Values From A Column (2:30)
- [Excel Trick] Converting Text To Columns (7:59)
- [Excel Trick] Add Subtotals to Cells (5:22)
- [Excel Trick] Insert Blank Rows After Each Customer Automatically (4:08)
- How to Convert Text to Numbers (7:02)
- 3 Quick Tips to Save Time ( Filter | Find & Replace | Paste) (4:58)
- Quiz on Data Tools
Available in
days
days
after you sign up
Available in
days
days
after you sign up
Available in
days
days
after you sign up
Available in
days
days
after you sign up
Available in
days
days
after you sign up
- VLOOKUP with Exact Match (13:41)
- Vlookup with Approximate Match (4:52)
- VLOOKUP function Best Practices and Issues (11:51)
- HLOOKUP for Horizontal Lookup (3:14)
- LOOKUP Function (Backward Compatible function) (9:07)
- MATCH Function (8:27)
- Combining Vlookup And Match Functions (8:56)
- INDEX Function (7:56)
- Combining Index And Match Functions (10:35)
- INDIRECT Function (6:13)
- INDIRECT And VLOOKUP Functions (6:12)
- [Microsoft 365] Super Useful Xlookup Function (16:02)
- [Microsoft 365] New Xmatch Function (8:30)
Available in
days
days
after you sign up
Available in
days
days
after you sign up
Available in
days
days
after you sign up
Available in
days
days
after you sign up
- How to Restrict Data Entered with Data Validation Tool (12:22)
- 2 Create Drop Down List with Color (6:21)
- How To Set Up Custom Data Validation (14:06)
- Avoid Duplicate Entries using Data Validation (4:31)
- Create Dynamic List with Tables in Data Validation (9:57)
- [Advanced] Create Dependent Dropdown list (10:26)
- [Advanced] How to Circle Invalid Data (4:24)
- Quiz on Data Validation Tools
Available in
days
days
after you sign up
- Pivot Table Design Tricks (5:32)
- Basics of Pivot Tables (15:09)
- How to Group by Dates (for Reports) (6:59)
- How to Group by Numbers (for Reports) (5:45)
- Create a Calculated Field in Pivot Table (3:48)
- Auto-generate Report Filter Pages (7:07)
- [Tips] 9 Useful Excel Pivot Table Tips (15:18)
- [Advanced] Generate Smarter Serial Numbers (4:23)
- [Advanced] Slicers to Filter Tables Conveniently (13:04)
- [Advanced] PivotTable Timeline to Filter Dates (4:02)
- How to create Interactive Pivot Charts in Excel (9:33)
- Quiz on Pivot Tables
Available in
days
days
after you sign up
- Basics of Conditional Formatting (9:53)
- Conditional Formatting : With Formulas (8:20)
- [Advanced] How to Highlight Rows or Columns (6:59)
- Conditional Formatting : Data Bars (10:21)
- Conditional Formatting with Icon Sets (10:43)
- [Advanced] Create Interactive Highlight (7:13)
- How to Highlight Alternate Rows (6:13)
- Quiz on Conditional Formatting
Available in
days
days
after you sign up
- All About Excel Chart Basics (12:41)
- How to copy Chart Formatting in Excel (2:15)
- Working with Line Charts in Excel (10:25)
- Working with Column Charts (8:55)
- 7 Tips for Pie Charts (9:16)
- [Incell Charts] Create Sparklines (8:43)
- [InCell Charts] Bar Charts with Formula (4:44)
- [InCell Charts] Surplus Deficit Charts (2:56)
- Quiz on Charts
Available in
days
days
after you sign up
Available in
days
days
after you sign up
Available in
days
days
after you sign up
- Repeat Row Column Titles On Every Printed Page (4:24)
- How To Set Print Area In Excel Like A Pro (3:47)
- How To Print Gridlines In Excel (1:59)
- How To Insert Header And Footer In Excel (11:42)
- How To Center Print Area (5:57)
- How To Insert Page Breaks in Worksheet (5:43)
- How To Fit An Excel Sheet On One Page (7:29)
Available in
days
days
after you sign up