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.Instructor
Thomas
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
Requirements:Â
- 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
5.0
6 RatingsRelated Courses
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.
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.
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!
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.