Access Analytic: financial modelling, management reporting and training to help companies make decisions with confidence
decisions with confidence
financial modelling, management reporting and Excel auditing services
in-house and open learning training courses
Free Excel products, templates and add-ins to download
knowledge, research and whitepapers
contact us
about us
 

Knowledge

> Knowledge Home
> White papers
> Events
> Newsletter
> Success Stories
> Article Topics:
 + Arrays (7)
 + Charts (6)
 + Data Handling (46)
 + Excel 2007 (11)
 + Financial Modelling (19)
 + Formatting (41)
 + Functions (54)
 + Keyboard (13)
 + Mouse (12)
 + Printing (17)
 + VBA - Macros (18)

"If you want to increase your success rate, double your failure rate."

-- Thomas Watson, Sr.

  
 

Newsletter: Sample

  

Free Access Analytic White Papers

Please feel free to download our white papers (free registration using a valid email address is required).

If you would like to obtain further information about any of the areas covered by our white papers, please contact us and we'd be happy to discuss how these can benefit your business.

White Papers

7 Mischievous Adventures in Excel

This white paper has some great ideas on how to have fun in Excel (usually at your colleague's expense!) *evil laugh* If you'd like some ideas about how to mess with your friend's head, download this paper now!

Formats available: PDF (1152kB) | Download

Financial Modelling with Style!

How to use Excel styles to add value to your financial models and make them more usable.

Formats available: PDF (1183kB) | Download

3 Paths to Excel Enlightenment

In our experience, we've seen 3 key areas where businesses can make huge gains in productivity and efficiency.

These lead to information for decision-making that is more accurate more timely, and produced with far less time and effort.

Ultimately, businesses reduce their risk and have more confidence in their decisions.

This white paper provides a wealth of useful information on resolving the issues that are holding your company back from effective decison-making.

Formats available: PDF (417kB) | Download

Turn the Tables on Excel

Data Tables are just one of the features in Excel that can assist in providing valuable insight into key business drivers and save hours of unneccessary work.

Use data tables to simplify running scenarios, and perform sensitivity analysis with ease.

So turn the Tables on and you'll be amazed at the result!

Formats available: PDF (495kB) | Download

Financial Modelling Best Practice Guidelines

Provides best practice guidelines that should be considered when building spreadsheets so as to minimise the risk of errors occurring, and improve reliability. usability, robustness and accuracy.

Essential reading for anyone involved in building financial models!

Formats available: PDF (218kB) | Download

52 Easy Ways to Prevent Spreadsheet Problems

This is a list of common problems we’ve encountered, observed, and fixed over the years.

It's an incredibly useful resource for improving your Excel knowledge, solving your Excel problems, and making better spreadsheets faster.

Formats available: PDF (666kB) | Download

Format Wars: 5 Golden Rules for Adding Impact to Reports

This white paper contains details of 5 Golden Rules that should be considered when formatting your spreadsheets and reports.

Formats available: PDF (827kB) | Download

Is This The Right Version?

Version Control, like an insurance policy, is an expense (of time and effort) that hopefully is never required. But what's the best way to control all the versions that sometimes multiply out of control?

Formats available: PDF (881kB) | Download

White Papers

Our white papers are available in PDF format so you'll need Adobe's Acrobat Reader. If you don't have this installed, you can download it for free here.
 Privacy Policy | Terms & Conditions
top


Copyright © Access Analytic Solutions Pty Ltd 2002-2012 ACN 091 625 697. All rights reserved.
Access Analytic® and its logo are registered trademarks of Access Analytic Solutions Pty Ltd
Suite 143, Level 1, 580 Hay St, Perth WA 6000, Australia. Phone +61 8 6210 8500

Excel® is a registered trademark of Microsoft Corporation

Javascript must be enabled to use this site as all e-mail addresses have been encrypted
to protect against spam-bots. You can use this free tool too!