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)

"The difference between the impossible and the possible lies in a person's determination."

-- Tommy Lasorda

  
 

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
Remove Filters - AutoFilter Show All

Excel's AutoFilter feature is great for filtering Data lists in Excel. When you have a number of filters in place you may want to view the whole Data list again ...
Drag letters the same as numbers - Is it possible to have Excel increment the letters of the alphabet in the same way it increments numbers, when you drag the fill handle?

Yes, Excel's Custom List feature will allow you to do that. The easiest way to create a Custom list is to enter the letters of the alphabet in a column, one letter per cell going down the page ...
Zoom to a section of the screen - Display tip

Large spreadsheets frequently have the zoom percentage set to below 100% to fit more information on the screen ...
Cumulative Summing - I use cumulative balance columns which add the figure to the left of the cell to the value in the row above the cell. When I insert a row I have to copy the formula from the row above to the new row and to the row below for the column to be correct. Is there a formula that handles inserted rows? I only want to copy the formula down to the inserted row.

The OFFSET function will allow you to create the formula you require. Assuming column A is for text or date input, column B has the values to be accumulated and column C is the accumulation column ...
Dragging Weekdays Only - Is there a way to fill only weekdays?

I want to use the fill handle to drag only weekday names, but I get Saturday and Sunday as well. Is there a way to fill only weekdays?

Instead of dragging the fill handle (a small cross at the bottom right corner of a cell or range) with the left mouse button, drag it with the right mouse button and you will see an option to "Fill Weekdays" ...
 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!