Introduction:
Organizations today have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. Data analysis & representation is indispensible to facilitate decision making and strategy development. It’s very challenging to turn a huge amount of data to useful information without the help of Excel.
The Advanced Excel Course is designed for executives who are already familiar with the basics of Microsoft Excel, and who would like to work with more advanced features of Microsoft Excel that help in improving their efficiency of working with worksheets, analyzing data, creating MIS reports, and automating various tasks. In this course, you will use Microsoft Office Excel to streamline and enhance your spreadsheets with templates, charts, graphics, data analysis and formulas.
Demonstration will be based on MS Office version.
Prerequisites:
Participant should familiar with basic excel that contain few functions like sum, max, min etc, formatting like borders, fonts, merge, etc, saving, printing techniques. This program is for anyone who is already familiar with the basics of Microsoft Excel, and who would like to work with more advanced features of Microsoft Excel that help in improving their efficiency of working with worksheets, analyzing data, creating MIS reports, and automating various tasks.
Program Objectives:
This Advanced Excel training program will empower the participants to be able to do the following:
- Performing complex calculations more efficiently, use various Excel functions.
- Organizing and analyzing large volumes of data.
- Creating MIS reports.
- Designing and using templates.
- Consolidating and managing data from multiple workbooks.
Course Contents:
- Functions
- Calculating Data with Advanced Formula
- Apply Cell and Range Names
- Calculate Data across Worksheets
- Use Specialized Functions
- Analyze Data with Logical and Lookup Functions
- Organizing Worksheet and Table Data
- Create and Modify Tables
- Format Tables
- Use Functions to Calculate Data
- Pivots
- Analyzing Data Using PivotTables
- Slicers
- Pivot Charts
- Create a PivotTable Report
- Filter Data Using Slicers
- Analyze Data Using Pivot Charts
- Update Workbook Properties
- Create a Macro
- Edit a Macro
- Writing simple VBA codes
- Interacting with other application
IITD Expert Faculty:
Masters in Computer Management & Masters in Personnel Management, Microsoft Certified Office Specialist Master.
She is an IT and Soft Skills Trainer with 12+years of experience in Corporate trainings. She has trained over 10000 students and has been associated with more than 300 corporate organisations.
She has got a lot of appreciation for her technical knowledge and excellent delivery by various clients such as Infosys, ICAI, Indian Railways Institute of Civil Engineering Pune, INS Hansa Naval Aviation Base Vasco Goa, Zensar, Cybage, Emerson Climate Technologies, Emphasis. etc.
Her area of expertise is Advance Excel, Excel VBA, Microsoft Project Management, DBMS, SQL, MS Access Advance Word, Advance Power point, Auditing via Excel, Tally ERP, MS Outlook.
Medium: English/ Hindi
Fees and Registration:
- 3,000 + GST 18% per person.
- 2,800* + GST 18% per person for a group of Three to Four participants.
- 2,600* + GST 18% per person for a group of Five or more participants.
* Early Bird Benefit
Early Bird Benefit is valid for bookings received up to 3 days prior to the program dates
Fees include participation, course material (Soft copies) and a Digital certificate.
Kindly provide below details for registration to Email: iitdpune@gmail.com; rajiv@iitdworld.com
- Name of the Program:
- Name of the participants with Email ID & Mo. Number:
- Company Name and address:
- GSTN Number:
- Pre-payment and pre-registration is required
- Participation fee is non-refundable/ non-adjustable against any other programme of IITD, but change in nomination(s) is accepted
The participation fee can be paid by way of NEFT/IMPS/Cheque drawn in favour of “Indian Institute of Training & Development” payable at Pune or through NEFT.
NEFT Details - Indian Institute of Training & Development
Bank Name - Bank of India
Current Account No: 052320110000336
ISFC Code - BKID0000523
Branch - Pune 411029.
GSTN Number: 27BDNPK3328J1Z9
Certification:
Digital Certificate of Participation will be provided to all the participants.
We look forward to your active participation and nominations in large numbers.
With warm regards,
Rajiv Kolhe
Director
Mob: 98220 89898, 8308459802
Tel 91 20 4120 3985
E-mail: rajiv@iitdworld.com; iitdpune@gmail.com
Website: www.iitdworld.com
Encl: Live Online Training Calendar JAN 2021
13
Industrial Safety
14
Achieving Zero Defects using Statistical Process Control #SPC
15
Advanced #Excel with Formulas, Charts, Pivots & Macros
16
#Communication Skills
18
Total Quality Management #TQM
19
Behavioural Interviewing Skills
20
Value Stream Mapping #VSM
21
Reduce Breakdown & Maintenance Cost by Effective Failure Analysis
22
Stores & Inventory Management
23
Quality Function Deployment #QFD
24
Goal Setting & Time Management
28
7 QC Tools
29
#Kaizen & 6 ‘S’ for Improving Profitability
IITD designs & customises corporate training programs as per your needs!
Over 2100 leading organizations including many ‘FORTUNE’ Companies and Multinationals, MSME’s have already benefited from our TRAINING PROGRAMMES, WORKSHOPS & CONSULTANCY