Microsoft Office Excel advanced programme – Predictive analysis and decisional support

Importance of Excel in business context

In the current business context, information is power. Quick access to the information you need, when you need it, can make the difference between success and failure for the business. One of the tools with great potential in providing decisional support is Microsoft Excel. Excel is much more than just storing data. It provides numerous benefits of data processing: synthesis, summarization, grouping, reporting, comparative statistics, analyzes “what-if” predictive analysis.

No matter what level you are in the pyramid management in your company, Excel is for you!

As we climb towards the top of the pyramid, the amount of data in the reports reduces, but the complexity of data processing increases. For example, the chief executive may need a comparative report highlighting the evolution of company’s products on the market, in a specific period of time and distributed by geographic region. This report is not useful for the Operations Manager, who would be more interested in the detailed report of the processing sequences for the products under his responsibility. Using Excel to manage and process such data helps you save time, improve work effectively at any level, so that you fulfill your goals and the company improves its performance indicators.

What participants will learn?

• To build complex formulas for data processing
• To highlight the data evolution using graphical representations
• To choose the type of chart that is most representative for every situation
• To generate complex reports and highlight the essential through pivot tables
• To perform predictive analysis using Excel tools
• To raise the efficiency of the decision making process
• To get an accurate view of the company’s performance indicators in real time
• To anticipate the evolution of the business through data analysis
• To work efficiently and safe time
• To automate business flows using VBA modules

I. USING ADVANCES FUNCTIONS AND FORMULAS

• Using advanced formulas and nested functions
• SUMIF/SUMIFS functions
• Lookup and reference functions
• Financial functions
• User-defined functions
• Automating business flow with correlated formulas

II. DECISIONAL SUPPORT INSTRUMENTS: PIVOT TABLES

• Advanced options in using pivot tables
• Grouping data in pivot tables
• Introducing calculated rows and columns in pivot tables
• References in pivot tables
• Generating and processing pivot charts
• Building reports based on pivot tables
• Data analysis with PowerPivot

III. PREDICTIVE ANALYSIS WITH WHAT-IF ANALYSIS INSTRUMENTS

• What-if analysis instruments
• Performing manual what-if analysis
• Using data tables
• Scenario Manager: desicional support based on comaparative analysis of scenarios
• Finding solution with Goal Seek
• Using Solver for complex optimisation problems
• Correlating Solver and Scenario Manager for complex predictive analysis

IV. FORMS

• Creating a form
• Adding controls to a form
• Running a form
• Correlating forms with Excel sheets
• Using forms to add records to an Excel sheets through
• Using forms to edit data in Excel sheets

V. USING MACROS AND VBA MODULES

• Registering a macro
• Running a macro
• Opening, editing and deleting a macro
• Defining a macro or a VBA module in Excel
• Using variables in VBA
• Using instructions in VBA

The price includes:

• course facilitation for 2 days, from 09:00 am to 05:00 pm;
• course resources and a participation diploma.

MORE INFORMATION

daniela.penescu@dynamic-learning.ro
+40 744 65 27 00