Excel Formulas and Functions with Excel Formulas Cheat Sheet
4.4 (466 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.
12,400 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Formulas and Functions with Excel Formulas Cheat Sheet to your Wishlist.

Add to Wishlist

Excel Formulas and Functions with Excel Formulas Cheat Sheet

Learn Excel formulas and functions from scratch. Download Excel formulas and functions cheat sheet for your daily use.
4.4 (466 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.
12,400 students enrolled
Created by Kawser Ahmed
Last updated 7/2016
English
Price: Free
Includes:
  • 3.5 hours on-demand video
  • 4 Articles
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Build the foundations of Excel Formulas and Functions from scratch
  • Use the Subtotal function effectively
  • Work with Relative, Absolute and Mixed cell references
  • Use formulas with Excel Tables
  • Handle Circular References with Excel
  • Use DATEDIF() and Date related Excel functions with ease
View Curriculum
Requirements
  • Microsoft Excel 2013 or Office 2013 installed in the computer
  • Students should have experience with Excel environment
Description

Teaching 11 Courses on Excel and Data Analysis!

OVER 25,000 visitors visit my blog ExcelDemy dot com every month!!

OVER 15,000 successful students have already taken my online courses since November, 2015 with 375 total Reviews!!!

Course Updated:  Nov 01. 2016

Formulas and worksheet functions are the heart of Microsoft Excel spreadsheet. They are essential to manipulating and obtaining useful information and insight from your data.

Without formulas and functions, Excel spreadsheet is simply a fancy word-processing document. Welcome to my Excel Formulas and Functions for Beginners course!

I designed this course for beginner level Excel users. But are you an intermediate level Excel user? Want to have a broader, deeper and in-depth knowledge in building Excel formulas and functions? This course is also for you!

I am Kawser Ahmed, your instructor with this course. I am a full time Excel, Excel VBA and Data Analytics blogger. And I am a corporate Excel trainer in my own country. Monthly more than 15,000 Excel users visit my Excel blog ExcelDemy and read my Excel and data related articles and tutorials.

Let’s discuss now what you will learn from this course.

  1. Operators and Precedence of Operators: I will start from zero and if you don’t know about the operators and precedence of operators that Excel uses in its formulas, then it will be tough for you to decode complex Excel formulas. So I have covered them very details.
  2. How to use built-in Excel functions: Then you will learn how to use built-in excel functions into the formulas using Insert Function and Function Arguments dialog box.
  3. Subtotal Function: You will find many uses of Subtotal function if you are using Excel with your Finance related jobs. So this function is covered in details at the start of the course.
  4. Relative, Absolute and Mixed Cell References: You will work with these three concepts time to time when you will build excel formulas. So, they have got a good time in the course.
  5. Formulas with Tables: Understanding how formulas work with Excel tables is very important. I have used two lectures to cover formulas with tables. In the second lecture, structured referencing with Excel tables has been discussed.  
  6. Circular Referencing: Then you will learn how to handle circular references with Excel formulas, how named cells and ranges work with formulas, and so on.
  7. DATEDIF() and Date related Excel Functions: And I will finish this course with DATEDIF () and other Date related Excel functions!

I am assuring you that what you will learn in this crash course is priceless. I designed this course keeping in mind, to give you a solid base in Excel formulas and function. Thanks for watching. Enjoy the course!

Who is the target audience?
  • Any person can take this course who use Excel
  • If you're beginner, you will find it very useful
  • If you're expert, you will see Excel Formulas in new ways
Students Who Viewed This Course Also Viewed
Curriculum For This Course
38 Lectures
03:38:58
+
Welcome to the Course!
4 Lectures 03:41

Hello! Welcome to the world of Excel formulas and functions!

0101 Welcome to the Course!
02:32

What you will get from this Excel lecture:

  1. This is the download section of the whole course. You will get all the working files, practice problems, Excel keyboard shortcuts PDF, and other Excel resources in one place.
Download Course Resources from Here
00:13

Download Excel Formulas Cheat Sheet from the resource section of this lecture.

Excel Formulas Cheat Sheet [Download]
00:22

You will get an idea how to instantly contact me when you face an Excel or Course related problem.

How to Get Support and Instantly Contact Me
00:33
+
Excel Formulas and Functions Basics
5 Lectures 42:19

In this video lecture,

  1. You will be introduced with the operators that are used by Excel.
  2. You will also learn how to use different operators in Excel.
0201 Operators Used in Formulas and How to Build Basic Formulas
10:28

Operator has working hierarchy. All the operators in a formula does not work at the same time.

In this lecture,

  • You have learned all about Excel operator precedence.
0202 Operator Precedence in Formulas
09:31

In this video lecture,

  • You will learn how to insert a built-in function into a formula.
0203 How Built in Excel Functions Make Your Job Easier
07:17

Excel is nothing but a word processor if you deduct Excel's capability to use functions. Functions are the hearts of Excel. In this video, you will learn how to insert Excel functions into a formula.

You will also learn how to use effectively Insert Function dialog box.

0204 Inserting Functions into Formulas Effectively
09:40

In this video lecture,

  1. You will learn with examples how relative referencing works in Excel formula.
0205 Relative Cell References - Using Relative Cell References to Copy Formulas
05:23
+
Formulas and Functions in Actions
9 Lectures 59:33

In this video lecture,

  • You will learn about SUBTOTAL function.
0301 Subtotal Function - Using Subtotal Function Effectively
06:56

In this video lecture,

  • You will learn all the ways to use structured references with Excel tables.
0302 Using Formulas in Tables - Summarizing and Referencing Data in a Table
12:44

In this video lecture,

  • You will learn how to use structured references in an Excel table.
0303 Using Structured References in Excel Tables
08:31

In this video lecture,

  • You will learn how to show the formulas in a worksheet.
0304 Displaying All the Formulas on a Worksheet
03:04

In this video lecture,

  • You will learn how to work with Circular Reference in Excel.
0305 Handling Circular References
03:23

In this video lecture,

  • You will learn how to give a name to a cell or a range.
0306 Using Named Cells and Ranges in the Formulas
07:48

In this video lecture,

  • You will learn how to give a name:
    • To a constant
    • And to a formula.
0307 Using Names for Constants & Formulas & Applying Names to Existing Reference
08:01

In this video lecture,

  • You will learn how to use Union (,) and Intersect ( ) operators in Excel.
0308 Union and Intersection of Ranges
05:28

In this video lecture,

  • You will learn 3 Excel formula related techniques. They are:
  1. How to use formula bar as a calculator in Excel
  2. How to make an exact copy of a formula
  3. And how to make formula cells into values cells.
0309 Some Tips on How to Work with Formulas
03:38
+
Manipulating Dates Using Excel Functions
3 Lectures 23:02

In this video lecture,

  1. You will learn how to work with DATEDIF(...) Function.
0401 DATEDIF(...) Function - A Useful Function
10:06

In this video lecture, you will learn several Excel functions related to Date & Time. They are:

  1. TODAY Function
  2. NOW Function
  3. DATE Function
  4. YEAR Function
  5. MONTH Function
  6. DAY and DAYS Functions
  7. And NETWORKDAYS Function.
0402 Date Manipulation Functions
09:18

0403 WEEKDAY(...) Function: Use of WEEKDAY(...) Function
03:38
+
Useful Mathematical Functions
5 Lectures 32:17
0501 SUM(...) Function - The Most Useful Function in Excel
07:51

0502 Mathematical Functions: Average(), Max() and Min()
06:54

0503 Mathematical Functions: INT(), MOD(), ROUND(), RAND(), and RANDBETWEEN()
07:09

0504 Count Functions in Excel
03:17

0505 Learn About 3-D Reference in Excel
07:06
+
Advanced Excel Formulas
11 Lectures 56:55
0601 Using the IF(...) Function
07:54

0602 Using IF(...) & IFERROR(...) function to Hide Excel Errors
06:05

0603 LEFT(...), RIGHT(...), MID(...), LEN(...) and FIND(...) Functions
06:59

0604 Concatenating Text Using CONCATENATE(...) Function and Ampersand Operator
04:14

0605 Using TEXT(...) Function to Manipulate Numbers
04:55

0606 REPT(...) Function - Using REPT(...) Function to Make a Histogram
06:44

0607 Use of Rank Functions to Calculate Placings
07:44

0608 OR(...) Function: Using OR(...) Function
03:06

0609 ISTEXT(...) Function: Using ISTEXT(...) Function
02:48

0610 ROW(...) and COLUMN(...) Functions
01:52

0611 INDIRECT(...) - Creating a Dependent Drop Down List in Excel
04:34
+
Learn More: A Special Offer!
1 Lecture 01:18
Bonus Lecture: A Special Offer for You!
01:18
About the Instructor
Kawser Ahmed
4.4 Average rating
1,393 Reviews
38,098 Students
11 Courses
Founder ExcelDemy.com | Data Analyst

Love to see you here!

I am Kawser Ahmed, father of two beautiful angels (Marissa and Arissa), a full-time data analysis blogger (using Excel & other tools), corporate Excel trainer, & entrepreneur.

I love to make courses in the combination of both theory and practice.

Monthly 30,000 Excel users visit my Excel blog ExcelDemy (follow the website link in the profile).

I love to learn and teach (teaching from my eighteen)!

Visit my blog!

You will find plenty of useful posts, articles, video tutorials, and important Excel resources.

What I love most is: add some value to people around me, believe me!

Here are some of my working areas:

  • 1. Corporate Budgeting, Planning & Forecasting
  • 2. Mission-critical financial processes
  • 3. Month-end close processes
  • 4. Big Data Analysis using Excel
  • 5. Company Reports (Sales, Marketing, Administrative)
  • 6. Large Projects using Excel VBA
  • 7. Dashboard Design using Excel
  • 8. And Basic Accounting


I am always around you to help and support! 

Just knock me!