Microsoft Excel: Learn 25 Top Excel Formulas and Functions
25 Most Essential Excel Formulas & Function - VLOOKUP Excel, Concatenate & SUMIF Excel, IF, COUNT, SUM and Excel COUNTIF
Ratings 3.60 / 5.00
What You Will Learn!
- Master working with Formulas & Functions, VLOOKUP, HLOOKUP, MATCH Function, INDEX, AVERAGE, SUM, SUMIF etc...
- Learn 25 most powerful functions and formulas in Microsoft Excel
- Building a solid understanding on the Basics & Advanced features of Excel formulas
- create Excel formulas and functions easily
- How to correct the errors that pop up when creating formulas.
- Understand Exact and Approximate Match argument.
Description
This is a very very special Course that will let you impress your colleagues and surprise your Bosses, By mastering the most powerful functions in Excel.
The version of MS Excel I'm using in the course is Microsoft Excel 2016 which is similar to Microsoft Excel 2019 & Office 365 Excel.
I note that the course is compatible at 95% with Microsoft Excel 2007, 2010, and 2013 versions.
10 Reasons why you should choose this Title
The course covers 25 powerful Functions in Microsoft Excel.
Designed with perfect care by a professional in Microsoft Excel with more than 11 years of experience.
The course is not long, so you can complete it in a short time, and then enjoy your new experiences.
Your inquiries will be answered in a short time with a full explanation of any question.
Constant updates.
One-On-One Support.
Simple and easy-to-understand explanation with examples.
A certificate will be provided upon completion of the course.
This is what we will cover in this course :
Section 1 :
AUTOSUM & MATH Functions including:
ADD Function;
SUBTRACT Function;
MULTIPLY Function;
DIVIDE Function;
SUM Function;
SUMIF Function;
MIN Function;
MAX Function;
COUNT Function;
COUNTA Function;
AVERAGE Function;
MEDIAN Function.
Section 2 :
LOOKUP & REFERENCE Functions including:
VLOOKUP Function;
HLOOKUP Function;
INDEX Function;
MATCH Function
Section 3 :
LOGICAL Functions including:
IF Function;
COUNTIF Function;
IFERROR Function.
Section 4 :
TEXT Functions including:
CONCATENATE Function;
EXACT Function.
Section 5 :
DATE & TIME Functions including:
TODAY Function;
NOW Function.
Section 6 :
INFORMATION Functions including:
ISNUMBER Function;
ISTEXT Function.
Upon completion of this course, you will be able to master the 25 Most Essential & popular Excel Formulas and Functions, besides Data Validation.
What are you waiting for?
Go ahead and join us.
I'll love to see you in the class.
Who Should Attend!
- Anyone who want to master & understand Microsoft Excel Functions.
- Students and Professionals who want to go deeper in Microsoft Excel.
- Experts & Professionals who want to freshen up their skills.
