- Understanding Data Statistically for further analysis
- What is Data Analytics and its types
- Using Statistical Analysis
- Descriptive Vs Predictive Analytics
- Concept of Hypothesis testing
- Data Modelling Relationship
- Correlation and regression analysis techniques
- Correlation Vs Causation
- Application to Business management
- Discussing Examples
- Dashboard designing
- What is Management Dashboard
- Principles of dashboard design
- Using Advanced formulas to create dynamic data
- Linking humungous data with customized view and selections
- Mastering Developer Tab
- Learning Advanced Pivot table techniques
- Using Power Pivots
- Using charts and visual data techniques
- Hands on exercises
- Using Excel for Advanced Data Analysis
- Managing large Data sets
- What if Analysis
- Goal Seek
- Scenario manager
- Learning advanced Financial functions to draw Analysis on given data sets
- Learning advanced Nested functions
- Application of forecasting techniques
- Forecasting using Historical data
- Hands on exercises
I loved the sessions on formulas, shortcuts and graphs. Given my profile I will be able to apply these to my job immediately
Personal Assistant
Awin Resource
It has been a great experience of getting trained from Divya on the excel tools. The curriculum has been well designed and she is very interactive in the sessions and keeps everyone involved with the practice sessions and throughout otherwise also. Thank you Divya for explaining all the concepts so nicely.
Finance Manager
Asian Pay Television Trust
Very clear explanation on each topic and very approachable. Very handon due to given practice exercise.
Senior Accountant
APTT Management PTE. Limited
key takeaways include use of formulas, charts and shortcuts which I can implement in my day to day work
Senior Banking professional
Deutsche Bank
What I liked about the session is that it was very interactive with lost of hands on exercises.
Senior Management Professional
Schnitz
the sessions on formulas and smart charts were very helpful. These will help me in my regular day to day work.
Regional Finance Officer
Epsun Singapore
The trainer was very approachable. Her hands on approach helped me understand excel in more detail and should help me manage my work efficiently.
Analyst
Cotton on Pte Ltd
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
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 info@outsourcingwise.com
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