Australia
Singapore
Hong Kong
Malaysia
Philippines
Thailand
Indonesia
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.
We currently have no public courses scheduled. Please contact us to register your interest.
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
Excel Beginner Course Details
Excel Beginner Course Details
Excel Beginner Course Details
Excel Course Outlines
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
phone
email
enquiry
