• weekwid: false
  • widHeader: false
  • orgName: register@princetonacademy.co.in
  • orwid: false

Advanced Excel With Formulas, Charts, Pivots & Macros (2 days)

Fri, 17 Apr 9:30AM - 5:30PM
JW Marriott Mumbai Juhu
Rs 11210
123 people viewed this event.
I Am Interested

Get notified when the event happens next time.




The Advanced Excel Course 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.
This Advanced Excel Course 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.
  • Consolidating and managing data from multiple workbooks.


Course Content

  • Advanced Formulas and Functions:

    • Advanced Financial Functions
    • Advanced Logical & Error Functions
    • Advanced Text Functions
    • Advanced Date & Time Functions
    • Advanced Lookup & Reference Functions

  • What If Analysis

    • Scenario Analysis
    • Goal Seek
    • Data Table

  • Data Consolidation
  • Working with Duplicates
  • Data cleaning in Excel
  • Data Validation

    • How to lock values and formulas in your Excel worksheets
    • Track down mistakes in your worksheet using the Formula Auditing tools
    • How to share your Excel workbook and not worry about someone making changes thatll ruin your work
    • How to use Data Validation to make sure the data going into any cell meets the criteria youve specified

  • Advanced Custom Formatting                                                                                                  
  • Advanced Conditional Formatting
  • Sparklines, Slicers & Timelines
  • Debugging formulas to check the errors
  • Advanced Pivot Tables

    • PivotTable calculations
    • Using slicers in PivotTables
    • Conditional formatting in PivotTables
    • Creating PivotCharts

  • Advanced Charting
  • Macros (Optional)
  • Tips & Tricks
Login to View Organizer Details
Like this event ? Share it with your friends !!

Map & Directions

Map & Directions
JW Marriott Mumbai Juhu Juhu Tara Rd, Uditi Tarang Housing Colony, Juhu Tara, Juhu, Mumbai, Maharashtra 400049, India
No reviews available
Write a review
Be the first one to review! Share your experience.

Frequently Asked Questions

Have any query? Drop your questions here !!
EventsHigh Specials, bund garden, microsoft, data validation, debugging, Princeton - Academy Mumbai 2, startup and entrepreneurship, classes and workshops, tech workshops,