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.
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.
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, for better understanding and practical experience. The participants may also bring with them live data pertaining to their organization, so that these can be studied during the workshop, as to how it can be worked out with better solutions.
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
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
• Mid(), find(), len()
Chapter 7: LOGICAL FUNCTIONS
• If Statements
• And, or
• Nested If
Chapter 8: DATE AND TIME FUNCTIONS
• Weekday(), networkday()
• Year(), emonth()
Chapter 9: LOOKUP FUNCTIONS
• 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
• Database functions
Chapter 13: MACROS AND TEMPLATES
• What is Macro
• Recording Macro
• Storing macro, saving macro at secured location
• Adding command buttons, form controls
• Understanding VB Editor
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
Medium: English, Hindi & Marathi
Fees and Registration:
Investment (Donation): Rs. 2,600/- + Service Tax 15% per person.
Incentive: Rs. 2,400/- + Service Tax 15% per person for a group of Three or more Members from the same Organization.
Fees include participation, course material (Hard copies), Breakfast, Lunch and tea / coffee.
Kindly provide below details through mail.
• Name of the workshop:
• Name of the participants:
• Company Name and address:
• Contact details of Participants (Email ID & Number)
REGISTRATION IS MANDATORY IN ORDER TO BE PART OF THE PROGRAM.
You can also call us on 8308459802 (Ms. Anushree).
The participation fee can be paid by way of DD/Cheque drawn in favour of “Indian Institute of Training & Development” payable at Pune or through NEFT.
NEFT/Bank Transfer details ‘Indian Institute of Training & Development’
Bank Name: Bank of India
Current Account No: 052320110000336
ISFC Code BKID0000523
Branch Kothrud (Gujarat Colony),Paud Road, Pune 411029
Service Tax No. BDNPK3328J SD001
PAN No. BDNPK3328J
Certificate of Participation would be provided to all the participants.
We have many more new, exciting & innovative programs to share with you.
We look forward to your active participation and nominations.
With warm regards,
Indian Institute of Training & Development (IITD)
Website - www.iitdpune.com