Financial Reporting | Mirical Solutions

MAIN PAGES

-Home Page
-Company Profile
-Free Tutorial Page
-Training Schedule
-Contact Us

BLOG

- Our BLOG

SOFTWARE

-Spreadsheet Auditing
-Spreadsheet Sensitivity
-Spreadsheet Security

NEW Videos

- IRR Calculator
- Count error checks
- Check import headers
- INDIRECT function
- IS number EVEN/ODD
- Is cell a number
- MATCH Function
- Identify missing categories
- Check that data within range
- TEXT Function
- Remove Spaces
- Use ADDRESS

Excel Basics

- Function Wizard
- Audit Toolbar
- Good Design
- Add In's

Tips and Tricks

- Identify missing categories
- Check that data within range
- Count error checks
- Check import headers
- CAGR
- Show all formula
- Fill in blanks
- Data Cleanup
- Multi sheet changes
- Automatic Sort

VLOOKUP tips

- VLOOKUP Use
- Large VLOOKUP's
- VLOOKUP Risk
- Automatic Sorting

Financial

- IRR Calculator
- Interest rate
- IRR
- NPV
- CAGR
- PMT
- Amortization table

Database

- Database

Lookups

- Use ADDRESS
- MATCH Function
- INDIRECT function
- VLOOKUP
- Transpose
- CHOOSE
- OFFSET
- SUMIF/ COUNTIF

Dates

- DATE
- EOMONTH
- EDATE

Statistics

- Rank
- MAX/ MIN

Logical

- IF
- AND/ OR

Text

- TEXT Function
- Remove Spaces
- FIND
- Length
- Join characters
- Change Case
- Extract Text

Information

- IS number EVEN/ODD
- Is cell a number
- ISERROR

Maths

- SUMIF/ COUNTIF

Other Tools

- Data Validation
- Group/Ungroup
- Autofilter
- Workbook protect
- External Links
- Goto Special
- Find/ Replace
- Conditional Format
- Pivot Tables
- Data Sort
- Data tables
- Multiple Windows
- Hyperlinks
- Protect cells
- Paste Special

How errors happen

- Copy/ Paste
- Delete Cells
- Insert rows
- Insert cells
- IF functions
- Linked Sheets
- Hidden Cells
- Lookup's
- MIN/MAX function
- Referencing

What If's

- Goalseek
- Data Tables
- Scenarios
- Watch Window

Download All Videos

- Download All

Financial Reporting

Excel Financial Reporting Course in Rivonia

Apart from our online Excel training series we also provide live courses in Excel from time to time. One of the most popular courses is the Excel Financial Modelling course. It is a full hands-on financial reporting course that is well suited for people working with large data sets and who can already perform basic calculations in Excel. The three day financial reporting course includes topics such as the interaction between balance, cash flow and income statements in financial models.

Delegates will learn how to create financial models and to do advanced financial reporting. The course is presented in a relaxed environment where there will be ample time to exercise new skills learned and where delegates can ask questions.
Some of the topics addressed are that of:

Working with various time periods including the conversion of months into years.

Dealing with inflation, sales prices, exchange rates and other factors which will affect the outcome of the model.

Doing forecasting in Excel for the purpose of creating an income statement.

Working with depreciation, interests, taxes, losses, profit margins, sales, and dividends based on income and cash.

Forecasting aspects surrounding the balance sheet.

How to create the balance sheet and enter fixed assets.

How to indicate equity contributions.

Understanding how to link the income and balance sheet.

Inputting the various forms of debt.

Working with cash flow and indicating tax charged versus the tax paid.

How to indicate interest charged and interest paid.

Other aspects of financial modelling addressed in the course include that of valuations with factors such as WACC, free cash flow and ratios addressed. Delegates will also work with various scenarios, do goal seeking and build a financial model allowing for last minute sensitivities. Finally delegates will also learn aspects of financial reporting in respect of changing periods. Contact us for enrolment information or to find out when our next advanced Excel course will be.