Workshop on Advanced Excel - Data Analysis

Excel is an extremely popular domain. It is common for organizations to use Excel to store and analyze data. But did you know that you can even create Dashboards using Advanced Excel? Want to learn this amazing skill?? Register for the Advanced Excel Dashboarding Workshop organized by Digital Lync. Besides Dashboards, you will also learn core concepts of Advanced Excel.

Speaker: Himanshu Singh

Topics Covered:

• Look UpFunctions
• Pivot Tables
• Conditional Formatting
• Offset/Match/Index Functions
• Sensitivity analysis and Goal Seek
• How to make a Dashboard

Mini-Project: Job Search Portal

Session Plan:

• 10AM to 11AM --> Introduction to Dashboards
• 11AM to 12PM --> Logical and Lookup Functions
• 12PM to 1PM --> Pivot Tables and Charts
• 1PM to 2PM --> Break
• 2PM to 3PM --> Macros and Miscellaneous
• 3PM to 4PM --> Hands on Experience in making Job Dashboard

Venue:-  S.R. Nagar Branch, Digital Lync