Know Your Functions with MS Excel
4.8 (4 ratings)
82 students enrolled
Wishlisted Wishlist

# Know Your Functions with MS Excel

The 2 hour comprehensive Advanced Excel course focusing on Functions
4.8 (4 ratings)
82 students enrolled
Created by MKCL India
Last updated 3/2017
English
Current price: \$10 Original price: \$20 Discount: 50% off
30-Day Money-Back Guarantee
Includes:
• 2 hours on-demand video
• 22 Supplemental Resources
• Access on mobile and TV
• Certificate of Completion
What Will I Learn?
• Master over 70+ different types of functions to effectively work upon MS Excel projects and increase productivity. The skills will enable learners to perform number processing, use formulae, use complex functions to simplify the problem at hand and achieve accurate solutions in no time!. The skills learnt in this course can be effectively applied by the students in their own Excel projects and work.
View Curriculum
Requirements
• Students need to know to operate a computer, have very basic know how of MS Excel, and log onto Udemy and learn the course. This course is designed to be just over a couple of hours and teache a a huge list of skills consisting complex functions and formulas, so the students must completely concentrate while learning. While doing the course, it is advisable to practise the project activities for better learning outcome.
Description

Mastering MS Excel is rarely this easy and fast. We have come up with this course which will help you learn the more advanced functions and complex formulas used MS Excel skills by investing just over a couple of hours

Build a strong foundation in Excel and spreadsheet processing using complex functions and formulas and perform the most complex calculations, quickly and effortlessly!

What will be covered in the course?

Functions is what makes Excel smart. In this course you will learn all about using functions. For those of you who haven’t used functions before, you will learn the basic fundamentals about them as well.

At the end of this course you would have learnt about:

1. Basic Functions
2. Nested Functions
3. Displaying and Analysing Functions
4. Logical Functions
5. Mathematical Functions
6. Financial Functions
7. Lookup and Reference Functions,
8. Arrays, and
9. Dynamic Formulas

Content and Overview (Now this is the important part)

Based on our vast training experience and a lot of research on MS Excel usage trends across industries, we have identified Excel functions that provide maximum utility with the least effort. We have focused on key functions from each category. Familiarity with these gets you set for effortless use of other similar ones.

The simple training style will enable you to master seemingly hard-to-grasp concepts in a very short while. This course will cover functions under broad categories.

You must have often spent hours trying to identify missing data fields or non-standard data. A special section has been devoted to “Information Finding Functions”. So you will learn to do previously cumbersome tasks in just a few seconds!

Another problem area is the annoying errors that pop up in spreadsheets. If a single cell involved in a calculation has an error, the dependent formula goes completely topsy-turvy. Not anymore! With knowledge of error checking functions, you can ensure that errors are nipped in the bud and all calculations go through smoothly.

So this course is also going to help you resolve problems in a jiffy! In most cases, since the root cause of the errors is eliminated, the problems won’t occur at all.

What are the requirements?

No specific eligibility requirements. This course is for anyone and everyone who is looking to learn the more advanced formulas and functions in Excel to increase their productivity. Very basic knowledge of Excel is required to enroll for this course.

When you learn this course, we strongly recommend that you create those projects simultaneously for an effective learning experience.

Who will benefit the most from this course?

The ideal student for this course is anyone and everyone who wants to learn the advanced functions and formulas in Excel to increase their productivity.

This course will be particularly helpful for

1. Individuals in supervisory roles,
2. Sales and Marketing professionals,
3. Human Resources and Payroll Professionals,
4. Supply Chain Management analysts,
5. Financial Analysts,
6. Bankers,
7. Students looking for a career in the fields of Data Analysis and Processing, and
8. Data Analysts
9. Students learning Excel,
10. High School and College students,
Who is the target audience?
• The target student for this course is anyone and everyone who wants to learn more advanced functions and formulas in MS Excel. This course will be particularly helpful for individuals in supervisory roles, Sales and Marketing professionals, Human Resources and Payroll Professionals, Supply Chain Management analysts, Bankers, Financial Analysts, students looking for a career in the fields of Data Analysis and Processing, Data Analysts, students learning Excel for the first time, and High School and College students
Students Who Viewed This Course Also Viewed
Curriculum For This Course
11 Lectures
02:06:28
+
Course Introduction: Know Your Functions with MS Excel
1 Lecture 06:34

This is the Course Introduction lecture. In this lecture you will to know the curriculum that we will be covering.

At the end of this lecture, you should be able to:

1. Get an idea about what the course is going to cover
2. Know the types of functions
3. Know why and how the functions are used and their basic applications
Preview 06:34
+
10 Lectures 01:59:54

By the end of this lecture, you should be able to:

1. Define Function
2. State the parts of a function
3. Explain how to insert functions
4. List the categories of functions
5. Describe how to search for a specific function
Preview 05:12

By the end of this lecture, you should be able to:

1. Use Logical functions AND, IF, NOT and OR
2. Use a combination of functions
3. Use Nested IF functions
4. Use the SUM and AVERAGE functions
5. Use the AutoSum function
6. Use the FORMULATEXT function
7. Use the SUMIF and SUMIFS functions
8. Analyse functions using the Function Arguments window
Logical Functions
18:31

By the end of this lecture, you should be able to:

1. Use the AVERAGE, MODE and MEDIAN functions
2. Use Excel for Area and Volume calculations
3. Use the ROUNDDOWN, ROUNDUP, and ROUND functions
4. Use the MOD and INT functions
5. Use the RAND and RANDBETWEEN functions
Mathematical Functions
12:20

By the end of this lecture, you should be able to:

1. Use Excel for loan related calculations
2. Use the PMT function for EMI calculations
3. Use the PV and FV functions to calculate present and future value of investments
Financial Functions
08:03

By the end of this lecture, you should be able to:

1. Use the Lookup and Reference functions of CHOOSE, MATCH, and INDEX
2. Combine the MATCH and INDEX function for flexible output
Lookup and Reference Functions
09:34

By the end of this lecture, you should be able to:

1. Use the LOOKUP Function
2. Use the VLOOKUP Function
3. Use the HLLOKUP Function
4. Use VLOOKUP in Live Action
5. Create Lookups nested within Lookups
LOOKUP, VLOOKUP, and HLOOKUP Functions
12:42

By the end of this lecture, you should be able to:

1. Use IF ARRAY Formulas
2. Use Transpose-Shift
Arrays
06:49

By the end of this lecture, you should be able to:

1. Describe how Excel stores Date and Time values
2. Explain the concept of Volatile Functions
3. Use the Date and Time functions TODAY and NOW
4. Use the YEAR, MONTH, DAY, HOUR, MINUTE, and SECOND functions
5. Outline the process of calculating difference between two dates
6. Use the DATEIF function to calculate age in years, months, and days
7. Describe the process of Concatenating functions
8. use the DATEVALUE and TIMEVALUE functions to serialize dates and time stored in text format
Preview 11:41

By the end of this lecture, you should be able to:

1. Use the LEFT and RIGHT functions
2. Use the LEN and TRIM functions
3. Use case changing functions PROPER, LOWER, and UPPER
4. use the CONCATENATE function
5. Use the REPLACE and SUBSTITUTE functions
6. Use the MID and FIND functions
7. Use the TEXT function
Miscellaneous Functions - Part 2
15:59

By the end of this lecture, you should be able to:

1. Use the CELL function to get information about a cell
2. Use other information functions like ISBLANK, ISFORMULA, and ISNUMMBER
3. Use error-finding functions ISERROR, ISERR and IFERROR
4. Use the OFFSER function
5. Use the COUNTA function
6. Use the INDIRECT function
7. Construct Dynamic Name ranges
8. Construct Dynamic Formulas
Error Finding Functions
19:03