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)

"You are designed for accomplishment, engineered for success, and endowed with the seeds of greatness."

-- Zig Ziglar

 
 

Newsletter: Sample

 

Knowledge

Featured White Papers

Download Financial Modelling Best Practice Guidelines

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!

Download

 
Download 7 Mischievous Adventures in Excel

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!

Download

 

Featured Research Articles
Select Formula cells only - Is there a way to select all cells that have a formula?

Yes. Hold the Ctrl key and press the "a" key to select the whole sheet ...

Calculate part of a formula - Keyboard shortcut

Sometimes when creating a spreadsheet you need to see where errors are coming from ...

AA Arrays Introduction - Getting started with array formulae

Introduction

Array formulas are usually considered to be either black voodoo magic, or an advanced topic ...

Enter values in multiple cells - Ctrl + Enter

Ever wanted to enter the same value, say zero, into a range in one go? Ever wanted to enter a formula into a range in one step? Well Ctrl + Enter will do it ...

Days into the year - Using the DATE function

Ever needed to find how may days have passed into a year? For any date in A1 this formula will tell you how many days have passed ...

 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!