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)

"Every day, remind yourself of your own ability, of your good mind, and affirm that you can make something really good out of your life."

-- Norman Vincent Peale

  
 

Newsletter: Sample

  

Events

We hold regular events on various topics of interest in areas related to Excel, financial modelling, management reporting and spreadsheet auditing.

In addition, we often speak at conferences, seminars and other events around the world. Just contact us on +61 8 6210 8500 if you'd like to know more.

Events Scheduled

No Events Found

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
Get a Better Deal when Buying or Selling a Business
Avoid the Pitfalls that can cost you Thousands!

Buying or selling a business is very different to buying or selling any other asset.

There are so many issues to consider:

  • How and what should you prepare before you buy or sell?
  • How do you do your due diligence on the other party?
  • How should you present your financial information?
  • What are the tax implications?

Missing an issue or getting something wrong can cost you a LOT of money ... and although these are avoidable, people always get caught out!

This presentation will provide invaluable insights into these areas (and more) that can help you create thousands of dollars in extra value next time you’re buying or selling a business!

Book a Table
This is a great event to invite your colleagues and/or clients along to!

Tables of 8 receive a 10% discount plus your company name is displayed on the table, your support is acknowledged from the podium and your logo is displayed during lunch.

Who Should Attend?
- Business Owners
- Directors
- CEO's, CFO's, Managers
- Accountants & clients
- Advisers, Bankers & clients
- Consultants & clients



Brochure
FINSIA Seminar: Trends in Mergers & Acquisitions
Outlook and opportunities in 2011

The past 12 months have seen an increasing level of M&A activity, but it was a mixed year with some notable successes and failures.

FINSIA brings you this interactive workshop which will explore the M&A arena in 2011 and beyond and discuss where the opportunities lie for Australia in both domestic and international markets.

Expert speakers will discuss trends in deal structures and financing, global deal flows, the impact of regulation on M&A and schemes of arrangement. Plus, understand how Australia can capitalise on its strong economic position, attract foreign investment and become more active in foreign markets.

Jeff Robson will be speaking as one of the expert panel members discussing how to improve Australia’s international opportunities.

Brochure
Power up your reports with Excel 2007
CPA Congress Masterclass Presented by Jeff Robson

Setting up or modifying reports in Excel can be time consuming. This workshop is designed to show you techniques that take the hassle out of report creation. Learn how to get around some of the most common issues in reporting. Correctly designed reports can speed up the reporting process, which means you have more time to analyse the results.

Key areas to be covered

Learn:

- Data handling techniques to make reporting straightforward
- How to use range names to make creating formula easy
- The best functions to simplify reporting
- Conditional formatting techniques to automate dashboard reports
- Easy ways to create ad-hoc reports with Pivot Tables

Who should attend

Any one who uses Excel in their course of work and needs to know how Excel 2007.

Brochure
Business Performance Reporting on a Shoestring
CPA Congress Session Presented by Jeff Robson

Many businesses want to start using business performance reporting to measure, optimise and improve their business areas but think they need to purchase expensive specialist software systems to do this.

They don’t realise that in many cases, they already have all (or at least most) of the software tools they need to create performance dashboards and KPIs then distribute these securely around the business!

This session will provide a non-technical overview of how to create dashboards and KPI’s using Excel, then manage these effectively in an organisation.

Learn:
  • How to connect to databases to extract the information you need
  • How you can use the features of Excel 2007 and 2010 to easily create effective business reporting
  • About SharePoint and its role in performance reporting


Brochure
Getting your bank to say “Yes”!
How to Raise Finance in Challenging Times

Now that the financial crisis has passed, it should be easier to get debt finance … right?

Unfortunately not! Many businesses are still finding it very difficult to raise much-needed finance and they’re not quite sure why.

This lunch will provide helpful advice on key areas such as:

- How to prepare yourself before you approach the bank
- What bankers look for and what they really want
- How to communicate your strategies so the bank understands
All these things will set you apart from other businesses and maximise your chances of getting your bank to say “Yes” to you!

Who Should Attend?
- Business Owners
- Directors
- CEO’s & CFO’s
- Managers
- Accountants & clients
- Advisers & clients
- Consultants & clients
- Bankers & clients


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