Excel Beginners to Advanced.
What you'll learn
Introduction of MS Excel
Text Functions and Numerical functions
Formatting types in Excel
Inserting Images,Shapes, Charts and lot more things.
Sorting and filtering of data
IF Functions
Pivot Tables and Charts
Conditional and lookup functions
IF Function
IF Or Function Count if
VLOOKUP
HLOOKUP
INDEX FUNCTION
MATCH FUNCTION
Precedent and dependent
Watch Window
Pivot charts
Excel Power pivot
Key Performance Indicator (KPI)
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.