Please ensure Javascript is enabled for purposes of website accessibility
Must-Know Formulas And Functions In Excel
5.0( 6 REVIEWS )
1h 54m

This course is designed for those interested to learn the basics of important Excel formulas and functions, together with linking sheets and workbooks and tracking formulas.

Read more.
Course Skill Level
Time Estimate
1h 54m



Tom Fragale is a computer professional w/over 30 years of experience. He is a Microsoft Certified Trainer. Available for webinars and 1-on-1 training.

Only want this course? Buy this course for $199 $29 and keep lifetime access. Click here

About This Course

Who this course is for:

  • Anyone who wants to become Excel proficient and improve productivity

What you’ll learn: 

  • Better ways to accomplish things in Excel
  • The most popular functions and formulas in Excel and how to use them very efficiently


  • No prior knowledge is required to take this course

More and more, your company is asking you to do some things with Excel spreadsheets that may leave you challenged or even overwhelmed. Maybe someone else worked on a spreadsheet, and then they moved on, and now you are in charge of that spreadsheet.

That is called inheriting a spreadsheet. That is what it is actually called. But inheriting a spreadsheet is not as fun as inheriting a million dollars. Maybe there are some formulas in the spreadsheet that you don’t understand. Or maybe your company is asking you to do certain tasks, and you know there must be a way to get those tasks done, but you don’t know how to actually do it.

Do you struggle with Excel formulas? Do calculations take a long time, and you know there must be a better way to accomplish things in Excel, but you don’t know where to turn? Then this course is for you. This course will show you the most popular functions and formulas in Excel and how to use them very efficiently. This course will make you more productive in Excel.

Our Promise to You

By the end of this course, you will have learned the important functions and formulas in Excel. 

10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

Get started today and learn more about functions and formulas.

Course Curriculum

Section 1 - Excel Formulas And Functions
Downloadable Materials 00:00:00
Building Basic Math Formulas 00:00:00
AutoSum And Relative References 00:00:00
Absolute References 00:00:00
Named Ranges 00:00:00
Linking Sheets And Workbooks 00:00:00
If, And, Or, And The Nested If functions 00:00:00
Countif, Sumif, AverageIf, SumIfs, And Countifs functions 00:00:00
Vlookup and Hlookup Functions 00:00:00
Match And Index Functions 00:00:00
Date And Time Formulas And Functions 00:00:00
Text Functions 00:00:00
Tracing Formulas 00:00:00

Course Review


6 Ratings
  1. Anonymous

    Layman's Terms


    Thomas explained everything in very simple terms. He walks you through each category with understanding and patience. I love that he takes out the scariness of learning excel and explains each subject step by step. Very good teacher.

  2. Easy to follow


    The teacher shared info in just the right delivery. It wasn’t so simple that it insulted my intelligence, but it also wasn’t too advanced. Baby bear, if you will.

  3. Anonymous

    Must Know Formulas & Functions in Excel


    Thomas explained things in a way that I can understand and always provided the spreadsheets to review and try them for myself. Excellent teacher!

  4. Anonymous

    Great course


    So helpful! I’ve used excel on a basic level for the past 15 years, but wanted to build my knowledge on formulas. This course was so helpful in the basic and useful formulas that are the most commonly used. I wish I had taken the class 10 years ago!

  5. Anonymous

    Must-Know Formulas And Functions In Excel


    This is a great course and I learned a lot and also enjoyed taking this class.