Advance Microsoft Excel 2013 Training

Advance Microsoft Excel 2013 Training

 

  • Regular Registration

    Regular Registration

    Sale Date Ended

    INR 4000
    Sold Out

Invite friends

Contact Us

Page Views : 2416

About The Event

Training Course Details for Advance Microsoft Excel 2013

 

1) Introduction

2) What's new in Microsoft Excel 2013

3) Let’s go Back Stage

4) Tables

5) Formulas

 

a. IF Condition

b. VLOOKUP

c. HLOOKUP

d. INDIRECT

e. MATCH

f. INDEX

g. OFFSET

 

6) Sorting

7) Filter and Advance Filters

8) Data Validations

9) What-If Analysis

 

a. Scenario Manager

b. Goal Seek

c. 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 2013 installed on your laptop before the session starts
    If you don’t have Microsoft Office 2013 on your laptop, please download the trail version from http://office.microsoft.com/en-in/try/[Download Professional Version]
  3. Online or Office 365 version will not work


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

  1. Fully hands-on practical training
  2. Examples used can put into practice immediately
  3. 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://www.chalktalk.co.in/