This workshop is designed for all professionals, who are involved in data gathering, analysis and creating meaning inferences for the business. This workshop will be suitable for those who are aware about the intermediate excel functionalities and are ready to work on complex business problems.

This workshop is focused on learning advanced excel formulae’s and functions and learn new excel tips and tricks to use them in their daily routines.

Our expert trainer will work with all the participants on huge data sets and work on practical examples to help them gain expertise in all the advanced formulae’s and functions, complex charting techniques with enhanced functionalities, mastering pivots and learning MACROS.

Hands on exercises will be given by working on complex workbooks helping participants to summarize and organize data for meaningful reporting and help them derive insights

Mastering advanced formulae’s like

    1. Look up functions,
    2. IF conditions and nested IF’s,
    3. Date and Time Functions,
    4. SUMIF and COUNTIF,
    5. Text functions,
    6. Creating references,
    7. INDEX,
    8. MATCH,
    9. ADDRESS,
    10. OFFSET, etc.

Mastering lookup functions

    1. Nested IF’s conditions
    2. Creating cell references
    3. Create complex nested formulae’s
    4. Advanced Date Functions
    5. Statistical Functions
    6. OFFSET
    7. INDEX
    8. ADDRESS
    9. SUMIF S
    10. MATCH, etc

Hands on exercises for applicability of complex formulae’s

Creating Dynamic excel workbooks:

  1. Working on humungous data sets and Creating robust data and making it user friendly
  2. Creating Dynamic dropdowns and linking data basis different criteria’s

Mastering Pivot Tables:

  1. Creating complex Pivot tables
  2. Creating summaries in Pivots
  3. Adding and Removing Subtotals
  4. Using Slicers in Pivot Table
  5. Creating graphical representations through pivots
  6. Inserting formulae’s in Pivots
  7. Customizing pivot data
  8. Using advanced filters
  9. Managing rows and columns to achieve required results
  10. Creating reports out of pivot tables
  11. Introduction to Power Pivots

Participants to work on multiple examples to master creating complex reporting solutions through pivot tables.

Forecasting data and graphs


Expertise in graphical representation through Charts

    1. Summarizing data visually through charts like pie charts, bar graphs, line charts,area charts and many more
    2. Mastering the art of depicting information graphically by working on multiple 2D and 3D charts.
    3. Creating combination charts and customized version of different charts to show the information as per the problem statement
    4. Developing 3 dimensional charts with practical examples
    5. Use of waterfall charts for professionals
    6. Uses and applicability of Bubble charts
    7. Use of combination charts
    8. Plotting and Highlighting geographical presence
    9. Analysing different business solutions diagrammatically and mastering the art of creating charts

Learning about Macros for efficient effectiveness and automating the regular reporting of KPIs

  1. What is VBA
  2. Uses and applicability of Macros
  3. Identifying power of Excel
  4. Recording and Testing of Macros
  5. Mastering the developer tab
  6. Relative and Absolute Recording
  7. Running and deleting macros
  8. Examining the MACRO codes
  9. Altering and Modifying macros
  10. Creating your own macros

The participants of this workshop will learn logic, and statistics that save your time. The partciapnts will be able to efficiently work on day to day processing but also for interpretation , uncovering insights and insight generation in their day to day work, increasing accuracy of work, preparing forecasts and any other form of data driven decision making. In addition, you can learn about creating customizations, add your own data driven decision variables, and modify functions, using complex calculation through nested functions, dynamic formulas, enhanced pivot tables and its features, modifying and creating complex charts, dynamic filtering conditions and creating meaningful and insightful information using excel.

In addition participants will understand about VBA and get knowledge of Recording macros and creating their own macros and use them to perform their daily tasks efficiently

This workshop will also help the participants to learn new excel shortcuts that will help them increase their productivity in their day to day work

All participants should have their laptop with preinstalled MS office.

All Corporate professionals, sole proprietors, SMP’s or any company personnel or individual who are involved in managing raw datasets who use excel not only for day to day proceesning but for any other form of data mining to convert raw data to meaningful analysis.

The aim of the course is to make the participants learn advanced excel tips and techniques in a way that helps you enhance your productivity, speed and make your work much easy to interpret.

You can discuss your unique requirements at +65 84831463 or simply fill the required details on Enquiry Now Page and send us at

Enquire Now

Course Cancellation / Reschedule Policy

OutsourcingWise reserves the right to cancel or reschedule the course due to unforeseen circumstances. If the course is cancelled from our end, management will refund 100% to its participants

Note: the minimal class size to start the class would be 3 pax