Excel Training - Beginner Course

Take your Excel skills to the next level with Lumify Work NZ

Learn how to analyse, share, and manage your day-to-day data using Excel spreadsheets.

Nexacu's team of experienced Microsoft Certified trainers teach you the basics of Excel, answering your questions along the way as you work through practical real-world exercises. Our Excel Beginner course, includes creating and formatting spreadsheets and charts, learning to sort and filter, and gaining an understanding of Excel’s advanced formulas and functions. View our full Excel Beginner Course Outline below. You can build on this course with the Intermediate, and Advanced levels when you feel ready to progress to the next level. 

 



Excel Training - Beginner Course

Learn how to analyse, share, and manage your day-to-day data using Excel spreadsheets on our one-day in-person course.

NZ$435
10 max
1 day
NZ$435
10 max
1 day
NZ$435
10 max
1 day
NZ$435
10 max
1 day

Auckland

Wellington

Christchurch

Remote NZ

Upcoming Courses:
Auckland
Date
Course
City
Status
Mon 21 Oct 24
Mon
21
Oct
Excel Beginner (Lumify)
Auckland
Status: Scheduled
Scheduled
Mon 4 Nov 24
Mon
4
Nov
Excel Beginner (Lumify)
Auckland
Status: Scheduled
Scheduled
Wed 27 Nov 24
Wed
27
Nov
Excel Beginner (Lumify)
Auckland
Status: Scheduled
Scheduled
Mon 16 Dec 24
Mon
16
Dec
Excel Beginner (Lumify)
Auckland
Status: Scheduled
Scheduled
Wellington
Date
Course
City
Status
Mon 21 Oct 24
Mon
21
Oct
Excel Beginner (Lumify)
Wellington
Status: Scheduled
Scheduled
Mon 4 Nov 24
Mon
4
Nov
Excel Beginner (Lumify)
Wellington
Status: Scheduled
Scheduled
Wed 27 Nov 24
Wed
27
Nov
Excel Beginner (Lumify)
Wellington
Status: Scheduled
Scheduled
Mon 16 Dec 24
Mon
16
Dec
Excel Beginner (Lumify)
Wellington
Status: Scheduled
Scheduled
Christchurch
Date
Course
City
Status
Mon 21 Oct 24
Mon
21
Oct
Excel Beginner (Lumify)
Christchurch
Status: Scheduled
Scheduled
Mon 4 Nov 24
Mon
4
Nov
Excel Beginner (Lumify)
Christchurch
Status: Scheduled
Scheduled
Wed 27 Nov 24
Wed
27
Nov
Excel Beginner (Lumify)
Christchurch
Status: Scheduled
Scheduled
Mon 16 Dec 24
Mon
16
Dec
Excel Beginner (Lumify)
Christchurch
Status: Scheduled
Scheduled
Remote NZ

We currently have no public courses scheduled. Please contact us to register your interest.

Scheduled
Taking enrollments.
Confirmed
Taking enrollments.
Few Seats left
Book Now.
Sold Out
Try another date.

Frequently Asked Questions

Are your courses suitable for an Excel beginner?

Yes, our Excel Beginner course is aimed at those with little or no experience in Excel. You will learn all key basic Excel skills and be ready to put them into practice in the workplace. We also offer Excel Intermediate, Advanced, Expert, and Specialist courses for those looking to take the next step.

Excel Beginner Course Details

Price
NZ$435
Duration
1 day
Times
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online
Address
Lumify Auckland
Ground Floor
338 Ponsonby Road Ponsonby
Auckland
microsoft_gold
deloite_logo

Excel Beginner Course Details

Price
NZ$435
Duration
1 day
Times
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online
Address
Lumify Wellington
Level 8
JacksonStone House 11 Hunter Street Wellington CBD
microsoft_gold
deloite_logo

Excel Beginner Course Details

Price
NZ$435
Duration
1 day
Times
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online
Address
Lumify Christchurch
13 Stanley Street Sydenham
Christchurch
microsoft_gold
deloite_logo

Excel Beginner Course Details

Price
NZ$435
Duration
1 day
Times
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online
Address
Remote Classes
Auckland CBD
Auckland 1010
microsoft_gold
deloite_logo

Excel Course Outlines

Course Rating
Microsoft Excel Training Courses

4.72 5 Microsoft Excel Training Courses
4.72 out of 5
74414 Student Reviews

Skills Test

Try our short skills test and find out

which course is right for you.

Nexacu Skills Test

 skills test

 

Contact Us


What do I need to know to attend?

There are no requirements for the Excel Beginner course. The course is suitable for people who have never worked with Excel or have just had very limited exposure to it. We will walk you through it, right from the start.

Excel Beginner Learning Outcomes

  • Create and work with a new workbook
  • Open and navigate within workbooks and worksheets
  • Understand and work with ranges in a worksheet
  • Understand, create, and work with formulas and functions
  • Use font formatting techniques
  • Format rows and columns in a worksheet
  • Use a range of techniques to work with worksheets
  • Sort data in a list in a worksheet
  • Create effective charts in Microsoft Excel
  • Apply a variety of page setup techniques
  • Print your workbook data

Excel Beginner Course Content

  • Getting to Know Excel
  • What are Spreadsheets, Worksheets and Workbooks?
  • What are Columns, Rows, Cells and Ranges?
  • The Excel Interface
  • Keyboard Navigation Options
  • Creating Workbooks
  • The Ribbon
  • The Backstage View
  • Data Types
  • Excel 365 File Formats
  • Save and Save As
  • Saving to Microsoft OneDrive
  • Compatibility Mode
  • The Convert Option
  • The Compatibility Checker
  • Checking for Accessibility Issues
  • Creating Workbooks
  • Getting Help in Excel 365
  • Using the Microsoft Search Box
  • Accessing Advanced Help Options
  • Using Formulas and Functions
  • About Functions
  • Creating a Function with AutoComplete
  • Using the Insert Function Dialog Box
  • Using AutoSum
  • Viewing AutoSum Calculations in the Status Bar
  • Automatic Workbook Calculations
  • Working with Data
  • Selecting Cells Cut, Copy and Paste
  • Paste Options
  • Live Preview
  • The Transpose Option
  • Moving Data with Drag and Drop
  • Undo and Redo
  • AutoFill
  • FlashFill
  • A Closer Look at Formulas
  • Excel Formulas
  • The Formula Bar
  • Elements of an Excel Formula
  • Mathematical Operators
  • The Order of Operations
  • Types of Reference
  • Working with Rows and Columns
  • Inserting Rows and Columns
  • Deleting Rows and Columns
  • Clearing Data from Cells
  • Changing Column Width and Row Height
  • Hide and Unhide
  • Sorting and Filtering Data
  • Sorting vs Filtering Data
  • Sorting Data
  • Enabling Filtering
  • Using the Filter Menu
  • Using Text Filters
  • Clearing a Filter
  • Formatting Text
  • Fonts
  • Format Cells Dialog Box
  • Format Painter
  • Live Preview and Formatting
  • The Mini Toolbar
  • Creating Links
  • Formatting Cells
  • Applying a Border
  • Applying a Fill
  • Changing the Number Format
  • Formatted Numbers and Cell Width
  • Customising Number Formats
  • Aligning Cell Content
  • Alignment Options
  • The Indent Commands
  • Wrap Text
  • Merge and Centre Options
  • Printing Workbook Contents
  • Define the Basic Page Layout for a Workbook
  • Print Options in Backstage View
  • The Page Setup Dialog Box
  • Print Preview
  • Workbook Views
  • Headers and Footers
  • Header and Footer Settings
  • Page Margins
  • Margins Tab Options
  • Page Orientation
  • Refine the Page Layout and Apply
  • Print Options
  • Zoom Options
  • Page Breaks
  • Page Break Options
  • The Print Area
  • Print Titles
  • Scaling Options
  • Managing Large Workbooks
  • Format Worksheet Tabs
  • Renaming Worksheet Tabs
  • Changing Tab Colour
  • Manage Worksheets
  • Grouped Worksheets
  • Repositioning Worksheets
  • Inserting or Deleting Worksheets
  • Hiding and Unhiding Worksheets
  • Worksheet References in Formulas
  • Customising the Excel Environment
  • Customise General and Language Options
  • The Excel Options Dialog Box
  • Customise Formula Options
  • Customise Proofing and Save Options
  • Version Control
  • Customise the Ribbon and Quick Access Toolbar
  • Understanding and Enabling Add-Ins
  • The Developer Tab
  • Customise Advanced and Trust Centre Options
  • Search For and Replace Data
  • Cell Names and Range Names
  • Find
  • Replace
  • Go To
  • Spell Check a Worksheet
  • The Spelling Dialog Box

Contact Us

Why Nexacu? 

Valued by Individuals

4.72 / 5
Over 74414 Reviews

Trusted by Business

Awards and Accreditations

Follow us