Skip to content
knowitinc Group Computer Training Courses
Share
Explore
Training Session Outlines

Microsoft Excel


Excel training courses designed to make spreadsheeting a breeze


Microsoft Excel – Level 1

This session will provide you with the essential skills to get started with Excel. You will learn to handle text and data entry, format, print and use entry level or basic formulas to perform calculations.


Recommended Duration

Approx. 1 Day (6 Hours)


Excel Level 1 Topics

Getting started with Excel
- Tour the screen
- Navigate in Excel
- Select Data
- Enter Data
- Working with Cells, Columns and Rows
- AutoFill
- Find and Replace
- Spell Check
- Save a Workbook
- Use Excel Help

Performing Calculations
- Create Basic Calculations and Formulas
- Understand BODMAS or PEDMAS
- Use Basic Functions
Sum Average Max Min Count
- Use AutoSum, AutoAverage, AutoMax, AutoMin
- Calculate with Functions
- Copy and Fill Formulas and Functions
- Create an Absolute Reference (F4)

Formatting a worksheet
- Change Font Size and Type
- Add Borders and Colour to Cells
- Change Column Width and Row Height
- Merge Cells together
- Apply Number Formats ($, %, Date, etc)

Developing a workbook
- Format Worksheet Tabs
- Reposition Worksheets in a Workbook
- Insert and Delete Worksheets
- Copy and Paste Worksheets
- Copy a Workbook

Printing workbook contents
- Select what you want to print
- File > Print
- Select your print options
(Print selection only?)
- Create a Headers and a Footers
- Set Page Margins
- Change Page Orientation
- Print

Customising layout
- Split a Worksheet
- Arrange Worksheets
- Freeze and Unfreeze Rows and Columns
- Hide and Unhide Worksheets

Extras:
Notes, Comments, Conditional Formatting, Intro to Charts (F11), Sparklines

Speak to us about customising this session for your team

Costs

Cost per trainer per day and half-day.

Excel Level 1 Costs
21
Delivery
Number of Attendees
Duration
Cost
1
CLASSROOM style (More intimate personalised training)
Up to 12 attendees
Half-day (3 hours)
$ 800
2
CLASSROOM style (More intimate personalised training)
Up to 12 attendees
Full-day (6 Hours)
$ 1,500
3
SEMINAR style (Less intimate, less personalised attention from the trainer)
13 to 20 attendees
Half-day (3 hours)
$ 1,100
4
SEMINAR style (Less intimate, less personalised attention from the trainer)
13 to 20 attendees
Full-day (6 Hours)
$ 2,000
5
LECTURE/ROADSHOW/DEMO style (additional $20.00 per attendee when over 100 attendees)
21 to 100 attendees
Half-day (3 hours)
$ 2,000
6
LECTURE/ROADSHOW/DEMO style (additional $20.00 per attendee when over 100 attendees)
21 to 100 attendees
Full-day (6 Hours)
$ 3,500
There are no rows in this table

* Costs shown exclude Travel and Accommodation costs for
On-Site At Your Plac
e sessions, exclude GST and are subject to change without notice – always be sure to check with us first.
Most of our trainers are ex Wellington in New Zealand to anywhere.
We also have POWER BI trainers ex Auckland and Wellington, New Zealand.
Travel and Accommodation costs would apply for
On-site At Your Place
sessions
outside of these areas.

Microsoft Excel – Level 2

In this course you will learn to sort and filter data, use calculations and formulas, create charts, and use and create templates.


Travel and Accommodation costs would apply for
On-site At Your Place
sessions
outside of these areas.


Recommended Duration

Approx. 1 Day (6 Hours)


Excel Level 2 Topics

Work with lists of data
This lesson shows the best-practice methods to create, manage and work with data contained within lists.
- Create Lists
- Sort Data in Lists
- Filter Data in Lists
- Add Data Validation Criteria
- Apply Conditional Formatting
- Create Sparklines
- Add Subtotals to Data in Lists

Understand how to perform calculations with more advanced formulas
This lesson helps you to create more advanced formulas and calculations with ease.
- Create and Apply a Name for a Range of Cells
- Calculate Across Worksheets
- Calculate with Logical Functions (IF Statements)
- Calculate with Financial Functions
- Calculate with Lookup Functions (VLookup , HLookup, XLookup)

Creating and modifying charts
This lesson covers the creation of charts or graphs from your spreadsheet data.
- Create a Chart
- Format Chart Items
- Change the Chart Type

Creating and using templates
This lesson covers the creation and use of your own Templates to speed the creation of spreadsheets that have a common structure.
- Create and use a Custom Template
- Add Comments into your spreadsheets
- Create Hyperlinks

Sharing and collaboration
This lesson demonstrates how to share spreadsheets and work together on spreadsheets stored in OneDrive or SharePoint at the same time.
- Sharing Spreadsheets
- Realtime Collaboration with others

Extras
- Goal Seek
- Hyperlinks
- Removing Duplicates
- Creating Custom Views

Speak to us about customising this session for your team

Costs

Cost per trainer per day and half-day.

Excel Level 2 Costs
21
Delivery
Number of Attendees
Duration
Cost
1
CLASSROOM style (More intimate personalised training)
Up to 12 attendees
Half-day (3 hours)
$ 800
2
CLASSROOM style (More intimate personalised training)
Up to 12 attendees
Full-day (6 Hours)
$ 1,500
3
SEMINAR style (Less intimate, less personalised attention from the trainer)
13 to 20 attendees
Half-day (3 hours)
$ 1,100
4
SEMINAR style (Less intimate, less personalised attention from the trainer)
13 to 20 attendees
Full-day (6 Hours)
$ 2,000
5
LECTURE/ROADSHOW/DEMO style (additional $20.00 per attendee when over 100 attendees)
21 to 100 attendees
Half-day (3 hours)
$ 2,000
6
LECTURE/ROADSHOW/DEMO style (additional $20.00 per attendee when over 100 attendees)
21 to 100 attendees
Full-day (6 Hours)
$ 3,500
There are no rows in this table

* Costs shown exclude Travel and Accommodation costs for
On-Site At Your Plac
e sessions, exclude GST and are subject to change without notice – always be sure to check with us first.
Most of our trainers are ex Wellington in New Zealand to anywhere.
We also have POWER BI trainers ex Auckland and Wellington, New Zealand.

Microsoft Excel – Level 3

In this course you learn how to: Audit and analyse formulas in a spreadsheet to better understand them. Protect and share Excel files so more than one person can work on them at the same time. Create PivotTables and PivotCharts to better analyse data contained in long lists. Share Excel data with other applications.

Recommended Duration

Approx. 1 Day (6 Hours)

Excel Level 3 Topics

Auditing worksheets
This lesson shows you quick ways to determine where your formulas derive their data from and what other formulas your figures might impact. Learn to use The Watch Window to track various formulas within your workbook as you change data.
- Trace Cell Precedents
- Trace Cell Dependents
- Locate Errors in Formulas
- Watch and Evaluate Formulas
- Group and Outline Data

Collaborating with others
This lesson covers how to protect access to your spreadsheets and data with passwords. Learn to share your
workbook so others can work on it at the same time.
- Protect Files, Worksheets and Workbooks
- Share and co-author a Workbook

Analysing Data
This lesson helps analyse your data using Excel's built in tools.
- Create Scenarios
- Use Goal Seek and The Solver
- Develop a PivotTable or PivotChart Report
- Install and use The Analysis ToolPak

Working with multiple workbooks
This lesson demonstrates ways to consolidate data across multiple workbooks and how to create and manage links across workbooks.
- Consolidate Data from multiple sources
- Link Cells in Different Workbooks
- Edit Links

Import and Export Excel options
This learn explains how to import and export Excel data to and from other programs and how to tweak Excel’s options.
- Export to Microsoft Word
- Import a Word Table
- Import Text Files
- Create Custom Toolbars and Buttons
- Update a Workbook's Properties
- Modify Excel's Default Settings

Extras
- Copy Data and Charts to Word or PowerPoint
- Link Data and Charts to Word and PowerPoint
- Create Workbook Templates


Speak to us about customising this session for your team

Costs

Cost per trainer per day and half-day.

Excel Level 3 Costs
21
Delivery
Number of Attendees
Duration
Cost
1
CLASSROOM style (More intimate personalised training)
Up to 12 attendees
Half-day (3 hours)
$ 800
2
CLASSROOM style (More intimate personalised training)
Up to 12 attendees
Full-day (6 Hours)
$ 1,500
3
SEMINAR style (Less intimate, less personalised attention from the trainer)
13 to 20 attendees
Half-day (3 hours)
$ 1,100
4
SEMINAR style (Less intimate, less personalised attention from the trainer)
13 to 20 attendees
Full-day (6 Hours)
$ 2,000
5
LECTURE/ROADSHOW/DEMO style (additional $20.00 per attendee when over 100 attendees)
21 to 100 attendees
Half-day (3 hours)
$ 2,000
6
LECTURE/ROADSHOW/DEMO style (additional $20.00 per attendee when over 100 attendees)
21 to 100 attendees
Full-day (6 Hours)
$ 3,500
There are no rows in this table

* Costs shown exclude Travel and Accommodation costs for
On-Site At Your Plac
e sessions, exclude GST and are subject to change without notice – always be sure to check with us first.
Most of our trainers are ex Wellington in New Zealand to anywhere.
We also have POWER BI trainers ex Auckland and Wellington, New Zealand.
Travel and Accommodation costs would apply for
On-site At Your Place
sessions
outside of these areas.







© 2021 - knowitinc Limited
New Zealand
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.