Learn basic Excel skills on our intensive one-day in-person course. 

Unlock the power of Excel spreadsheets to effectively analyse, share, and manage your day-to-day data with our comprehensive one-day Excel for beginners course. Gain practical skills and knowledge that can be applied in any professional setting to enhance your productivity and decision-making abilities. Our course covers the important basics from creating and formatting spreadsheets and charts to sorting and filtering data. 

Check out our complete Excel Beginner Course Outline below for more details. This course is specifically designed for individuals with little to no prior experience in Excel, providing a solid foundation for you to build upon. Once you're comfortable with the basics, you can explore our Intermediate and Advanced levels at your own pace

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

Private and Group Classes:
This course is available for individual enrolment and Private classes (min 10 students). Please contact Lumify to organise a quote.

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.

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

none