Context Setting

Excel is intended for anyone who seeks to develop one of the most critical and fundamental digital skills today. Excel remains one of the most omnipresent pieces of software used in workplaces across the world.

 

Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio

Objective

This workshop explores ways to

• Performing daily use and complex function more efficiently which will save your 5 to 6 hours per week
• How to Prepare Interactive MIS and Dashboard with KPI's in Excel

Key Takeaways

Introduction to Excel - 

• Tips & Tricks that will help efficiency & accuracy
• Excel Option Settings for enhanced productivity and ease of operations

Using various types of Functions in Excel

• Numerical Functions (Int, Round, RoundUp, RoundDown)
• Text Functions (Left, Right, Mid, Concatenate, Trim, Upper, Lower, Proper)
• Date Functions (Today, Now, Month, Year, Dateif, Weeknum)
• Summarization using Group Functions (Sum, Count, Sumif, Sumifs, Countif, Countifs)

Using Lookup and Conditional Functions in Excel

• Conditional Functions (If, And, Or, Nested If)
• Lookup Functions (Vlookup, Hlookup, Xlookup)
• Combining Multiple functions for tackling complex conditions

Using Sort and Subtotals to summarizing data

Using Filters & Advanced Filters

Pivot Tables - Effective summarized representation of data using Pivot Tables

• Creating Table to add dynamism to your data (Auto update) 
• Creating Pivot Table
• Use of sections and Layout (Row, Column, Filter and Values)
• Insert Slicer
• Add design to make reports attractive
• Create Pivot charts to make summary visual base

MIS/Charts

• How to Prepare Interactive MIS and Dashboard with KPI's
• Visual representation of data using charts
• Insert Timeline in data
• Add design to make reports attractive

Participation Fees

Who Should Attend / Target Audience

Coordinator