Learn Excel's common mathematical functions, conditionals and the logic behind for your basic and advanced needs.

Excel 2013: Common Math Functions in 30 mins, is a course designed to take you from basic to advanced understanding of all common mathematical functions in Microsoft Excel 2013, in just under 30 mins.

Learn how to prepare a basic gradebook using everyday mathematical functions, along with their conditionals. You'll also learn the logic behind all of these calculations so that you are no longer confused in differentiating between SUMIF or COUNTIF. You'll learn to calculate the great, yet little known, function of 3D SUM. Plus you'll go through all of the common functions along with a help file and practice workbooks to act as a reference for use in the future.

Students are usually not familiar with many of the built-in functions that Excel offers and end up complicating things for them in calculations. Knowledge about functions they do know, many a times, is insufficient and/or erroneous that messes up their calculations.

The concept behind this series is to take a complete noob, and make him/her understand not only the basics of calculations in Excel, but to ensure a thorough understanding of each function's advanced usage, as well.