Microsoft Excel – Discover 25 Top Excel Formulas & Functions

Learn 25 Most Essential & popular Excel Formulas and Functions – SUM, SUMIF, INDEX, MATCH, VLOOKUP, HLOOKUP, AVERAGE etc

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.

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

Course Content

  • Introduction –> 1 lecture • 3min.
  • AutoSum & Math Functions –> 3 lectures • 28min.
  • Lookup & Reference Functions –> 4 lectures • 26min.
  • Logical Functions –> 1 lecture • 9min.
  • Text Functions –> 1 lecture • 6min.
  • Date & Time Functions –> 1 lecture • 2min.
  • Information Functions –> 1 lecture • 3min.

Microsoft Excel - Discover 25 Top Excel Formulas & Functions

Requirements

  • 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

  1. The course cover 25 powerful Functions in Microsoft Excel.
  2. Designed with perfect care by a professional in Microsoft Excel with more than 11 years of experience.
  3. The course is not long, so you can complete it in a short time, and then enjoy your new experiences.
  4. Your inquiries will be answered in a short time with a full explanation of any question.
  5. Constant updates.
  6. One-On-One Support.
  7. Simple and easy-to-understand explanation with examples.
  8. 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.