Boost your Productivity with Microsoft Excel

This is the best teacher I have ever encountered in my entire working life and best session ever, learned a lot in a short timeframe (:

Thanking you

Staff Member at ‘Box Hill Institute’ who did the ‘Excel Essentials’ course


We deliver Microsoft Excel Training 
in Excel 2003, 2007, 2010, 2013


Beginners & Intermediate Course

Note – for a syllabus on Advanced topics, please contact us. We will customise the program to suit exactly what you need to use Excel for.

Practical strategies on how to use Microsoft Excel at an advanced level to save time and work more effectively.

The average person knows how to use about 10% of the software they work with – especially when it comes to Microsoft Excel.

‘Boost your Productivity with Excel’ is designed to show you how to use excel without losing time getting frustrated by what you don’t know.

As with all our workshops, you don’t have to be an I.T. guru to gain new skills in a short time frame. There won’t be heavy technical jargon. Rather it will be a hands-on workshop designed to give you skills in how to make Microsoft Excel work for you as a productivity tool.

Here is some of what you will learn:

Level 1 – Beginners

Spreadsheets

  • how they work and the best use of their functionality

A Simple Workbook

  • how to enter data, save a workbook and create an in put range

Selecting Ranges

  • how to select contiguous ranges
  • how to use special selection techniques to save time
  • how to select larger ranges and do range calculations

Formulas – how to make sense of them without getting confused

  • understanding formulas
  • the sum function
  • creating formulas that subtract, multiply and divide
  • how to do formula error checking to make sure you’ve got it right

Copying and Filling – use this tool to avoid time wasting double entries

  • tips and tricks to do quick copying, of one cell or multiple cells
  • how to copy relative formulas

Working with Functions

  • typing a sum function
  • how to calculate an average, and use the minimum and maximum function

Printing – how to scale it to fit, create page headers and print formulas

Charting – how to create, modify and print a chart (that includes a pie and bar chart)

Level 2 – Intermediate

Level 2 is the intermediate session that will have more advanced techniques in the following areas:

  • Working With Workbooks & Worksheets
  • Adjusting A Worksheet
  • Viewing Worksheets
  • Formatting Cells
  • Absolute Referencing
  • Filling Series
  • Labels And Names
  • Logical Functions
  • Lookup Functions
  • Sorting
  • AutoFilter

And a whole lot more.

This is a half day workshop designed specifically for you. Given it will be a small group we can easily adapt some of the content based on the questions that come through.

Six Months of “Post Workshop Support” – to help reinforce the learning

Each participant will receive email tips that help reinforce the information covered in the workshop. Any participant will have the option of contacting the facilitator for up to six months after the workshop to trouble shoot any challenges they’re having in implementing the course material.

 

Want to find out more?

To send an enquiry or find out more, simply email us

Or call now on 1300 316 310

Outline specifically the area you would like to focus on and we’ll contact you within 24 hours.