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)
 > Auto Outline
 > Cell Comments and Notes
 > Changing Signs Quickly
 > Converting Rows to Columns
 > Copying visible cells only
 > CSV Files and leading zeroes
 > Data entry via Data Form
 > Days in Financial Year
 > Days into the year
 > Drag letters the same as numbers
 > Easy Group/Outline of rows and columns
 > Excel 2007 Goto and selections
 > Extend the Name Box
 > Extracting characters
 > Filling blank cells
 > Find Data Validation Errors
 > Find the limits of a selected range
 > Find unique entries
 > Fixing downloaded data
 > Fixing trailing minus signs
 > Full Screen
 > Get on Excel's case
 > Going Backwards
 > Grouping Columns and Rows
 > Grouping shortcut
 > Ignore Negative Sign
 > Joining text together easily
 > Link Text Box contents to cell contents
 > List Unique Items in a List
 > Multi-Criteria VLOOKUP
 > Multi-line VLOOKUP
 > Paste SubTotals Only
 > Phantom Links
 > Pivot Tables and grouping dates
 > Remove Filters
 > Rounding via formats
 > Solve leading apostrophe problems
 > Sort Control
 > Split first and last name formula
 > SUBSTITUTE function example
 > SUM positives
 > SUM with Wildcards
 > Use Goto to populate blanks
 > Using Dates in Dynamic Headings
 > Week Numbers
 > Working with working days
 + Excel 2007 (11)
 + Financial Modelling (16)
 + Formatting (41)
 + Functions (54)
 + Keyboard (13)
 + Mouse (12)
 + Printing (17)
 + VBA - Macros (17)

"Singleness of purpose is one of the chief essentials for success in life, no matter what may be one's aim."

-- John D Rockefeller Jnr

 
 

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!