Overview

This course is designed for you to be more efficient at create budgets, forecasting, managing expenses, analysing data, pricing for tenders.

Do your Excel skills need improving to manage all of the above?  Are you self-taught or need a refresher? 

This workshop will hone your skills. The course starts with basic skills so that you can make the transition to the many advanced Excel functions to make Excel work for you. 

Learn how analysis your data with functions, filters, Pivot tables, charting, navigating large spread sheets, saving time and become a confident Excel user.

This hands-on workshop provides participants with:

• Moving beyond the ‘table with totals at the bottom’ spread sheet
• Learn new techniques to make your spread sheets more efficient
• This is an intermediate / advanced workshop for users who would like a new approach to spread sheet design
• Demonstrate techniques for automating processes
• Securing spread sheet applications
• Examines techniques for more efficient use of analysing data using PivotTables

The skills learnt on this workshop will:

• Save you time
• Save you frustration
• Enhance your use of Excel and improve the stability and validity of your spreadsheets
• Broaden your knowledge of Excel and many of its capabilities

Click here to register your interest for this course and we will contact you when we get a course running in your area.

We are now offering this course on line Zoom - click here to view details.

Length

1 day course.

Facilitator

Rodney Penney

Cost

$695 +GST per person 

(Minimum numbers apply before a course is confirmed)

NOTE: laptops will be provided for all participants to use

NOTE:  this is a classroom based training course.
However we do offer this on line. Click below for further information.

• Microsoft Excel - On Line Zoom

Topics include

• Navigation to speed up your work flow
• Selection techniques
• Mathematical Rules - Thinking it through!
• Conditional Functions to analyse your data
• Using text functions
• Splitting, combining text eg; first and last names
• Name Ranges
• Hiding columns, rows and formulas
• Protecting workbooks / work sheets
• Saving on time - using lookup tables / lists
• Automating entries
• Auditing formulas - how does the formula work
• Using multiple worksheets, applying formulas - 3D calculations
• Conditional formatting and data validation
• Sorting and Filtering data
• Subtotalling worksheets
• Manipulating data using PivotTables / PivotCharts, Slicers
• Automation - recording MACROS

On completion of this course participants will

• Navigate around workbooks/worksheets more efficiently
• Know the order of mathematical operations for Excel
• Understand Absolute and Relative Referencing - locking a cell
• Naming ranges and cells for better understanding
• Using the many Goto options
• Creating conditional IF function statements
• Combining and splitting text using functions
• Using array formulas
• Formula auditing to find #errors
• Figuring out how formulas work
• Protecting worksheets / workbooks/formulas from being changed
• Use Lookup tables for faster data entry
• Hiding Rows / Columns / Sheets
• Formatting to display conditional values
• Ensuring that the data entered is specific
• Using data lists to remove entry errors
• Creating multiple worksheets
• Using 3D calculations through multiple worksheets
• Consolidating worksheets / workbooks into one summary file / sheet
• Subtotalling areas of data in one worksheet
• Sorting and Filtering data
• Grouping / Outlining data across a spread sheet
• Using data tables
• Understanding PivotTables and PivotCharts
• Using Slicers
• Recording a macro to work more efficiently

Who should attend

Anyone who uses Excel frequently and would like to learn how to get the best from Excel using many tips and tricks. Find out the power of Excel. Guaranteed to improve your Excel skills and productivity.