Advanced MS Excel

Advanced MS Excel
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.

 

Prerequisites

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

Faculty

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

 

Organizations

Basic Fee

GST @ 18%

Total

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 register online at  or send your nominations by email to Ms. Sandhya Acharya on sandhyaa@mcciapune.com 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.


TENTATIVE WORKSHOP CONTENTS

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)

 

Ø  PROTECTION AND SECURITY  

  • 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
When
7/20/2018 10:00 AM - 7/21/2018 6:00 PM
Where
Bajaj Conference Hall (no. 2), MCCIA Trade Tower
A Wing, 5th Floor, ICC Complex,
Senapati Bapat Road
Pune, 411016 India

Sign In