Learn 40 Microsoft Excel Functions Step by Step
What you will learn
Excel Functions Seeking
Excel Automating Formulas
Excel tips
Description
This course is all about excel functions, if you are looking for automating your job and make it easier this is the right course for you, so excel functions are so important for 2 main reasons, the first one is time saving and the second one is eliminating human errors.
In this course you will learn over 40 most important excel functions, for each function i will explain it in details and show you its syntax then will show you how to do it in excel sheets step by step.
English
language
Content
Microsoft Excel 40 Functions Course
Introduction
SUM & AVERAGE
SUMIF & SUMIFS
COUNT & COUNTIF & COUNTIFS
COUNTIF APPLICATION
VLOOKUP & IFERROR
COLUMN & ROW & INT
IF
INDEX
MIN & MAX & SMALL & LARGE
MATCH
OFFSET
SUBTOTAL
TRANSPOSE
CONVERT
CEILING & FLOOR
CELL
FIND & SEARCH & LEN
LEFT & RIGHT & MID
SUBSTITUTE
TRIM & LOWER & UPPER
TEXT
DATE & TIME FUNCTIONS