This workshop is designed for finance and accounting professionals, who are aware about the excel interface and its regular features. This workshop is focused on learning about nuances of data analytics in today’s world

The participants of this workshop will learn about working on large data sets and complex calculation through understanding data statistically, creating dashboards, dynamic formulas, advanced pivot tables techniques, and many more to create meaningful and insightful information using excel. This workshop will also help the participants to learn concepts of Business Intelligence and its tools in today’s market

Our expert trainer will work with all the participants on huge data sets and practical examples to help them relate to real life analytical problems and optimum approach to its solutions. Hands on exercises will be given helping all the participants to master these functionalities and apply them in a meaningful way

  • Understanding Data Statistically for further analysis
    1. What is Data Analytics and its types
    2. Using Statistical Analysis
    3. Descriptive Vs Predictive Analytics
    4. Concept of Hypothesis testing
    5. Data Modelling Relationship
    6. Correlation and regression analysis techniques
    7. Correlation Vs Causation
    8. Application to Business management
    9. Discussing Examples
  • Dashboard designing
    1. What is Management Dashboard
    2. Principles of dashboard design
    3. Using Advanced formulas to create dynamic data
    4. Linking humungous data with customized view and selections
    5. Mastering Developer Tab
    6. Learning Advanced Pivot table techniques
    7. Using Power Pivots
    8. Using charts and visual data techniques
    9. Hands on exercises
  • Using Excel for Advanced Data Analysis
    1. Managing large Data sets
    2. What if Analysis
    3. Goal Seek
    4. Scenario manager
    5. Learning advanced Financial functions to draw Analysis on given data sets
    6. Learning advanced Nested functions
    7. Application of forecasting techniques
    8. Forecasting using Historical data
    9. Hands on exercises

At the end of the workshop the participants will be able to increase productivity and enhance efficiency in their day to day work by Analysing their excel files much better. Participants will be able to analyze their financial data in a meaningful way to draw further insights and decision making. The aim of the workshop is to make them self confident on data mining and slicing and dicing the data for further analysis and interpretation.

In addition participants will be able to express the data graphically and in dynamic way that helps them to represents complex data sets through best visual representations for senior management and steer committees

All participants should have their laptop with preinstalled MS office.

The training is ideal for those (such as Accountants, Controllers, Finance managers, Auditors and all accounting professionals) who deal with large volume of data & excel in their day to day work for creating reporting solutions, data mining and need excel tools and technologies for further enhancing their efficiency and productivity. This workshop is apt for those people who want to understand the analytical perspective to data and draw further insights

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