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.

Addressing Sarbanes Oxley S404 with Excel’s inbuilt tools

This article will guide you on how to address section 404 of the Sarbanes Oxley act with regards to spreadsheets, using only Excel’s built in tools. Unfortunately the built in tools do not address all the requirements of the SoX act and, depending on your reliance on spreadsheets and their potential impact, you may need to consider some specialized tools.

Pivot Tables

Many Excel users are not familiar with, or are intimidated by the pivot tables feature which Excel has to offer. This is rather unfortunate as the pivot table is one of Excel's most powerful features as it can assist a user to create professional-looking Excel documentation that they never thought possible.

Excel Automatic Sort

Let's look at what you should do, remembering that for any help, there is always us at AuditExcel, so you certainly don't need to feel frustrated or feel like giving up. Automatic sort in Excel is very handy and saves you time.

Spreadsheet Access Controls

Access to Sarbanes Oxley spreadsheets should be controlled to ensure that only authorized staff can gain access and make changes to the spreadsheet. Ideally the spreadsheet should be stored in a folder that only allows authorized staff to access it (contact your IT department to find out which ones to use).

Excel Spreadsheet Sharing Answers

It is possible to also share your workbooks and specific spreadsheets via the Internet and email. By making use of the Google spreadsheets option you can upload an existing Excel workbook to the Internet and make it accessible to a user group.

Breakeven Analysis with Excel

Excel allows the user do a breakeven analysis through the use of the Goal Seek function. It is performed to obtain the total where the sales income is equal to the total costs.

Financial Spreadsheets

Subsequent to the Excel phenomenon spreading over the globe as the result of this program's diverse capabilities and features which it boasts, it is becoming greatly known amongst not only those with experience in Excel but also the general public, that this program can be extremely helpful when it comes to carrying out all the necessary tasks of financial management.

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