Advance Microsoft Excel 2010 Training

Advance Microsoft Excel 2010 Training

 

  • Early Bird Registration

    Sale Date Ended

    INR 3500
    Sold Out
  • Regular Registration

    Sale Date Ended

    INR 4000
    Sold Out

Invite friends

Contact Us

Page Views : 2308

About The Event


Training Course Details for Advance Microsoft Excel 2010

  1. Introduction

  2. Lets go Back Stage

  3. Tables

  4. Formulas

    1. IF Condition

    2. VLOOKUP

    3. HLOOKUP

    4. INDIRECT

    5. MATCH

    6. INDEX

    7. OFFSET

  5. Sorting

  6. Filter and Advance Filters

  7. Data Validations

  8. What-If Analysis

    1. Scenario Manager

    2. Goal Seek

    3. Data Tables

  9. SubTotal

  10. Pivot Tables

  11. Slicer(s)

  12. Charts

  13. BONUS - 5 Amazing Tricks


About Microsoft Excel
Microsoft Excel allows you to manipulate, manage and analyze data helping assist in decision making and creating efficiencies that will directly affect your bottom line. Whether you’re using it for business or to help manage personal database and expenses Microsoft Excel gives you the right tools to enable you to accomplish all your needs.

 

What can Microsoft Excel be used for?
Microsoft Excel is a very versatile tool and can be used for almost anything that you can imagine:
Agendas, Budgets, Calendars, Charts and Diagrams, Financial Tools (Loan calculators etc.), Forms, Inventories, Invoices, Lists and to-do checklists, Planners, Plans and proposals, Reports, Schedules, Time sheets. This is a small selection of what can be achieved on Microsoft Excel.
 

Requirement

  1. Basic/Intermediate knowledge of Microsoft Excel
  2. Please have Microsoft Excel 2010 installed on your laptop before the session starts
    If you don’t have Microsoft Office 2010 on your laptop, please download the trail version from http://office.microsoft.com/en-in/try/ [Download Professional Version]


Facilitators Profile
Mr.Archie Makhija is Founder of ChalkTalk (Training Solutions Provider). He has more than a decade’s experience. He is well known for his trainings, especially Microsoft Excel. He has trained in/employees of companies viz., ADP, Computer Associates (CA), Deloitte, Google, Tata Teleservices, GECIS / GENPACT, Directorate of Income Tax - Hyderabad, SKS Microfinance, MedVarsity (Apollo Hospital initiative), Engineering Staff College of India (ESCI), Research Center Imarat(RCI), DRDO, DRDL, NTPC and many more
 

Methodology
Fully hands-on practical training
Training style is practical. Examples used can put into practice immediately. Training sessions concentrate on helping you to improve your effectiveness and productivity at work and at home.


Practice files

Each participant receives a set of practice files for “hands-on” use during and after the training session. 


Award
Certificate will be given to all the participants.
 

Website
http://chalktalk.co.in/ 

Venue Map