Ultimate Guide to Learn Excel Basics

Excel is the most important computer app in business. It is used in every industry and by many professionals. Many jobs require prospective candidates to have advanced Excel skills.

Microsoft Excel is the leading digital spreadsheet that manages, calculates, and presents data. It is one of the most fundamental tools for data analysis. 

This guide will show the basics for getting started with Excel for both Windows and Mac. Knowing Excel is an important life skill!


Lesson 1

Introduction to Excel

Introduction to Excel


Lesson 2

Statistical Analysis in Excel

Statistical Analysis in Excel


Lesson 3

Creating Graphs in Excel

Creating Graphs in Excel


Lesson 4

Logical Functions in Excel

Logical Functions in Excel


Lesson 5

Text Functions in Excel

Text Functions in Excel


Lesson 6

Financial Functions in Excel

Financial Functions in Excel


Lesson 7

Lookup Functions in Excel

Lookup Functions in Excel


Lesson 8

Data Analysis in Excel

Data Analysis in Excel


Lesson 9

What-If Analysis in Excel

What-If Analysis in Excel


Excel Resources


Mr. Excel

Bill Jelen runs the Mr. Excel YouTube channel. Mr. Excel has been on Youtube for over 10 years and has thousands of great videos. This is a great resource with so many good teaching videos. 


Excel is Fun

Mike Girvin of Excel is Fun has over 3,000 videos on Youtube. He has over 86 million views. Wow! It is a great resource for financial and statistical help. I have learned so many things from this channel. 


Leila Gharani

Leila Gharani is one of the best Excel channels. Her videos are great, especially for finance and data visualization. She is very helpful in creating amazing charts and her videos are high quality.


Excel Campus

Excel Campus is from Jon Acampora. He has a great video series on creating Excel dashboards with pivot tables, pivot charts, and slicers. He also has lots of information about VBA and macros in Excel.


Finally Learn

Finally Learn is our video channel. We have videos on accounting, finance, and Excel.


Jeff Mankin

Jeff Mankin teaches financial literacy. His website is FinallyLearn.com.

Recent Posts