• Post category:StudyBullet-2 ## excel,excel formulas,Excel Functions,Indexmatch,Vlookup,Hlookup,microsoft excel,basic excel,indexmatch,sumifs,and,

What you will learn

Learn 51 most powerful functions and formulas in Microsoft Excel from Six Categories

Learn Financial Functions – FV, PV, NPV, PMT, PPMT

Learn Lookup & Reference Functions – VLOOKUP, HLOOKUP, INDEX, MATCH, INDEXMATCH

Learn Logical Functions – IF, IFS, IFNA, IFERROR, AND, OR

Learn Mathematics functions – SUM, SUMIF, SUMIFS, AVERAGE, COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS, MAX, MIN, ROUND, ROUNDDOWN, ROUNDUP

Learn Text functions – CONCAT, UPPER, PROPER, LOWER, LEN, REPLACE, SUBSTITUTES, LEFT, RIGHT, MID, TRIM

Learn Date & Time Functions – NOW, TODAY, DAY, MONTH, YEAR, TIME, HOUR, MINUTE, SECOND

Description

FULL COURSE DESCRIPTION:

It’s time to show Excel who’s boss. Whether you’re starting from square one or aspiring to become an absolute Excel power user, you’ve come to the right place. This course will give you a deep understanding of the advanced Excel formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool.

If you’re ready to gain full control of Excel Formulas TODAY, take the “Microsoft Excel – Top 51 Formulas in 50 minutes ” course right now and master the following formulas:

· Financial Functions – PV, FV, NPV, PMT, PPMT

· Lookup & Reference Functions such as – VLOOKUP, HLOOKUP, INDEX, MATCH, INDEXMATCH

· Logical Functions – IF, IFS, IFNA, IFERROR, OR, AND

· Math & Trig Functions – SUM, SUMIF, SUMIFS, AVERAGE, COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS, MAX, MIN, ROUND, ROUNDDOWN, ROUNDUP

· Text Functions – CONCAT, UPPER, PROPER, LOWER, LEN, REPLACE, SUBSTITUTES, LEFT, RIGHT, MID, TRIM

· Date & Time Functions – NOW, TODAY, DAY, MONTH, YEAR, TIME, HOUR, MINUTE, SECOND

Learn By Doing.

You’ll follow along with me by downloading the Project File. I have provided under the “Resources” tab (in this tab see the “Resources” section). I am using the same file to teach you. You can practice 51 formulas together when you are watching lessons. By the end of the course, you’ll be writing robust, elegant formulas and functions from scratch

## English

Language

Content

Introduction

Introduction & Assignment

Subscribe to latest coupons on our Telegram channel.

Mathematics Function

Sum, Sumif, Sumifs, Average

Count Counta Countaif Countaifs Countablank

Max, Min, Round, Roundup, Rounddown

Logical Functions

IF Ifs

Ifna, Iferror, Or, And

TEXT Functions

Concat, Upper, Proper, Lower, Len

Repalce, Substitutes, Left, Right, Mid, Trim

Date & Time Functions

Now, Today, Day, Month, Year, Time, Hour, Minute, Second

Lookup & Reference Functions

Vlookup & Hlookup

Index, Match, Indexmatch

Financial Functions

Fv, Pv, Npv, Pmt, Ppmt

Thank you