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.
The course contains 5 x short videos. The course includes practice workbooks used in the training videos so that the viewer can follow along, step-by-step. In many videos, the viewer will find descriptive narration of the theory behind a function, classroom-style.
This course is part of a series of short courses that only address specific areas in learning Excel. Normally you have to sign up to lengthy courses that try to cover the entire spectrum of Excel, and have to pay a hefty price for it. But what if you only wish to learn specific areas, covering one base at a time. This way you won't be charged much, and moreover, after paying up only a meager price, depending on whether you like my style, you can always decide whether to sign up to another one of my courses or not.
After this tutorial, students will be able to use common mathematical functions like SUM, COUNT, MIN and MAX in excel 2013.
In this tutorial, students will learn the syntax and usage of AVERAGE, MODE, MEDIAN AND STDEV functions.
In this tutorial, students will learn the conditional mathematical functions; i.e., SUMIF, AVERAGEIF and COUNTIF.
In this tutorial, students will learn about all the other commonly used mathematical functions in Excel 2013.
In this tutorial, students will learn advanced functions like; 3D SUM, MOD and INT.
I am a telecoms engineer with major in Software and Office Automation. I have a knack of teaching difficult subjects in the most intuitive manner, or so I've been told. I have ventured into some online training courses that I have prepared on subjects of common interest between students and professionals.
I am a Microsoft Office aficionado. Word, Excel, Powerpoint, Visio etc. are my forte. I have designed many macros in VBA for automation too.
I am both a developer and designer. I have programming experience for desktop as well as the web. Vb.net, asp.net, jquery, css and html have all been my companions through out my development years. Lately, I have developed some websites in wordpress/php as well. As a designer; Photoshop, InDesign, Fireworks, Flash etc. have been my tools of the trade.
I have a firm grasp of the English language and am adept in both the spoken and written formats. I have used various software and computing tools to make my online courses graphically rich and intuitive. I hope you'll benefit from them.