MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 12 lectures (1h 17m) | Size: 394.2 MB
Learn 25 Most Essential & Popular Excel Formulas And Functions – Sum, Sumif, Index, Match, Vlookup, Hlookup, Average Etc
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.
Excel 2007 or later
Passion to Learn Microsoft Excel Formulas & Functions.
Pen & Note to take notes.
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.
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:
Section 2 :
LOOKUP & REFERENCE Functions including:
Section 3 :
LOGICAL Functions including:
Section 4 :
TEXT Functions including:
Section 5 :
DATE & TIME Functions including:
Section 6 :
INFORMATION Functions including:
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.