Book Online Tickets for Indian Institute of Training and Develop, Pune. Indian Institute of Training and Development (IITD)
 
Presents 1 Full Day Interactive Workshop on
 
Advanced Excel
 
22nd Mar 2017 (Wednesday); 8:30 am to 5:30 pm (starts at 9.00 am sharp)
 
(Welcome, Registration & Break

Indian Institute of Training and Development (IITD) Presents 1 Full Day Interactive Workshop on Advanced Excel

 

  • Registration Fee

    Sale Date Ended

    INR 2600
    Sold Out

Invite friends

Contact Us

Page Views : 39

About The Event

Indian Institute of Training and Development (IITD)

 

Presents 1 Full Day Interactive Workshop on

 

Advanced Excel

 

22nd Mar 2017 (Wednesday); 8:30 am to 5:30 pm (starts at 9.00 am sharp)

 

(Welcome, Registration & Breakfast 8:30 am to 9:00 am)
Venue: The Ambience Hotel, C.T.S No. 1105/2, Near Telephone Exchange,

 

Lakaki Road, Model Colony, Shivajinagar, Pune ‐ 411016.

 

Please reply on E mail: iitdpune@gmail.com or rajiv@iitdpune.com

 

Website: www.iitdpune.com

 

Certificates will be issued to the participants!

 

Course Deion:

 

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

 

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

 

 

 

Who will benefit? 

 

Working professionals in any sector. Aspiring Youngsters, Managers and Professionals. 

 

 

 

Sr. Expert Faculty: Masters in Computer Management & Masters in Personnel Management.

 

She is an IT and Soft Skills Trainer with 6+years of experience in Corporate trainings. She has trained over 5000 students and has been associated with more than 200 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 & Marathi.

 

Venue Map