Power Of Excel In Business Analysis For Effective Decision Making
SYNOPSIS:
Ever notice how easy your co-workers put together their presentation materials for presentation to the Board? Ask them how and they do it so quickly and easily that you cannot follow it? Even if they were to go slow in their explanation and you will start to wonder how they can come up with such complex worksheets.
The good news is we are here to assist you to achieve this using the most widely used spreadsheet application in the world – Microsoft Excel! Yes, the Excel that is already installed on your desktop or notebook.
It is well known that Excel can be used for anything from small spreadsheet of personal finance to massive tables of company’s products, customers, and sales. However, little is known that Excel can be used for presentation.
We are not going to teach you how to use all the Excel functions. We understand this is too much for you to absorb. So, we are going to focus on the essential Excel functions which will enable you to perform sensitivity analysis, scenario analysis, simulations and generate impressive boardroom presentations with ease. One that impresses your boss and aid in your decision making process.
TARGET AUDIENCE:
Entrepreneurs, directors, senior managers, heads of departments, financial professionals, sales and marketing professionals, credit managers, HR professionals, legal professionals, bankers, investors, supervisory and regulatory officers, operations managers and executives who are interested to obtain better understanding of Microsoft Excel for better business control, decision making and boardroom presentation.
DURATION: 3 DAYS
PRICE: $1800
COURSE OUTLINE
- Introduction and Course Overview
- Viewing Excel Functions
- Cell and Range Referencing
- Range Name
- Lookup & Reference
- Choose, Match, Offset
- Vlookup, Hlookup
- Index, Indirect
- Mathematics
- Sumif, Rounding
- Date & Time
- Date
- Information
- IS
- Logic
- IF, And & Or
- Text
- Left, Right, Mid, Len, Find, Search
- Concatenate & Text
- Forms
- Spinner, Scroll Bar, Combo Box, Option Button, Check Box
- Excel Charts
- Interactive Chart Title
- Moving 12 month charts
- Dynamic Charts
- Decision Making
- Handling Uncertainty
- Sensitivity Analysis
- Scenario Analysis
- Add Graphics and Drawings to Worksheets
- Protecting your Worksheets
- Preparing your Workbook for Board Presentation
- Collection of Data – Forms Setup
- Pivot Table
- Workshop Wrap-Up
Home