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)
 > 3D Sum formula
 > 3D SUMIF formula
 > Alternative to IF
 > Auto Correct Explained
 > Calculating with months
 > Copy quickly between sheets
 > Counting non-blank cells
 > Counting weekdays
 > Cumulative Summing
 > Data entry shortcut
 > Days in Financial Year
 > Days into the year
 > Display Sheet Name
 > Dualing Screens
 > Dynamic Headings
 > Dynamic Range Name
 > Easily Trace Formulas Back
 > Extracting characters
 > Financial Year formula
 > Finding Numbers
 > Formula to stop Error messages
 > Full Path of current file
 > Function wizard
 > Get on Excel's case
 > How many months between two dates
 > In cell Drop Down
 > Line break within a cell
 > List Range Names
 > Mulitply a range of cells by a factor
 > Multi-Criteria VLOOKUP
 > Multi-line VLOOKUP
 > Paste Hyperlink
 > Phantom Links
 > Random Numbers
 > Refering to cells within a range name
 > Rounding to 5 cents
 > See All Menu Options
 > Select Formula cells only
 > SUM function to handle inserted rows and columns
 > SUM positives
 > SUM shortcut
 > SUM with Wildcards
 > Tips on debugging formula
 > Today's date formula
 > Today's Date shortcut
 > Toolbar overload
 > Use a Range Name in a single sheet
 > Using checkboxes on sheets
 > Using MAX and MIN instead of IF function
 > Using the AND + OR functions
 > View range names
 > Week Numbers
 > XLSTART folder
 > Zoom to a section of the screen
 + Keyboard (13)
 + Mouse (12)
 + Printing (17)
 + VBA - Macros (17)

"Business is going to change more in the next ten years than it has in the last fifty."

-- Bill Gates

  
 

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!