Microsoft Excel Basic to Intermediate
This course is ideal if you want to build on your basic Excel skills to get more out of the software. You’ll harness the power of Excel to double your productivity.

This workshop will help you become a confident Excel user. You'll learn:

• The essentials - you'll learn the foundations
• We’ll discuss the "When" and "Why" to use spreadsheets before we cover the "How".
• How to use easy formulas (such as add, subtract, multiply, divide and total numbers).
• Navigate through menus, ribbons (toolbars) and other screen components of Excel so that you feel comfortable finding the tools you need.

• Save time entering data.
• Automatically fill words in a series such as Jan, Feb, Mar . . . . Dec.
  Enter a sequence of numbers quickly such as 5, 10, 15 . . . . 100.
  Create your own custom fills such as Small, Medium, Large or Brisbane, Sydney, Melbourne.

• Impressive charts
• A picture may tell a thousand words, but a 3D chart says it all at a glance - we'll show you the easy way
• Take control of your pie charts and present them in ways that grab attention immediately.

• Professional presentation with a stroke of a brush
• Apply colours, borders and consistent fonts quickly using express tools such as the Format Painter and predefined Themes. (Trust us, this will save you HOURS.)
• You don’t have to be a graphic designer to make your spreadsheets look like they’ve been created by one.

• 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:

• open and navigate within multiple workbooks and multiple worksheets
• use the fill operations available to fill a data series
• understand, create and work with formulas and functions used to perform calculations
• understand and use formula cell referencing to create more complex formulas
• format rows and columns in a worksheet using new techniques
• understand and use the number formatting features in Excel
• use font formatting techniques to greatly enhance the look of a worksheet
• work with various elements of a worksheet
• apply a variety of page setup techniques
• sort data in a list in a worksheet
• create effective charts in Microsoft Excel

What you already need to know:
This course assumes you have basic or no skills in Excel. It would also 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 Basic to Intermediate course outline.

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

Course dates:
2009 Course COMPLETED
Monday 22 February 2010 AVAILABLE - Enrol Now!