Excel Formulas and Functions: Make Basic & Advanced Formulas (Udemy.com)

Learn MS Excel Formulas and Functions. Create Basic and Advanced Excel Formulas. Make an Excel Template Project.

( 186 Reviews )

Created by: Kawser Ahmed

Produced in 2016

What you will learn

Learn Excel Formulas and Functions from Zero.
Learn how to build a professional level Excel Template using Excel functions.

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 88 / 100

Course 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
Excel formulas and functions are the heart of Microsoft Excel spreadsheet. They are essential to manipulating data and obtaining useful information from your Excel workbooks.

Without Excel formulas and functions, Excel spreadsheet would simply be a fancy word-processing document. Welcome to my Excel Formulas and Functions course.

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

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 in very details.
How to use built-in Excel functions: Then you will learn how to use built-in excel functions into the Excel formulas using the Insert Function and Function Arguments dialog box.
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.
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.
Formulas with Tables: Understanding how formulas work with Excel tables is very important. I have used two lectures to cover Excel formulas with tables. In the second lecture, structured referencing with Excel tables has been discussed.
Then you will learn how to handle circular references with Excel formulas, how named cells and ranges work with Excel formulas, and so on.
Mathematical functions are very important in your daily work with finance or any kind of jobs. In this course, you will learn about SUM, AVERAGE, MAX, MIN, INT, MOD, ROUND, RAND, and RANDBETWEEN Excel functions. Counting related excel functions are also covered in this course.
Then you will work with 3-D Referencing with Excel Formulas.
In Advanced Excel formulas, you will learn: IF, IFERROR, DATE related functions, Text manipulating functions, and many more.
Manipulating Text using Excel Functions: There is a section where you will learn how to manipulate text using Excel formulas and functions.
Then you have worked with VLOOKUP, INDEX, and Array formulas.
And at the end of the course, you will build a professional Excel template where you will learn how to make complex Excel formulas using Excel functions.
Here is not the end of the course. Time to time, I shall add more lectures to the course that will teach you how to face real life problems using Excel formulas and functions.

So, if you are interested to learn advanced Excel formulas and functions with a real life project, then this course is for you. Thanks for reading. Enjoy the course!Who this course is for:

This course is meant for intermediate level Excel users who are familiar with the general concepts of Excel features.

Time: 5.5h

Instructor Details

Kawser Ahmed

4.4 Rating
186 Reviews

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 contact me.

Excel Basics (2017)

4.9 (15 Reviews)

Provider: YouTube
Time: 12h

Free

Microsoft Excel - Online Tutorial for Beginners (2010)

0.0 (0 Reviews)

Provider: Chandoo.org
Time: 1h 30m

Free

Excel Power Pivot and Power Query For Dummies

Excel Power Pivot and Power Query For Dummies (2016)

0.0 (0 Reviews)

Provider: Amazon

$14.53

More Courses

Reviews

4.4

186 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Sarah Surtees on 8/16/2020

It is so far very easy to follow and from looking through the content it is exactly what i was looking for :)

By Aryaman Gupta on 7/26/2020

it was an amazing course especially for beginners loved it!

By Ranjith kumar on 5/22/2020

Good useful course

By Sohail Risky on 4/24/2020

The instructor knows the subject very well.

By Saniya Shaukat on 4/10/2020

Like the fact that the instructor explains each concept in a moderate speed so that one can learn and follow the steps properly.

By Ahsun Haq Khan on 3/19/2020

Very good and informative

By Tammy Walker on 3/13/2020

Easy to understand and clear examples

By Rebika Boualem on 2/3/2020

c'est tres comprehensible merci

By Andr Grcio Santos on 1/22/2020

Good course to understand the use of multiple basic and advanced formulas.

By Ahmed Ali Mohamed Asran on 1/3/2020

Congratulations

By Jferraby on 8/19/2019

Instruction was simple, clear and concise. It left an impression of anticipating the next step, guiding student through it.

By Priyam Garg on 8/16/2019

I liked the course as it gave me good insights into the use of Excel. However, it is difficult to grasp at a go and the complex formulas should be eased out. No doubt I have learned a lot from this course but not 100%. I'll have to work a lot more to learn the software better.
Also, any of my questions asked during the lecture hasn't been answered.