Advanced MS Excel : 2nd Batch

Advanced MS Excel : 2nd Batch
For employees and professionals willing to learn the Advanced features of MS Excel ----------------------------------------------------------------------------------------------------------------------- About the Program The beauty of Excel lies in its ability to simplify various tasks like filling out the ledger sheets, calculating and recalculating totals, applying formulae and get desired results. However, the true power lies much beyond this. Excel has capability to use as Decision Support System – DSS tool. This Workshop will provide you an opportunity to get overview of various features of MS Excel which could be applied in your day-to-day work. The demonstration will be based on MS Office 2010 version. The tentative list of contents that will be covered in the two day workshop are available at the bottom of this communication.

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 organization for study & demonstration purpose and to work out better solutions.  The participants should be conversant with basic operations of MS Excel.



Basic exposure to Excel 2010 and handling multiple worksheets, use named ranges, and work with functions.



Mr. Akshay Magre is a professional trainer for Microsoft Office Suite with a robust experience of 5 years in Project & Database Management.  His expertise lies in MS Access, MS Project, MS Excel, MS Visio, VBA, Dashboard, PowerPoint, Word, Power BI Lync, Skype for Business, FastStone, etc.  His major clients have been big giants like Volkswagen, Roll’s Royce, MTU, JCB, Deloitte & BNP Paribas. Akshay has completed his Bachelor Degree in Engineering from Pune University and Diploma in Banking & Finance from NIIT. He is a visiting faculty for Advance Excel 2013 at a B-School in Pune and Mumbai. 


Fees per participant



Basic Fee

GST @ 18%


For MCCIA members

Rs. 3,000/- per day

Rs. 540/-

Rs. 3,540/-

Rs. 5,500/- for both days

Rs. 990/-

Rs. 6,490/-

For others

Rs. 4,000/- per day

Rs. 720/-

Rs. 4,720/-

Rs. 6,500/- for both days

Rs. 1,170/-

Rs. 7,670/-

The fee includes Course Material, Breakfast, Lunch, Tea, etc. Participants are requested to attend both days; however, they can opt for one day, based on their learning requirements.


Group Discount on basic amount @5% will be applicable for 4 or more participants from the same organization and @10% for 11 or more participants from the same organization.

Seats are limited.  Admission will be on First-Cum-First-Serve basis.


Registration Procedure

Please send your nominations by email to Ms. Sandhya Acharya on with details like name(s) of the participant(s), name and contact details of your organization as well as the participants.   Upon confirmation from our side please send payment online or by a cheque drawn in favour of “Mahratta Chamber of Commerce, Industries and Agriculture”, payable at Pune.



Day - 1


  • Working with Advance Charts


  • Column chart advance formatting
  • Combo Charts
  • Exploring new charts
  • Pie chart with data label
  • Line Chart with editing features
  • Working with Advanced Functions


  • Working with Functions
  • Using the IF Function
  • Nesting Functions
  • Using Multiple Conditions with the IF Function

  • Advanced Conditional Formatting


  • Editing Standard Formatting Rules
  • Using Formulas in Conditional Formatting
  • Exploring conditional formatting
  • Advance Formulae (Text & Numeric)
  • Trim, upper, lower, Len, proper, concatenate
  • Find, replace, substitute, search
  • Large, small, max, min, sumif, sumifs,
  • Count, countifs, count, averageifs


  • Working with Data


  • Importing Data from a Text File
  • Exporting Data
  • Converting Text to Columns
  • Creating a Web Query
  • Paste Special
  • Working with Hypertext Links

  • Creating and Working with PivotTables
    • Understanding PivotTables
    • Creating a PivotTable using Worksheet Data
    • Creating a PivotTable using an External Data Connections
    • Laying out a PivotTable on a Worksheet
    • Modifying PivotTable Fields
    • Using a Report Filter
    • Refreshing a PivotTable
    • Formatting a PivotTable

      Day - 2


  • Enhancing PivotTables
    • Working with Summary Functions
    • Sorting Items in a PivotTable
    • Creating a Slicer
    • Grouping Data
    • Applying Label and Value Filters
    • Creating a Calculated Field
    • Creating a Calculated Item
    • Creating Charts from PivotTables


  • Charting Pivoted Data


  • Getting Started with PivotChart
  • Using the PivotChart Tools Tabs
  • Formatting a PivotChart
  • Creating an Advanced Filter
  • Using Database Functions
  • Working with Sparkline’s
  • Shortcuts


  • Discussing shortcuts
  • Toggling shortcuts
  • Essentials shortcuts
  • Working with Dates


  • Shortcut for current Date, Time and Date & Time
  • Net workdays & Intl Net workdays
  • Creating VLOOKUP Functions


  • Using the VLOOKUP Function
  • Using the LOOKUP Function
  • Creating Cell References (Absolute, Relative & Mixed)
  • Specifying A Password For Opening A Workbook
  • Protecting Worksheet
  • Protecting Cells
  • Using The “Read-Only Recommended” Option
  • Removing A Password From An Excel Workbook
  • Protecting A Worksheet Or Worksheet Elements
  • Removing Workbook Protection
  • Allowing Selective Editing of A Protected Worksheet




8/17/2018 10:00 AM - 8/18/2018 6:00 PM
Bajaj Conference hall,
MCCIA Trade Tower, ‘A’ Wing, 5th Floor,
ICC Complex,
MCCIA, S. B .Road Office, Pune 411016 India

Sign In