MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 487 MB | Duration: 1h 17m
25 Most Essential Excel Formulas & Function - VLOOKUP Excel, Concatenate & SUMIF Excel, IF, COUNT, SUM and Excel COUNTIF
What you'll 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.
Requirements
Excel 2007 or later
Passion to Learn Microsoft Excel Formulas & Functions.
Pen & Note to take notes.
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 cover 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 the Data Validation.
What are you waiting for?
Go ahead and join us.
I'll love to see you in the class.
Who this course is for:
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.
Recommend Download Link Hight Speed | Please Say Thanks Keep Topic Live
Links are Interchangeable - No Password - Single Extraction
