ZSCV019 Microsoft Excel Fundamentals (Non-Award) - Version 2 - One-day intensive course overview

Sep 15, 2026

Uploaded by Levi

A one-day intensive, non-award Microsoft Excel fundamentals course for beginners and people refreshing skills for personal and professional use. Content covers spreadsheet navigation, data entry conventions for text, numbers and dates, basic arithmetic with operators and formula construction, and core functions including SUM, AVERAGE, COUNT, MAX and MIN. The course also covers cell formatting, saving and workbook management, and creating simple charts for bar, pie and line use cases, delivered through hands-on interactive exercises and real-world scenarios.

LanguageEnglish

CategoryExam

FormatPDF

Pages3

Reading Time8 min

AccessFree to download

Learning Outcomes

Knowledge

Skills

Delivery Details

Location and duration

Available dates

Proposed dates

ZSCV019 Microsoft Excel Fundamentals (Non-Award) DESCRIPTION This one-day intensive course equips participants with foundational Microsoft Excel skills for personal and professional use. Designed for beginners and those looking to refresh their skills, the course covers spreadsheet navigation, data entry, basic formulas and functions, cell formatting, and creating simple charts. Participants will gain hands-on experience through interactive exercises and real-world scenarios, ensuring they can confidently navigate Excel's interface and perform basic tasks efficiently. By the end of the course, learners will be equipped with foundational knowledge to leverage Excel for personal and professional use, streamlining data handling and enhancing productivity. Learning Outcomes: Knowledge • Excel interface components: ribbon, worksheet area, formula bar, cell references • Data types and data entry conventions (text, numbers, dates) • Basic arithmetic operators andformula construction(+,-,*,/) • Common functions: SUM, AVERAGE, COUNT, MAX, MIN • Cell formatting options: fonts, colours, borders, number formats • Chart types and their appropriate uses (bar, pie, line) • Workbook management: saving, naming conventions, file locations Skills • Navigate the Excel interface using mouse and keyboard shortcuts • Enter, edit, and delete data accurately in spreadsheet cells • Create and modify basic formulas for calculations • Apply commonfunctions (SUM, AVERAGE, COUNT, MAX, MIN) to data ranges • Format cells and worksheets for clarity and professional appearance • Create simple charts to visualise data • Save workbooks in appropriate formats and locations Page 1 of 3 ZSCV019 Microsoft Excel Fundamentals (Non-Award) 2026 – Version 2 CRICOS Provider No. 00300K (NT/VIC) | 03286A (NSW) | RTO Provider No. 0373 | ABN 54 093 513 649 DELIVERY DETAILS | Location | Casuarina, Alice Springs, Katherine and other NT locations | | --- | --- | | Duration | 1 day; 9:00 am-4:00 pm (including lunch break) | | Study mode | Face to face | | Available Dates | Casuarina Campus Friday, 17th April 2026 Friday, 22nd May 2026
Friday, 26 June 2026 Friday, 17 July 2026
Friday, 21 August 2026
Friday, 25 September 2026
Friday, 23 October 2026
Friday, 27 November 2026 | | Proposed Dates | This course can be scheduled by prior arrangement and content customised for Group bookings (minimum of 6 attendees) . For delivery in Alice Springs, Katherine and other NT locations, please reach out to our team at [tafe.ict@cdu.edu.au](tafe.ict@cdu.edu.au) . | ELIGIBILITY/ENTRY REQUIREMENTS Entry requirements for this short course include: • Basic computer literacy • Ability to operate a mouse and keyboard, open/close programs and manage files. No prior Excel experience required. FEES | Fee Type | 2026 Course Fees | | --- | --- | | Flat fee | $350.00 per participant | RESOURCES Participants are provided with a workbook and scenario templates ie budgets, rosters and contact lists. CONTACT DETAILS ICT, Cyber Security and Digital [E. ](E. tafe.ict@cdu.edu.au)[ tafe.ict@cdu.edu.au](E. tafe.ict@cdu.edu.au) [T. 08 8946 7517](T. 08 8946 7517)[ ](T. 08 8946 7517)Page 2 of 3 ZSCV019 Microsoft Excel Fundamentals (Non-Award) 2026 – Version 2 CRICOS Provider No. 00300K (NT/VIC) | 03286A (NSW) | RTO Provider No. 0373 | ABN 54 093 513 649 W. [https://www.cdu.edu.au/tafe](https://www.cdu.edu.au/tafe) For further information regarding student life at CDU, please refer to [https://www.cdu.edu.au/study/student](https://www.cdu.edu.au/study/student)life. Page 3 of 3 ZSCV019 Microsoft Excel Fundamentals (Non-Award) 2026 – Version 2 CRICOS Provider No. 00300K (NT/VIC) | 03286A (NSW) | RTO Provider No. 0373 | ABN 54 093 513 649

FAQs

Who is this course designed for, and what Excel experience is required?

The course is designed for beginners and participants looking to refresh their skills. Basic computer literacy is required, and no prior Excel experience is necessary.

What topics are covered in the Excel fundamentals course?

Participants learn Excel interface components, data entry conventions, basic arithmetic and formula construction, common functions (SUM, AVERAGE, COUNT, MAX, MIN), cell formatting, workbook management, and simple charts.

How is the course delivered and how long does it take?

Delivery is face-to-face for one day, running from 9:00 am to 4:00 pm including the lunch break, with interactive exercises and real-world scenarios.

Sep 15, 2026

Uploaded by Levi