Overview of Excel

• Required Laptop & Excel Settings
• Where it all Started from (VisiCalc to Excel 2016)
• What is Excel (The excel Interface)
• What Excel can accomplish when used properly.
• General spreadsheet skills:
• Workbooks, Worksheets, Navigation etc.
• Excel Menus & Toolbars

Entering & Editing Worksheet Data

• What data can we use (Options Dialogue Box)
• Best practice rules when working with data
• Useful shortcut keys
• Entering Text and Values
• Entering Date & Time
• Modifying Cell Content

Essential Worksheet Operations

• The fundamentals: controlling the worksheet view & working with rows & columns
• Working with Formulas and Functions
• Looking for the right function to use
• Best practices in entering and editing function
• The Function Argument Box
• Simple Functions: Basic Excel Functions
• Basic Text Functions in Excel

Working with Formulas and Functions (Cont’d)

• Joining and Splitting Text in Excel

• VLOOKUP Mastery
• What it is & how to use it efficiently
• Case Study Application

Referencing Exercises

• Understanding the 4 ways to reference cells and ranges
• Sales Projections
• Scenario Analysis in Excel

Analysing Data Using Charts

• Introducing Charts
• Types of Chart: Line, Bar, Pie, Radar, XY charts etc.
• Chart elements
• Applications & Best Practices

Formatting in excel

• Understanding custom number formatting
• It is a matter of Looks
• Inside Looks (Format Cell Dialogue Box)
• Outside looks (colours, shadings etc)
• Simple conditional formats
• Creating & Using format Template

 Consolidating Data

• Summarising Large Datasets
• Using Subtotal tools
• Linking multiple sheets
• Other Excel data management techniques

Intro to Data Analysis

• Sorting
• Filtering
• Subtotal
• Intro to Pivot table
• Questions and Answer

What is Next

• How to Register for Online post training support from dbrownconsulting
• What Skills to learn next

Overview & Objective 

This course (Power Excel 2) is a “no agenda” Classroom based course. It is closer to consulting than training and it’s main aim is to directly improve the productivity of participants by solving major spreadsheet reporting and analysis problems they may have.

We have one simple rule for the course; “The 10 minute rule!”. We believe nothing should take you more than ten minutes to solve in Excel, including those hectic month-end reports that force you to work overnight at your offices.

We will teach you our time tested report automation methodology that just works and works all the time. We will show you the secrets of becoming very productive; you will quickly become the Excel Guru at your office.

You will leave this course with fresh templates that will replace your current time consuming methodologies

Other Details

Course Duration 3 Days

Who should attend?
All experienced users of Microsoft Excel.

Pre requisites
Power Excel 1 or a passing score in our online Excel Proficiency Test

Learning Process
Blended learning methodology using group discussions, exercises and case studies.

A Laptop with Microsoft Excel 2010, 2013 or 2016 installed is required for this course.

Maximum class size is 20.

Learning Outcomes

Financial decisions are critical in any business, knowing the right questions to ask and understanding the impact of decisions made is critical. This course aims at giving you the basic finance and accounting knowledge you will need to drive growth in your organisation.

Topics include selected aspects of finance that would be beneficial to a non finance specialists including; Interpretation of financial statements, DuPont Analysis, working Capital management, financial impact of strategic decisions, cash flow drivers and more.

By the end of this course, participants will be able to;

• Understanding the Importance of Financial Analysis
• Company Annual Reports – What they are and are not
• Understanding Financial Terminology & Presentation
• Analysis of the Income Statement • Analysis of the Balance Sheet
• Cash Flow Statements Analysis and Why Cash Is King
• Understand and interpret the Working Capital Cycle
• Detailed Shareholder return analysis using DuPont Ratio Analysis
• How to detect Earnings Management • Common Size Presentation, Comparative And Industry Analysis- Strategy, Success & Failure: SWOT & PEST Analysis, Good Sources Of Information, Corporate Governance, Corporate Strategy
• Risk Analysis using simple risk models like the Z-score
• Capital & Valuation: Defining Debt And Equity, Gearing and Leverage
• Why read the footnotes: Learn about off Balance Sheet Items (How A Company Can Be Legally 100% Equity In The Books But In Actual Fact Is 100% Debt)
• Basic overview of valuation and how to identify valuable companies

Other Details

Who Should Attend?

Everyone in an organisation with limited financial analysis skills including; Lawyers, Senior Executives, Board members, HR Administrators, Stockbrokers

Prerequisites
None

Learning Process
Blended learning methodology using group discussions, exercises, case studies and online revision tools.

Maximum class size
for In-house/Open Delivery – 20.

DAY 1

Overview of Accounting & Financial Statements

• What is Financial Statement Analysis
• Quick Review of Accounting Concept
• The Accruals Concept
• Company annual reports – what they are and are not
• Understanding financial terminology & presentation

Financial Reporting & Basic financial Analysis

• What financial statements are and what they’re really supposed to tell us
• Understanding the rules of accounting standards (IFRS, GAAP, SAS etc.) and how it applies to your analysis
• Horizontal Analysis
• Vertical Analysis
• Common size Statements
• Comparative/industry analysis
• Other Analytical Procedures

Analysing Financial Performance & Profitability

• Understanding the P&L structure and lines
• Calculate and Evaluate various profitabilty measures
• understanding return on assets and return on equity
• Using the price-earnings ratio to compare stock values
• The relationship between earnings and stock returns
• What interest coverage means

Analysing the Financial Position & Sustainability

• What goes into working capital and how it can increase and decrease during the normal course of business
• Valuing assets and why it can be tricky
• Calculating a Company’s operating cycle
• Important things the Balance Sheet can tell you about a business
• Sorting through the Balance Sheet: Assets, liabilities and equity
• The role of the Z score in predicting bankruptcy
• Why you must review and understand footnotes to the accounts
• Ways the Balance Sheet can misrepresent-and mislead
• How to recognize warning signals early on-before a crisis occurs

DAY 2

Analysing the Cash flow Statement

• Understanding the purpose of the cash flows statement
• Types of cash flow statements
• The key test of cash flows health
• Why Cash is King • Interpreting cash flow patterns • Cash vs Income, what you should know
• Cash management tools

Ratios Analysis Practice Session (Case Studies):

• Detailed Dupont Analysis
• Accounts receivable analysis
• Asset and Activity Ratios
• Financing ratios – Analyse the Company’s capital structure with debt-to-equity ratios
• Finding the optimal capital structure
• Interest coverage ratios
• Using ratios to predict trends

Other Topics

• How financial statements often conceal more than they reveal
• What is Earnings Management • How to detect Earnings Management
• Ethical consideration and Corporate Governance
• Accounting Standards and how they affect your analysis.
• PEST Analysis • Time Value of Money calculations
• Wrap up and Q&A