Home » Microsoft Excel Beginner
Microsoft Excel for beginners
Length
1 Day
Price
$799
Cities
Melbourne, Sydney, Brisbane, Adelaide, Canberra, Perth
Learn More
Why Choose This Course
Microsoft Excel Beginner is a practical, hands‑on course for professionals who need to create clear, accurate spreadsheets and communicate data with confidence. You will learn the modern Excel interface, how workbooks and worksheets are structured, and the core skills that underpin everyday productivity: entering and formatting data, building reliable formulas, using essential functions, creating tables, sorting and filtering, and presenting information with charts. The focus is on the desktop application for Microsoft 365 and recent perpetual versions, so the skills translate directly to most workplace setups.
Excel is widely used across Melbourne’s public and private sectors for budgeting, reporting, analysis and operations. Employers value staff who can work efficiently with spreadsheets, avoid common errors, and produce outputs that are easy to read and share. This training helps you build a solid foundation, from understanding cell references and data types to applying number formats, managing page setup and printing, and using quick visualisations to explain trends. You will also learn how tables improve data integrity, why named ranges reduce mistakes, and how simple conditional formatting can highlight priorities.
The course content aligns to entry‑level skills assessed in the Microsoft Office Specialist: Excel Associate certification, including managing worksheets and workbooks, working with ranges and tables, using formulas and functions, and managing charts. For learners planning to pursue MOS certification, this course provides a strong start and a clear path to further preparation. For those focused on workplace outcomes, the practical exercises, tips and templates will help you streamline everyday tasks and communicate results clearly to stakeholders. A certificate of course attendance is included.
Prerequisites
- Candidates must have basic understanding of computer operating system
Exam
- There is no exam associated with this training course
Books
- Course material for Excel Beginners provided
Delivery
- Instructor-led Classroom Training at our premises
- Live Virtual Online Training attend in real-time from anywhere
- In-House Training at your premises (4+ participants)
Skills Gained
- Create, edit and save workbooks and spreadsheets
- Selecting workbook cell ranges
- Create formulas that perform calculations in the workbook
- Copy and fill data in the workbook
- Format cells in the workbook
- Print workbook data
- Create various charts and graphs in Excel.
Audience
- Suitable for beginners. Assumes little or no knowledge of Microsoft Excel
Price
| Days | Friday | Mon & Tue | Saturdays only |
| Time | 9:30 am to 5:00 pm | 6:00 pm to 9:00 pm | 10:00 am to 5:00 pm |
| Duration | 1 day | 1 week | 1 week |
| Price | $799 | $799 | $799 |
Outline
- Getting Started with Excel – Learn the interface, ribbon, backstage view, quick access toolbar, and status bar.
- Creating and Managing Workbooks – Open, save, close, and navigate workbooks using keyboard shortcuts and Go To.
- Entering and Editing Data – Type text, numbers, dates, and formulas; edit and clear cells; use undo and redo.
- Selecting and Organising Data – Select ranges, rows, columns, and apply special selection techniques.
- Copying and Moving Data – Use fill, copy between cells, ranges, worksheets, and workbooks; manage relative and absolute references.
- Formulas and Functions – Create basic formulas, use SUM, AVERAGE, MIN, MAX, and handle common errors.
- Formatting Cells and Text – Apply font styles, colours, alignment, number formats, and use the format painter.
- Working with Worksheets – Insert, delete, resize rows and columns, zoom, and manage multiple worksheets.
- Sorting and Filtering Data – Perform alphabetical and numerical sorts, apply filters, and create custom filters.
- Charts and Printing – Create and format charts, choose chart types, and print worksheets or charts effectively.
Terms & Conditions
The supply of this course/package/program is governed by our terms and conditions. Please read them carefully before enrolling, as enrolment is conditional on acceptance of these terms and conditions. Proposed course dates are given, course runs subject to availability and minimum registrations.
Frequently Asked Questions (FAQ's)
Do I need the desktop app or can I use Excel for the web?
I’m new to formulas. Is the pace suitable?
Will I learn how to print clean reports?
Our Partnership
Reliable certification testing is vital for validating professional skills in today’s tech-driven world. As a Pearson VUE Authorised Centre, we provide a secure environment for globally recognised IT exams. This partnership ensures convenient access to certifications with the highest standards of integrity and accuracy.
$74,000
Average annual salary for administrative and data-entry professionals in Australia who use Excel regularly (varies by role and experience).
81%
Employers prefer candidates with strong Excel skills for roles involving data management and reporting.
12%
Year-on-year growth in job opportunities requiring Excel proficiency across Australian industries.
$2.5B
Estimated size of the Australian business analytics and productivity software market, driven by Excel usage.
5,000+
Australian companies actively seeking professionals with Excel skills for roles in administration, finance, and data analysis.
96%
Student satisfaction rate reported by leading Australian Excel and productivity training programs.
Our Accreditations













