Access Analytic: financial modelling, management reporting and training to help companies make decisions with confidence
<IMG SRC="/images/bw_images1.gif" WIDTH=312 HEIGHT=62 usemap="#bw_images1" BORDER=0>
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
> Lunch & Learn Events
> Newsletter
> Success Stories
> Article Topics:
 + Arrays (7)
 + Charts (6)
 + Data Handling (46)
 + Excel 2007 (11)
 + Financial Modelling (16)
 + Formatting (41)
 + Functions (54)
 + Keyboard (13)
 + Mouse (12)
 - Printing (17)
 > Auto Outline
 > Change page orientation on all sheets
 > Change print page to A4
 > Create a Flow Chart
 > Enter & symbol in the Header or Footer
 > Full Path name in Footer
 > Full Path of current file
 > Getting Great Margins
 > Hiding cell contents
 > Hiding Zeroes
 > Page Break View
 > Print all sheets in one step
 > Print Title Tips
 > Printer Trays in VBA
 > Printing marginally better
 > Speeding up Print macros
 > Thousands format
 + VBA - Macros (17)

"We will either find a way, or make one."

-- Hannibal

  
 

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

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-2010 ACN 091 625 697. All rights reserved.
Access Analytic® and its logo are registered trademarks of Access Analytic Solutions Pty Ltd
Ground Floor, Unit 110/131 Adelaide Tce, East Perth WA 6004, 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!