Advanced spreadsheet courses available through Miricle Solutions

We also have Free training videos on this site ( visit the Home page or the Training Page)

Not only do we provide extensive free online training on Excel through video clips and tutorials, but we also present short spreadsheet courses in South Africa. These spreadsheet courses are on an advanced level and well-suited for people working with accounting, payroll, budgeting, and general business calculations on a daily basis.

Some of the spreadsheet courses we present:

• Advanced spreadsheet techniques course
• Financial modelling course.

The tutors for these courses have extensive experience with the use of advanced tools in Excel to perform complex calculations. As chartered accountants and financial analysts in practice the tutors understand everyday accounting needs and know how to apply Microsoft Excel functions to handle from the simplest to the most complex calculations and analysis. As such course attendees will have the added benefit of being taught functions that can be applied by people who are working with the program on a daily basis.

Topics that are covered include, but are not limited to for instance:

• Formatting
• Using COUNTIF functions
• Pivot table reports
• Lookup functions
• Using the Offset function
• Working with logical tests
• Multiple files
• Data validation methods
• Sensitivity analysis
• Optimisation models
• Valuing companies.

Hands-on exercises and specific project models are used such as a toll road project scenario. The aim is to provide attendees with the knowledge they need of Excel to do financial analysis and maximize their usage of Excel to the benefit of their employers, businesses, and accounting practices. Contact us to book a seat or seats for one of the advanced spreadsheet courses and discover the calculating and analysis power of Excel.