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.

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.

COMBIN Formula in Excel

The COMBIN formula is extremely useful as it is used to derive at a number of combinations for a specific total of items. The COMBIN formula can thus be used to get the possibilities of groups for a total number of items

Comparison Charts

Decision making is an important factor that forms part of all everyday business situations, whether the decisions are big or small they are still to be made. The bigger the risk involved in making a decision the more analysis goes in to preparing for an answer. With Excel's logical expressions it is easy to represent data from over a period of time graphically with comparison charts.

Data Tables

Data tables are defined as a range of cells that are used for testing and analyzing outcomes on a large scale. It is a way to see how altering the values in a formula affect the results. Data tables can store the results of multiple scenarios in your spreadsheet, and saves you time in calculating multiple formulas. These tables are written in array formulas; this allows the user to perform multiple calculations in one location.

Improve your Microsoft Excel skills through hands-on exercises

Improve you Microsoft Excel skills by visiting our free training pages where tips are shared and where you can watch step by step videos on using the various functions. You can further improve your Microsoft Excel skills within two or three days by attending one of our advanced courses where you will receive hands-on training.

Excel accounting features

Some useful Excel accounting features are shared below. As one of the Microsoft programs developed specifically to manage data and various financial data applications, the Excel accounting features are extremely user-friendly.

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