Advance MS Excel (2007  2010) Masterclass

Advance MS Excel (2007 2010) Masterclass

 

  • Normal

    Sale Date Ended

    INR 5000
    Sold Out

Invite friends

Contact Us

Page Views : 181

About The Event

Introduction:

Microsoft Excel (2007 & 2010) can be used extensively for Data Analysis, MIS Reporting, Computer-aided Audit techniques (CAAT), Budgeting & Financial Planning. We might be using Excel daily or maybe casually, but we would have probably wished that you knew more about this dynamic program. In this workshop you'll learn ways to make our job easier and increase the sophistication of your data reporting and analysis.

Our each session will focuses on "save-time" techniques and exploring new advanced features. Along with this practical and usable training, We will also learn how to integrate our work within the Office for even greater results.

Agenda:

 

Session 1- LOOKUP Functions:

  • The VLOOKUP/HLOOKUP Functions

 

Session 2- Pivot Tables:

  • Adding new calculated Fields / Items
  • Consolidate Pivot table

 

Session 3: Logical Functions

  • IFs and Nested IF Functions
  • Using AND/OR/NOT Functions

 

Session 4: Validations and Advanced Sorting

  • Input Messages / Error Alerts/ Drop-Down Lists
  • Conditional Formatting
  • Sorting by Top to Bottom / Left to Right
  • Creating / Deleting Custom List
  • Sort by using Custom

 

Expert:

Kunal Obhrai, MS Excel Trainer (Six Sigma Green Belt Certified)

Kunal is a Commerce graduate and did his MBA from IMT Ghaziabad, with having more than 7 years of experience in Quality Assurance and Reporting, he has handled many projects and domain Trainings for Genpact. He is also a certified Six Sigma Green Belt & 3 Star Lean ACE certified for Implementing in process reporting.

Presntly he is in the quality assurance team of one of the Big4 audit firms where he provides business analytics support and also engage in building performance dashboard. He has also worked with the creative design team of the company for implementing a workflow management & reporting tool with the help of MS Excel.

 

For more details, please contact Biplab SenGupta on +91-8130826342 OR write at biplab@astrazure.com

 

Venue Map