Microsoft Excel

Exercises for practice

Microsoft Excel – Post Training Activity 1
Microsoft Excel – Post Training Activity 2
Microsoft Excel – Post Training Activity 3
Microsoft Excel – Post Training Activity 4
Microsoft Excel – Post Training Activity 5
Microsoft Excel – Post Training Activity 6
Microsoft Excel – Post Training Activity 7
Microsoft Excel – Post Training Activity 8
Microsoft Excel – Post Training Activity 9
Microsoft Excel – Post Training Activity 10

Topics for improving your Microsoft Excel skills

POWER OF COUNTIF FORMULA WITH WILDCARD CHARACTERS
FINDING TOP 3 CONTRIBUTORS IN YOUR DATA USING INDEX AND LARGE FORMULA
Calculating Net Present Value Using NPV Formula
Building Excel Custom Format Using Format Cells
Excel Formula for Dynamic Ranges with Offset and Match
Rounding Values Using 7 different Excel Formulas
Creative Stacked Bar Chart
Power Of Sumproduct Formula in Excel
MINA and MAXA formula
Creating Area Chart

Skill Test – Case Studies

Case study 1 – Multiple Sheet Extraction
Case study 2 – Multiple Sheet Consolidation
Case study 3 – Sumproduct Usage
Case study 4 – Match Usage
Case study 5 – Text Code Handling
Case study 6 – INDEX & MATCH CASE STUDY

Downloads