Indian Institute of Training and Development (IITD)
Presents One Full Day Interactive Classroom program on
Advanced Excel
24th Aug 2023; 09:00 am to 05:30 pm at a Hotel, Pune
Certificates will be issued to the participants!
Course Description:
You have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. 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.
Participants need to bring their own laptop with MS Office installed!
Delivery Method:
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
The participants are requested to bring their own laptop for better understanding and practical experience. The participants may also bring with them live data pertaining to their organisation, so that these can be studied during the workshop, as to how it can be worked out with better solutions.
Course Contents:
Chapter 1: OVERVIEW OF THE BASICS
- Arithmetic Operators
- Logical Operators
- Text Operators
- Range Operators
- Absolute and relative reference
Chapter 2: PRESENTING DATA USING CHARTS
- Creating a chart
- Modifying the axes
- Adding secondary axis
- Multiple location charting
Chapter 3: CONDITIONAL FORMATTING
- Conditional formatting with multiple conditions
- Using formulas in conditional
- Formatting
Chapter 4: DATA VALIDATION
- Validation for date
- Validation for list
- Validation using formulas
Chapter 5: NAME MANAGER
- Defining Names
- Creating Names Automatically
- Managing Names
- Using Names
- Applying Names
- Names in Formulae
Chapter 6: TEXT FUNCTIONS
- Concatenate()
- Left()
- Right()
- Mid(), find(), len()
Chapter 7: LOGICAL FUNCTIONS
- If Statements
- And, or
- Not
- Nested If
Chapter 8: DATE AND TIME FUNCTIONS
- Datedif()
- Weekday(), networkday()
- Today()
- Month()
- Year(), emonth()
Chapter 9: LOOKUP FUNCTIONS
- Lookup
- Hlookup
- Vlookup
- Index, match
Chapter 10: PIVOT TABLES
- Creating a Pivot Table
- Laying out the Pivot Table
- Grouping, value field setting
- Conditional formatting in pivot
- Consolidating the worksheets
- Adding calculated field
- Create pivot table from different source
Chapter 11: WHAT IF ANALYSIS
- Goal Seek; Scenarios;
- Table; PMT Function
Chapter 12: OTHER USEFUL FUNCTIONS
- Iserror
- Islogical
- Countif
- Averageif
- Averageifs
- Sumif
- Sumifs
- Countifs
- Database functions
Who will benefit?
Working professionals in any sector. Aspiring Youngsters, Managers and Professionals.
Medium: English/ Hindi/ Marathi
Fees:
- 3,000 + GST 18% per person 1-3 participants.
- 2,800 + GST 18% per person for a group of 4 or above participants.
Fees include participation, course material (Hard copy), Breakfast, Lunch and tea / coffee with cookies.
Registration Details:
Please write to email: iitdpune@gmail.com; rajiv@iitdworld.com with
Name of the program, participants, Mobile no, company, GST number
- Bank Details, Bank of India, Pune – 411029, Current A/c: 052320110000336, IFSC: BKID0000523.
Certification: Participants shall be awarded a certificate of participation from IITD.
Registrations open up to 22nd Aug 2023.
Seats are limited up to 20 pax, registration is on a first-come, first-served basis.
Customised In-house Workshops:
We would be pleased to conduct specific in-house workshops for your organisation, if you have adequate number of participants.
For enquiries related to corporate training or group nominations, please reach out to us.
We look forward to your active participation and nominations.
With warm regards,
Shilpa Kulkarni/ Rajiv Kolhe
Mob: 7666256426/ 9822089898
Indian Institute of Training and Development (IITD)
Tel: 91 20 4120 3985
Website: www.iitdworld.com
Encl: Training Calendar Classroom
| IITD CLASSROOM Training, Aug 2023@Pune, 9 am to 5.30 pm | ||||
| *Fees Per Person | ||||
| Sr | Mode | Date | Program | 1 – 3 participants; |
| 4 & above (₹) | ||||
| 1 | Classroom | 10 Aug | 5 S Workplace Management | 3600;3400 |
| 2 | Classroom | 11 Aug | 7 QC Tools | 3600;3400 |
| 3 | Classroom | 12 Aug | Workplace Harassment Awareness PoSH | 3000;2800 |
| 4 | Classroom | 23 Aug | Supply Chain Management | 3600;3400 |
| 5 | Classroom | 24 Aug | Advanced Excel | 3000;2800 |
| 6 | Classroom | 25 Aug | Business Communication Skills & Email Etiquette | 3000;2800 |
| 7 | Classroom | 26 Aug | Toyota Production System (TPS) & Kanban System | 3600;3400 |
| *Addl GST@18% as applicable | ||||
“Coming together is the beginning. Keeping together is progress.
Working together is success.” ― Henry Ford
***********