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)
 > Alt + Enter = Insert a line in a cell
 > Array formula to SUM rounded values
 > Cell Styles
 > Change default Cell comments font size
 > Color code your sheet tabs
 > Copying visible cells only
 > Create a Flow Chart
 > Create your own colours
 > Display Day of the Week
 > Display Fraction
 > Do not pass Go To
 > Double Click magic
 > Drawing perfectly horizontal or vertical lines
 > Easy and Quick Formatting
 > Excel 2007 Goto and selections
 > F4 key - Repeat last action and add $ signs
 > Finding Formats
 > Fix for missing Fill Colours
 > Format error cells
 > Full Screen
 > Grouping shortcut
 > Hiding and unhiding quickly
 > Hiding cell contents
 > Hiding sheet gridlines
 > Hiding Zeroes
 > Last Day of the Month + Useful Date Formula
 > Lining up charts and other graphics
 > Link Text Box contents to cell contents
 > Merge and Center warning!
 > Merged cells alternative
 > Organisation Chart
 > Protect and unprotect sheets macro
 > REPT function - create a Cell chart
 > Rounding via formats
 > Shading rows automatically
 > Stop Zeroes Displaying
 > Templates
 > Thousands format
 > Using Dates in Dynamic Headings
 > View Values and Formula at the same time
 > Wrapping Text
 + Functions (54)
 + Keyboard (13)
 + Mouse (12)
 + Printing (17)
 + VBA - Macros (17)

"We are what and where we are because we have first imagined it."

-- Donald Curtis

  
 

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!