Mathematical, Logical and Text Operators (Check Download Files)
|
Writing basic formula and understanding precedence (Check Download Files)
|
Understanding basic logical formulas
|
Sum,Average,Max and Min Functions
|
Count and Rounding Functions
|
Countif,AND,OR Logical functions
|
|
|
|
|
|
Relative and Absolute referencing Part I
|
Relative and Absolute referencing Part II
|
|
Data selection,creating Pie chart and Bar Chart
|
Creating Column Chart and Line Chart
|
|
|
|
IFError and IFS used together
|
|
|
|
|
|
|
|
|
Indirect,VLook Up and Match
|
|
|
Protecting Data and allow editing ranges
|
Protecting workbook structure and encrypting with password
|
|
|
Simple filters and Advanced filters
|
Using Advanced filters to copy data
|
|
Types of Data Validations
|
|
|
Understanding and Creating Pivot Table
|
More Pivot Tables and Value Field Settings
|
Pivot Tables with Different Fields
|
|
|
|
|
|
Basic Preparation before recording macro
|
Recording macro to add formatting
|
Recording macro to apply formulas
|
|
Visual Basic Editor,Understanding VBA code of formatting
|
VBA code for calculate macro
|
|
|