About 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.
30 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 |
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!
Must-Know Formulas And Functions In Excel
This is a great course and I learned a lot and also enjoyed taking this class.
Great course
This course was clear and concise. The videos are short and easy to follow. It taught me a lot of functions I had no idea existed in excel. I look forward to applying my new knowledge. Thank you!