Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Excel 2013: Common Math Functions in 30 mins to your Wishlist.

Add to Wishlist

Excel 2013: Common Math Functions in 30 mins

Learn Excel's common mathematical functions, conditionals and the logic behind for your basic and advanced needs.
4.5 (9 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
297 students enrolled
Created by Adnan Ejaz
Published 2/2015
English
$20
30-Day Money-Back Guarantee
Includes:
  • 31 mins on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
Description

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.

Who is the target audience?
  • Students who wish to transform from a complete beginners to advanced users in using math functions
Students Who Viewed This Course Also Viewed
What Will I Learn?
Learn common mathematical functions in Excel 2013
Learn conditional mathematical functions and their logic behind
Learn about less-known math functions in Excel
View Curriculum
Requirements
  • Students need to have basic understanding of common mathematical and statistical concepts
Curriculum For This Course
Expand All 5 Lectures Collapse All 5 Lectures 30:58
+
Using Mathematical Functions
5 Lectures 30:58

After this tutorial, students will be able to use common mathematical functions like SUM, COUNT, MIN and MAX in excel 2013.

Preview 02:18

In this tutorial, students will learn the syntax and usage of AVERAGE, MODE, MEDIAN AND STDEV functions.

Preview 04:37

In this tutorial, students will learn the conditional mathematical functions; i.e., SUMIF, AVERAGEIF and COUNTIF.

Preview 08:54

In this tutorial, students will learn about all the other commonly used mathematical functions in Excel 2013.

Common Math Functions
06:28

In this tutorial, students will learn advanced functions like; 3D SUM, MOD and INT.

Advanced Functions: 3D Sum, Mod and Int
08:41
About the Instructor
4.5 Average rating
12 Reviews
317 Students
4 Courses
Telecommunications Engineer

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.

Report Abuse