New Zealand Institute of Highway Technology - NZIHT

Overview

Delivered on line via group Zoom training session
3 x 2 hour sessions over three days. 

Is Excel frustrating you? Are you taking lots of time creating formulas?  

Can you quickly and easily create budgets, forecasts, expenses, analyses data, pricing for tenders?  Your Excel skills may need improving.  

This interactive online workshop will hone your skills. Move from the basics to the many advanced Excel functions, make Excel work for you.  Learn how analysis your data with functions, filters, Pivot tables, charting, navigating large spread sheets, save time and become a confident Excel user.    

The skills learnt will save you time, save you frustration, enhance your use of Excel and improve the stability and validity of your spreadsheets, and broaden your knowledge of Excel and many of its capabilities.

Examples of the outcomes:

• 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

Email lisa@nziht.co.nz to express your interest in future training dates.

Length

3 day course.

Facilitator

Rodney Penney

Cost

$295 per person + GST for all three 2hr sessions

Email lisa@nziht.co.nz to express your interest in future training dates.

COURSE STRUCTURE

This will be delivered live with our presenter over three consecutive mornings.

Each session will be two hours duration. 

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 is a basic user, or higher, of Excel 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 particularly if you are self –taught

PARTICIPANTS MUST HAVE:

Each person must have a computer or laptop with camera, Microsoft Excel and suitable internet connectivity to enable these zoom meetings.

Access to Microsoft Excel to work through the examples taught

TRAINING DATES

Training Course 28-30 September

• Monday 28 September - 9.30am - 11.30am
• Tuesday 29 September - 9.30am - 11.30am
• Wednesday 30 September - 9.30am - 11.30am

Participants must participate in all three sessions to get the full benefit and to receive their certificate of participation.

Email lisa@nziht.co.nz to express your interest in future training dates.