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$477
10 max
1 day
NZ$477
10 max
1 day
NZ$477
10 max
1 day
NZ$477
10 max
1 day

Auckland

Wellington

Christchurch

Remote NZ

Upcoming Courses:
Auckland

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

Wellington
Date
Course
City
Status
Mon 1 Jul 24
Mon
1
Jul
Excel Beginner (Lumify)
Wellington
Status: Scheduled
Scheduled
Mon 12 Aug 24
Mon
12
Aug
Excel Beginner (Lumify)
Wellington
Status: Scheduled
Scheduled
Mon 23 Sep 24
Mon
23
Sep
Excel Beginner (Lumify)
Wellington
Status: Scheduled
Scheduled
Mon 4 Nov 24
Mon
4
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 17 Jun 24
Mon
17
Jun
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$477
Duration
1 day
Times
9am - 4pm ( approx )
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$477
Duration
1 day
Times
9am - 4pm ( approx )
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$477
Duration
1 day
Times
9am - 4pm ( approx )
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$477
Duration
1 day
Times
9am - 4pm ( approx )
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

Other Courses
Microsoft Power BI Training Courses
Microsoft Office 365 Training Courses
Excel Specialist Training Courses
Microsoft Project Training Courses
R Programming Training Courses
Python Training Courses
SQL Training Courses
Power Apps Training Courses
SharePoint Training Courses
Power Automate Training Courses
Microsoft Teams Training Courses
Microsoft Visio Training Courses
Microsoft PowerPoint Training Courses
Microsoft Word Training Courses
Cloud Computing
Cybersecurity Training Courses
ChatGPT Training Courses
Microsoft Outlook
Adobe InDesign Courses
Adobe Photoshop Courses
Adobe Illustrator Courses
Adobe Premiere Pro Training
Adobe After Effects Training
Other Courses
Course Rating
Microsoft Excel Training Courses

4.72 5 Microsoft Excel Training Courses
4.72 out of 5
69118 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 69118 Reviews

Trusted by Business

Awards and Accreditations

Follow us