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)
 > AA Arrays Introduction
 > Array formula to SUM rounded values
 > Excel 2007 - New Functions
 > Formula for the last used cell in a column
 > Last Used Cell in a Row
 > Multi-criteria SUMIF
 > SUMIF - more than one condition
 + Charts (6)
 + Data Handling (46)
 + Excel 2007 (11)
 + Financial Modelling (16)
 + Formatting (41)
 + Functions (54)
 + 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

 

Lunch & Learn Events

We hold quarterly "Lunch and Learn" events on various topics of interest in Excel, financial modelling, and management reporting.

Table Sponsor Package:

  • 10% discount
  • Company name displayed on the table
  • Thanks and acknowledgement from the podium
  • Logo displayed on screen while the meal is served

Events Scheduled

DateDescription
12:30 PM Wed 20 Oct 10

TBA
Excel 2010: a Spreadsheet Odyssy!
New Version, New Features ... How useful?


The new version of Excel is out with a range of new features. Are the new features useful for businesses? Can they make your life easier? YES! Come along and find out how.

Brochure | Bookings ($99 (individual), $699 (table of 8))

Previous Events

We're happy to present any previous session as an in-house event for your staff or at a conference. Just contact us on +61 8 6210 8500 to discuss.

Description
I Never Knew Excel® could do THAT!
What your Unknown Unknowns can do for you!


There’s an incredibly powerful program that has the potential to make your life a whole lot easier. It has the ability to turn boring data into incredibly useful, interactive analyses; give you the visualisations you need to make decisions; plus save a ton of your time … and it’s sitting right under your nose, right now! What is it?

Microsoft Excel®!

Think you know what Excel® can do? Maybe there’s more! Come along to this Lunch and Learn event and you’ll really see the things this program could do for you in the hands of a true expert!

Brochure
Maximising your Excel Productivity
How to do more in less time!


This is a 30-45 min session that is focussed on helping attendees become more productive and get more done in less time. It’s a great session for users at all levels since it provides useful tips and shortcuts that everyone can benefit from. The key sections in the Excel 2007 version of this presentation are:
  • Excel 2007: new shortcuts & features
  • Timesaving mouse & keyboard combinations
  • Control & Shift key secrets
  • More effective use of range names to simplify formulas and ensure reliability
  • Using conditional formatting to create powerful visualisations
  • Using data summarisation to improve readability and usability


Brochure
Lunch & Learn: "Excel 2007 - Licensed to Thrill"
7 ways to Spice-up your Spreadsheets!


In the latest version of Excel, there are a lot of useful, new gadgets that can make your spreadsheets almost as slick as an Aston Martin!

These things can make your presentations and reports not only look better, but also add clarity and confidence to your communication!

Brochure
 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!