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.7 (13 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.
296 students enrolled
$20
Take This Course
  • Lectures 5
  • Contents Video: 31 mins
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 2/2015 English

Course 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.

What are the requirements?

  • Students need to have basic understanding of common mathematical and statistical concepts

What am I going to get from this course?

  • Learn common mathematical functions in Excel 2013
  • Learn conditional mathematical functions and their logic behind
  • Learn about less-known math functions in Excel

What is the target audience?

  • Students who wish to transform from a complete beginners to advanced users in using math functions

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Using Mathematical Functions
02:18

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

04:37

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

08:54

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

06:28

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

08:41

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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Adnan Ejaz, 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.

Ready to start learning?
Take This Course