Learn how to use Microsoft Excel Formulas and Macros (VBA). I have 10+ years of experience in Data Science and Excel VBA and taught this subject in many schools and colleges. I work as a program manag

Details

These are the concepts I'll cover during classes:

SUM SUMIF SUMIFS
AVERAGE AVERAGEIF AVERAGEIFS
COUNT COUNTIF COUNTIFS
COUNTA
IF Nested IF Conditional IF
IFERROR error Handling
CLEAN TRIM
LENGTH
LEFT RIGHT
MID and Text to Columns
LOWER and UPPER CASE
PROPER CASE
TEXT
ROUND
ROUNDUP
ROUNDDOWN
ABS Absolute
POWER
SQRT Square Root
RAND
RANDBETWEEN
CEILING and FLOOR
MOD
SUBSTITUTE
REPT
SEARCH and FIND
CHOOSE
AND Operator
OR Operator
NOT Operator
XOR Operator
IFNA
IFS
VLOOKUP
HLOOKUP
XLOOKUP
MATCH
INDEX with MATCH
OFFSET
INDIRECT
ROW and COLUMN
ADDRESS
ROWS and COLUMNS
DATE TODAY
DATETIME NOW
DATEDIF
EDATE
EOMONTH
WORKDAY
NETWORKDAYS
EXTRACT DAY MONTH YEAR
EXTRACT HOUR MINUTES SECONDS
EXTRACT WEEKDAY WEEKNUM
CONCAT
TEXTJOIN
CHAR
CODE
VALUE
T
Normal Filter and FILTER Formula
SORT formula vs Manual sort
UNIQUE Formula vs Remove Duplicates Vs Highlight Duplicates
Multiple Sorts vs SORTBY
SEQUENCE
ARRAYFORMULA in Google Sheets
TRANSPOSE
MMULT
ISFORMULA
ISERROR
ISNA
ISBLANK
ISNUMBER
ISTEXT
ISLOGICAL
TYPE
SHEET vs SHEETS
SPARKLINE
HYPERLINK
Convert Data into Table Format
Table Slicers
PIVOT Table
Sort data, highlight duplicates and text to columns
Insert Blank Rows by GROUPING