Click here to watch a quick video about PivotTables

This workshop will help you unlock what Excel can do. You'll learn:

• Combine many spreadsheets into one – including the totals (without any copying)
  Learn how to use the “consolidate” feature when you need to combine and total your data from multiple sheets into one; such as consolidating multiple store branches sales figures into one company report.
• Consolidate several sheets with the same layout or even consolidate different layouts into one.

• Easy ways to subtotal - at the click of a mouse (and without any formulas).
  Hate formulas? That's ok. You can generate subtotals for groups or categories of data in a list, without entering a single formula.
• Use Conditional Sum to subtotal figures but only to the satisfaction of your specific criteria.
• Automatically update totals when records are added or removed.

• Twist, Turn, Drag 'n' Drop to Summarise your spreadsheets.
  This is great if you want to see what happens in lots of different scenarios.
• "Massage" your data or charts easily by rotating rows, columns or axis so that you can present your statistics in different views.
• Pivot and Filter your sales statistics by product, sales person, average price or popularity – and change your mind to produce an alternate report quickly.
• Experience the flexibility of changing the source data and the chart labels.

• Help your readers with "at-a-glance" visual graphics
  Apply colour and visual effects such as green ticks for high values and red crosses for low.
• Visually represent values with new formatting techniques. With conditional formatting you can compare values at a glance to automatically change the cell or font colour, layer a shaded bar, or include an icon.

By the end of the course you will be able to:

• use a range of lookup and reference functions
• create and work with headers and footers
• filter data in a table
• use a range of techniques to enhance charts
• protect data in worksheets and workbooks
• use the Data Consolidation feature to combine data from several workbooks into one
• use data linking to create more efficient workbooks
• understand and create PivotTables so you can manipulate data for multiple scenarios
• use goal seeking to determine the values required to reach a desired result
• use Solver to solve more complex and intricate problems
• create recorded macros in Excel

What you'll experience:
We work out what you need to know to make your job easier - and we
make sure we help you find the solution. Unlike other courses, we don't
just churn through a manual. We want to ensure that ALL your specific
Excel queries are answered. All you have to do is ask because we're
committed to your learning.

Sort lengthy and complex data into easy-to-understand
reports and graphs with Pivot Tables
You might have a lot of data in many different categories. Using Pivot Tables,
you can sort and chart data easily. Whether you want a "helicopter" overview
or to drill down into a specific category, you can extract exactly what you need.
You can even get Excel to lead you step-by-step through this process. Best of
all, you can then turn your chosen data into an simple graph, which is great for
presentations or for analysing trends.

What you already need to know:
This course assumes you have a general understanding of the software and experience in creating basic Excel workbooks. You should be able to copy within Excel, create charts, and create basic formulas. It would be beneficial to have a general understanding of personal computers and the Windows operating system environment.

Your presenter
Paul Neale is an engaging presenter who has spent his career mastering technology, productivity and learning. Apart from being an expert in all Microsoft Office applications from basic to advanced levels, he is also an experienced project management and team leader. Paul has presented numerous courses at the University of Sydney's Centre for Continuing Education and is in-demand as a corporate trainer and consultant.

Paul has also run a number of IT-related businesses, has trained in various adult education institutions and consulted to a wide range of small and large organisations including Michael Page International and Babcock & Brown.

Find out what past students say about Paul’s courses here.

This course is held at our IDEAS LAB, our professional harbourside training rooms in Milsons Point in Sydney. Email us if you would like to receive a comprehensive Excel Intermediate to Advanced course outline.

Course dates and fees
Microsoft Excel - Intermediate to Advanced
9.00am - 5.00pm
Course fee: $260 (includes GST)
You will receive a comprehensive take-home manual which is a handy reference for the future.

Course dates:
2009 Courses COMPLETED
Tuesday 23 February 2010 AVAILABLE - Enrol Now!