Book Online Tickets for Workshop on Advanced Excel - Data Analys, Hyderabad. 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

Workshop on Advanced Excel - Data Analysis

 

  • Standard

    Sale Date Ended

    INR 499
    Sold Out

Invite friends

Contact Us

Page Views : 104

About The Event

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 

 

More Events From Same Organizer

Similar Category Events

    Venue Map