Microsoft Excel - On Line Zoom
Online Registration
You can register for this course right now. Select which regional area and date you require.
Then click on "Register Now" to go through to the registration form.
Register now!
Overview
Delivered on line via group Zoom training session
2 x 3 hour sessions over two 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.
Back to top
Length
2 day course.
Back to top
Facilitator
Rodney Penney
Back to top
Cost
$395 per person + GST for two x3hr 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 two consecutive mornings.
Please refer to our terms and conditions and cancellation policy by by clicking here.
Back to top
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
Back to top
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
Back to top
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
Back to top
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
Back to top
TRAINING DATES
Training Course 28-29 October
-
Thursday 28 October: 9.00am - 12.00pm
-
Friday 29 October: 9.00am - 12.00pm
Participants must participate in both sessions to get the full benefit and to receive their certificate of participation.
Back to top