Events Quick Links

Click here to view Newsletter

Quick Links
Become a member
Be a volunteer
Conduct Training Program
About Event
Advance MS Excel (Version : 2010) - March 2018

Location : CSI Mumbai Chapter
From Date : 30-3-2018 To Date : 31-3-2018
Event Time 9:30:AM    



Computer Society of India, Mumbai Chapter


Two days hands on workshop on

Advance MS Excel (Version : 2010)

30th & 31st March 2018

Mumbai, From 9:30 am to 5:30 pm


This program 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.


Who Should Attend?

Participants attending this training should be familiar with the basic operations in Microsoft Excel, such as simple calculations, formatting and printing.

Executives and managers who have already been using Microsoft Excel, but now feel the need for learning more powerful features and options of Excel, to manage their worksheet-related tasks more efficiently.


This Advanced Excel training program will empower the participants to be able to do the following:

  • Performing complex calculations more efficiently, using various Excel functions.
  • Organizing and analyzing large volumes of data.
  • Creating MIS reports.
  • Designing and using templates.

Course Contents:


Module 1: Overview of the Basics

  • Explore the User Interface
  • Work with the Ribbon & Backstage view
  • Work with Contextual Tabs
  • Use the Excel Galleries
  • Customize the Excel Interface


Module 2: Working with Cell Reference

  • Understanding Cell Reference
  • Working with all kind of cell reference(Relative, Absolute & Mixed)
  • Understanding Mixed cell reference with some formulas


Module 3: Working with Formulas &  Functions


  • Writing conditional expressions (using IF)
  • Using Nested IF
  • Limitations of IF
  • Using logical functions (AND, OR, NOT) inside IF
  • Using Date & Time function in IF


Module 4:  Sorting and Filtering Data

  • Sorting lists
  • Sorting data according to color
  • Different option of Sort
  • Using multiple-level sorting
  • Using custom sorting
  • Using simple Filter
  • Working with top/bottom records
  • Working with date filter
  • Using wild card in filter
  • Working with text filter
  • Understanding advance filter
  • Copying filter data into different location using
  • Working with unique records in filter


Module 5: Working with Styles & Formatting

  • Cell Styles
  • Creating lists using Table
  • Formatting the structure of a list
  • Conditional Formatting
  • Working with different option of conditional formatting
  • Using formula/function in formatting


Module 6: Working with VLookup & Index and Match

  • Using simple VLookup  
  • Using Column function in Vlookup
  • Limitation of  Vlookup
  • Joining two Vlookup using Concatenate function
  • Working with Index & Match function
  • Understanding Hlookup function



Module 7: Working with Range Names

  • Defying a range name
  • Defying the scope of a range name
  • Modifying/deleting the range name


Module 8: Data Validations

  • Specifying a valid range of values for a cell
  • Specifying a list of valid values for a cell
  • Specifying custom validations based on formula for a cell


Module 9: Working with Templates

  • Designing the structure of a template
  • Using templates for standardization of worksheets


Module 10: Working with Reports

  • Creating subtotals
  • Multiple-level subtotals
  • Creating Pivot tables
  • Formatting and customizing Pivot tables
  • Using Multiple options of Pivot tables
  • Creating group in Pivot tables
  • Pivot charts
  • Using external data sources
  • Using data consolidation feature to consolidate data


Module 11: More Functions

  • Date and time Functions
  • Text Functions
  • Math & Statistical Function(SUMIF,COUNTIF,


Module 12: What-If Analysis

  • Using goal seek
  • Using data tables
  • Creating and editing scenarios


Module 13: Workbook Sharing and Auditing

  • Tracking changes
  • Tracing precedents and dependents
  • Tracing errors


Module 14: Basic of Macros

  • Recording and executing macros
  • Understanding different types of references in macros
  • Assigning macros to Quick Access Toolbar
  • Editing macros using VBA Editor







Registration Fees:


Registration Fees


CSI Member


Non CSI Member





  • The cheque / DD in favour of "CSI Mumbai Chapter" Payable at Mumbai.
  • Registration fees covers courseware, lunch, Tea/Coffee and CSI Certificate.
  • Group discount is available for minimum 5 number of registration.
  • Non CSI Member can avail discount in fees by becoming member of the society for details

Visit :

  • Note: Payment is to be made in favour of “CSI Mumbai Chapter” A/c No. 10606576641 Payable at State Bank of India, MIDC, Andheri East, Branch, Mumbai - 400093.RTGS/NEFT Code: SBIN0007074 (All Major VISA / Master Credit / Debit cards will be accepted)

Venue & For Registration Contact:

Harsh Mane

CSI Mumbai Chapter,

E-217, 2nd Floor, Floral Deck Plaza, MIDC, Near Sunrise Tower, Andheri East, Mumbai – 400093

Tel:022 28235476 / 28235548, Mobile 9819089527, 9768550926


Participation only through advance registration, (Batch size : 20 participants only)

Note – Out station participants need to confirm at least 5 days prior to the commencement of the training


This mail is not spam mail and is a genuine communication from Computer Society of India (CSI) Mumbai Chapter to its members and other IT Professionals to inform them about the forthcoming event. If you feel that this mail should not have been sent to you or you want similar communication to be sent to your different e-mail address, please reply to this mail and specify it in the message.



Normal Event Charge : 5900 Rs/-
Event Charge For Early Bird : 5900 Rs/-
Event Charge for Student Member : 2950 Rs/-
Event Charge for CSI Member : 4720 Rs/-
Event Early Bird Days Date : 29-3-2018
Open For : All
Download Brochure  

You can be the sponsorer to this event and reach to more than 1,00,000 Members through our Mailer and other promotions
Computer Society of India.
    All Rights Reserved 2012.

Digital Marketing Partner
Home | Privacy Policy | Contact Us | Downloads
Powered By : Mahalasa Infotech