The Ultimate Guide to Learn Excel Basics

Excel is an important professional skill, especially in financial analysis and data analytics. This Excel basics guide teaches you how to get started in Excel for either Windows and Mac.

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

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.

1 Introduction to Excel

Introduction to Excel

Excel Shortcuts for Windows and Mac

2 Statistical Analysis in Excel

Statistical Analysis in Excel

3 Creating Graphs in Excel

Creating Graphs in Excel

4 Logical Functions in Excel

Logical Functions in Excel

5 Text Functions in Excel

Text Functions in Excel

6 Financial Functions in Excel

Financial Functions in Excel

Top 15 Financial Functions in Excel

7 Lookup Functions in Excel

Lookup Functions in Excel

8 Data Analysis in Excel

Data Analysis in Excel

9 What-If Analysis in Excel

What-If Analysis in Excel

Excel Resources

See 5 Best YouTube Channels To Learn Excel for Free

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.

---