MS Excel Newsletters

AuditExcel.co.za are the experts in using Microsoft Excel. We have the specialist capabilities to really make optimum use of this outstanding software.

Below a selection of MS Excel related articles and newsletters. To receive the AuditExcel newsletters direct, subscribe to them below.

Excel Internal Rate Return (IRR)

Excel Internal Rate Return or (IRR) is used commonly in the financial industry to calculate the internal rate of return. Should the IRR be higher than the discounted rate of return, then the investment can be seen as worth the capital.

Learn Advanced Excel

Here at Audit Excel we are specialists in offering expert training courses for you to learn Advanced Excel. As part of our Advanced Excel training you will gain the necessary knowledge required for the efficient of the tools and other exciting extras which this outstanding software has to offer, and so ensure your optimum use of Excel.

Spreadsheet Linking

In the business environment spreadsheet linking is a useful function that adds a lot of value to developments but also a lot of risk. The concept of spreadsheet linking can be defined as the linking of data between two or more spreadsheets in the same workbook or between workbooks.

Spreadsheet Linking

To remove the “Automatic update” pop up that shows every time you open a file that contains spreadsheet linking select Tools from the Excel toolbar, Options. Then Select the Edit tab; uncheck the “Ask to update automatic links”. Click OK, now when you start up a file the links will update automatically without requiring confirmation from you first.

CAGR Excel (Compound Annual Growth Rate)

One of Excel's most spectacular and useful features is the tool which it provides for calculating a CAGR. A CAGR measures the rate of return for an investment - such as a mutual fund or bond - over an investment period of say 5 or 10 years. The CAGR can also be referred to as a "smoothed" rate of return as it measures the growth of an investment as if it had grown at a steady rate on an annually compounded basis.

Excel Sensitivity Analysis

The Excel sensitivity analysis is used to calculate possible scenarios from which comparisons can be made. The Excel sensitivity analysis thus helps to identify what the effects on a model will be if certain factors change.

Consulting

We aim to provide the ultimate, one stop shop for all Excel users requirements, within South Africa and worldwide.

Find Out More

Live Training

"Recently we had a most successful in-house training session at our company. I would like to extend my thanks and gratitude."

Find Out More