This 30 Excel Functions lesson guide and workbook are based on the popular 30 Excel Functions in 30 Days challenge, from the Contextures Blog. The 30 functions are shown in the list at the right.
If you missed the challenge, or want all of the content in an easy-to-use single reference file, you can get this guide. Learn more about the 30 Excel functions in
These 30 Excel functions can be powerful on their own, and most work well with other functions, to perform amazing feats in your Excel workbooks. For example:
And many more Excel Function examples
With this 30 Excel Functions in 30 Days reference guide and workbook, you can:
You'll even discover which Excel functions you should avoid!
This lesson guide can help you make better use of familiar functions. Even the Excel functions that you use every day can have hidden talents, and pitfalls that you aren't aware of.
And there are so many Excel functions, that you probably only use a fraction of them. This lesson guide can show you new functions, that work better than some you're currently using. The lessons focus on 30 Excel functions in the following categories:
Each of the 30 lessons in the ebook (pdf format) explains how the Excel functions work, suggests possible uses for the function, and warns you of any traps to avoid.
There are multiple examples for most functions, showing practical applications that you can apply in your own workbooks. Experiment with the examples, as you follow along with the lesson plans.
You can follow the lesson guide, no matter how you like to learn. For each of the 30 Excel functions, there is:
The ebook is 150 pages, in a generous sized 13 pt font, so it's easy to read.
There are video tutorial links in the lesson guide, so you can see a demonstration of the examples. Click the video links to view the tutorials on the YouTube site.
The e-book is in Adobe PDF format, with bookmarks for easy navigation.
At the end of the e-book, there is an index to where each function is used in the examples. This is a great way to see how you can combine the different functions, for powerful and flexible results.
The Excel functions workbook contains over 100 examples -- all of the function samples from the lesson guide. The workbook is available in either 2007/2010 or 2003 format.
With this sample file, and all its examples, you will save time and effort, and not have to build each example from scratch, in your own workbooks.
There is a table of contents in the Excel file, so you can quickly navigate to the example you're looking for.
Or, work through the examples, as you follow the 30 lessons in the e-book.
A cheat sheet also links to the information sheet for each function, and summarizes the function's syntax and description.
Two versions of the 30 Excel Functions in 30 Days are available. Both versions have the same ebook, with the detailed instructions, and screet shots that show the worksheet in Excel 2010.
Excel 2007/2010 -- The Excel file is in Excel 2007/2010 format (xlsx), with no macros.
Excel 2003 -- The Excel file is in Excel 2003 format (xls), with no macros. A few formulas were changed, to replace formulas, such as IFERROR, that are not available in Excel 2003.
Contextures Inc. is pleased to offer these discounts when you purchase more than one copy of 30 Excel Functions in 30 Days. The same discounts apply if you buy multiple Contextures products, such as 1 copy of 30 Excel Functions in 30 Days, and 1 copy of Excel UserForms for Data Entry.
These percentage discounts are applied automatically to your order.
Click the Add to Cart button, to get the 30 Excel Functions in 30
Days eBook and Excel workbook.
Step by step purchase instructions are listed below.
You may use the downloaded material for personal or business use, but may not resell or repackage the contents.
After you purchase the 30 Excel Functions in 30 Days material, you may return it for any reason, within 30 days. Your purchase amount will be fully refunded.
Reference Guide (PDF format with Excel 2010 screen
& Excel file (2007/2010 or 2003)
30 Functions in 30 Days
Last updated: January 17, 2016 2:46 PM