Excel Formulas & Advanced Techniques

1. SELECTED TOPICS FROM FUNDAMENTALS

2. LOGICAL FUNCTIONS

i). Basic IF function
ii). IF, AND, OR
iii).Nested IFs
iv). Validation of Excel inputs
v). Intoduction to model dynamism

3. LOOKUP FUNCTIONS

i). Vlookup, Hlookup,
ii). Match, Index
iii). Dynamic Vlookup
iv). Offset
v). GetPivotData

4. MATH & STATISTICAL FUNCTIONS

i). Sum & Average
ii). Min & Max
iii). Count Vs Conta
iv). Small & Large
v). Countif(s)
vi). Sumif(s)
vii). Averageif(s)

5. ERROR HANDLING

i). Types of Errors
ii). Handling Errors
iii). Iferror Function
iv). Iserror, Istext

6. EXCEL CHARTING

i). Creating Charts
ii). Types of Charts
iii). Gauge Chart
iv). Animation
v). Trendlines
vi). Dynamic Charts
vii). Waterfall charts

7. CONDITIONAL FORMATTING

i). Basic formatting
ii). Formatting with formulars
iii). Sparklines
iv). Dynamic textbox
v).Screen clipping
vi). Camera tool

8.BIG DATA & WORK REVIEW

i). Consolidating workbooks
ii). Linking MS suite for auto updates
iii). Getting external data into excel
iv). Work Protection & Hiding formulas
v). Formula debugging

8. BIG DATA TECHNIQUES

i). Summing through sheets
ii). Consolidating workbooks
iii). Linking MS suite for auto updates
iv). Sub-Total feature
v). Grouping & Ungrouping

9. FORMATTING & STYLES

i). Cell Styles & Themes
ii). Wrap Text
iii). Cells merging
iv). Sparklines

10. INTRODUCING VBA

i). Why automate tasks
ii). Recording a macro
iv). Hiding & unhiding sheets
v). Attaching a macro to a button
vi). Saving macro enabled workbook

11.EXCEL TABLES

i). Table Vs Range
ii). Data table
iii). Introducing Pivot Tables
iv). Slicer & Timeline
v). Pivot charts
vi). Pivot table dashboard techniques
vii). Pivot table dynamic mini dashboard
viii).Calculated Fields, Calculated Items

Proggramming Courses