Formulas are the key to getting work done in Excel. In this accelerated video course, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn powerful skills to troubleshoot, trace errors, and fix problems. This is the formula training you should have had to begin with. End your frustration with Excel formulas today.
The short answer is that Excel remains a critical tool at the center of a huge number of business decisions. And, just like important decisions don't get made without a spreadsheet, spreadsheets don't do much without formulas. They are the truly the bread and butter of Excel.
And yet, a huge amount of time is wasted every day by intelligent people trying to solve typical business problems with Excel formulas. It's not their fault. Excel is complicated, and almost no one gets good training on formulas.
Core Formula is designed to give you the formula training you should have had to begin with.
Core Formula covers a lot of ground. Using bite-sized videos in razor-sharp HD format, Core Formula teaches you how to use formulas for text, dates and times, VLOOKUP, INDEX & MATCH, summing and counting, nested IFs, dynamic ranges, troubleshooting, and a wide variety of techniques for referencing cells.
Each video is short – typically 3 minutes or less – and all videos come with a practice worksheet that you can download directly below the video. The course is is self-paced, so can move through it as fast or slow as you like. You can get more info and a quick video walk-through of the course here. (This video also covers some good free resources we've created for learning Excel formulas and functions).
Yes. There are some small differences in the Mac and Win interface with respect to formulas, but in general this is one area in Excel where there is very good overlap between the Mac and Windows versions. The videos were recorded in Excel 2010 on Windows 7. All videos highlight shortcuts for both Windows and Mac.
Of course! If you aren't happy with the course, just let us know within 30 days and we'll give you a full refund. We're always interested in your feedback (so we can make the course better), but this unconditional guarantee. We want you to be completely happy.
When you purchase the course, an account will be created for you automatically on the Exceljet website. You'll receive an email immediately with a link to login, and when you do log in, you'll have full access to all videos and practice worksheets for the course(s) you purchased.
We think people learn quickly and effectively with a no-nonsense approach that is quick, clean, and to the point.
In other words: less is more. Excel brings plenty of complexity to the table already :)