mumbai
Date
  • weekwid: false
  • widHeader: false
  • orgName: register@princetonacademy.co.in
  • orwid: false
https://www.eventshigh.com/detail/mumbai/3d0d53db4756eb908ed9e4137b0f28b4-advanced-excel-with-macros

Advanced Excel with Macros

19.101771336172,72.825847521643
Wed, 19 Jun 9:30AM - 5:00PM
Rs 11210
125 people viewed this event.

Pricing & Offers

Pricing & Offers
Zero convenience fee, ticket price shown below is the final price.
Wed, 19 Jun
, 9:30AM
- 5:00PM
Register Now
This tickets includes refreshment and course material
₹ 11,210
Show

Details

Details

Overview

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
    • Advanced Mathematics and Statistics Functions
    • Advanced Information Functions

  • What If Analysis

    • Scenario Analysis
    • Goal Seek
    • Data Table

  • Data Consolidation
  • Working with Duplicates

    • Using the Remove Duplicate command
    • Array formula to locate duplicate data

  • 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 use the Trust Center settings to manage Excel security
    • How to share your Excel workbook and not worry about someone making changes that’ll ruin your work
    • How to use Data Validation to make sure the data going into any cell meets the criteria you’ve specified

  • Advanced Custom Formatting
  • Advanced Conditional Formatting
  • Sparklines, Slicers & Timelines
  • Random Numbers
  • Debugging formulas& Dependency Tree
  • Counting Unique, Generating Unique List
  • Working with Duplicates
  • Advanced Pivot Tables

    • PivotTable calculations
    • Creating separate sheets for PivotTables
    • Using slicers in PivotTables
    • Summarizing pivot data
    • Sorting and filtering data
    • Conditional formatting in PivotTables
    • Creating PivotCharts

  • Advanced Charting
  • Macros
  • Troubleshooting Excel Problems
  • Tips & Tricks

Who should attend?

 

  • Finance professionals: Create and analyze powerful financial reports to keep your finger on the pulse of your business
  • Sales professionals: Effectively track your sales against the target and identify performance by sales rep, area or product
  • Marketing professionals: Maximize your ROI by keeping track of your campaigns
  • HR professionals: Utilize employee turnover reports, leave reports or training and development reports to cultivate the right environment for your people
Login to View Organizer Details
Like this event ? Share it with your friends !!
Show

Map & Directions

Map & Directions
JW Marriott Hotel Mumbai Juhu Tara Road, Juhu Beach Mumbai India 400049
Reviews
Reviews
No reviews available
Write a review
Be the first one to review! Share your experience.
Show

Frequently Asked Questions

FAQs
Have any query? Drop your questions here !!
Show

Other Events By Princeton - Academy Mumbai 2

EventsHigh Specials, classes and workshops, personality development classes, tech workshops, startup and entrepreneurship,