top of page

FOUNDATIONS

Level 1 Excel

EXCEL IN-A-DAY

Comdex Excel Training
Excel Skill Meter
Excel Skill Meter Needle
Excel Superhero

Master the world's most popular spreadsheet

About the course: Basic Level
About the course
Info
Information

Our popular 'Foundations' course is designed for users with little or no Excel experience.  Or perhaps you just need to improve on your patchy, self-taught skills.

This one-day instructor-led Excel course will give you a step-by-step introduction to the basic skills needed to use Excel effectively.

Learning Outcomes

  • We'll focus on teaching you all the fundamentals in a
    thorough and engaging manner.

  • You'll gain a solid understanding of how to create and work proficiently using Excel.

  • Throughout the course, we'll place a special emphasis on developing your skills in building accurate and well designed spreadsheets, while also teaching you sound principles of design and documentation.

You can build on this solid foundation course with our Intermediate and Advanced levels when it suits you.

Prerequisites: Basic Windows PC or Mac experience. 

Location

Price

 $335 incl GST

Excel Course Duration
Excel Small Class
Venue Transport

Duration

Method

Level

Transport

Car Parking

Download Button
Excel Watermark

One Day  9:30am - 5pm (approx.)

Classroom (Maximum 10, Avg 6)

Beginner

Tram, Train, Bus

Secure Commercial Off-street

Excel Training Manual Basic Level

Other EXCEL 'In-A-Day' Courses

What's included
Course Inclusions
Course Dates
Course Dates

Unsure if the 'Basic' level is suitable for you? 
Take our free online Excel quiz.

Excel Questions
Awesome Trainer Icon
Training Manual Icon
Guided Training Icon
Accredited Certificate Icon
Free Technical Support Icon

$

Resit Guarantee Icon
Hi-tech Icon
Refreshments Icon

One day's hands-on instructor led training

Printed step-by-step manuals & handouts

Small classes, personal attention

Accredited certificate: printed and electronic

Post course technical support i 

Full refund for cancellations i

Course resit guarantee i

Latest computer workstations (or BYO laptop)

All day refreshments and snacks

Excel Training Dates
Excel Level 1 training dates
  • Friday, 3 May 2024

  • Thursday, 16 May 2024 - Sold Out

  • Monday, 17 June 2024

  • Tuesday, 2 July 2024

Available Dates:

Excel Level 1 training dates

The demand for digital skills is growing exponentially .

Are you ready? Read our blog

Our Foundations course will help the novice user get up to speed with Excel fundamentals in just one day. By the end of the course, users will feel comfortable with: creating a new spreadsheet, working with formulas and functions, making their spreadsheet look professional and presentable, saving, printing and publishing a spreadsheet.

 All the essential Excel components you need to create beautiful spreadsheets

  • Formatting Text

  • Formatting Cells

  • Aligning Cell Content

  • Search For and Replace Data

  • Spell Check a Worksheet

  • Define Basic Page Layout for a Workbook

  • Refine Page Layout and Apply Print Options

  • Format Worksheet Tabs

  • New!  Powering Excel with ChatGPT

  • Getting to Know Excel

  • Creating Workbooks

  • Getting Help in Excel 365

  • A Closer Look at Excel's Formulas

  • Using Formulas and Functions

  • Working with Data

  • Working with Rows and Columns

  • Sorting and Filtering Data

  • Manage Worksheets

  • Managing Views of Worksheets & Workbooks

  • Customise General and Language Options

  • Customise Formula Options

  • Customise Proofing and Save Options

  • Customise Ribbon & Quick Access Toolbars

  • Understanding and Enabling Add-Ins

  • Customise Advanced & Trust Centre Options

Our skilled and experienced trainers will guide you through interactive, hands-on sessions.

Comdex Excel Trainer
Excel Training Dates

Course Objectives & Content

Excel Course Content
Excel Course Objectives
Excel Course Content

Unsure if the 'Basic' level is suitable for you?  Take our free online Excel quiz.

Excel questions

Other EXCEL 'In-A-Day' Courses

    FAST TRACK ONE DAY SHORT COURSE  |  SMALL CLASSES  |  AWESOME TRAINERS  |  SOUTH YARRA COMDEX TRAINING CENTRE   

Excel Course Registration

Prefer to call? 1300 977 773

We make Excel Super Heroes!

Excel Foundations

Comdex Excel Training
Excel Training
Comdex Excel Training Certified Microsoft Educator

Comdex is a Certified Microsoft Innovative Educator

Check out our Excel blog and news here

Getting Started

  Getting to Know Excel

  • Microsoft Excel 365, 2021, 2019, 2016

  • What are Spreadsheets, Worksheets,

and Workbooks?

  • What are Columns, Rows, Cells, & Ranges?

  • The Excel Interface

  • Navigating in Excel

  • Keyboard Navigation Options

  Creating Workbooks

  • The Ribbon

  • The Backstage View

  • Data Types

  • Excel 365 File Formats

  • The Save and Save As Commands

  • Saving to Microsoft OneDrive

  • Compatibility Mode

  • The Convert Option

  • The Compatibility Checker

  • Checking for Accessibility Issues

  Getting Help in Excel 365, 2021

  • Using the Microsoft Search Box

  • Accessing Advanced Help Options

Working with Data

  A Closer Look at Formulas

  • Excel Formulas

  • The Formula Bar

  • Elements of an Excel Formula

  • Mathematical Operators

  • The Order of Operations

  • Types of References

  Using Formulas and Functions

  • About Functions

  • Creating a Function with AutoComplete

  • Using the Insert Function Dialog Box

  • Using AutoSum

  • Viewing AutoSum Calcs in the Status Bar

  • Automatic Workbook Calculations

  Working with Data

  • Selecting Cells

  • The Cut, Copy, and Paste Commands

  • Using Paste Options

  • Live Preview

  • The Transpose Option

  • Moving Data with Drag and Drop

  • The Undo and Redo Commands

  • Using AutoFill

  • Using Flash Fill

  Working with Rows and Columns

  • Inserting Rows and Columns

  • Deleting Rows and Columns

  • Clearing Data from Cells

  • Changing Column Width and Row Height

  • The Hide and Unhide Options

  Sorting and Filtering Data

  • Sorting & Filtering Differences

  • Sorting Data

  • Enabling Filtering

  • Using the Filter Menu

  • Using Text Filters

  • Clearing a Filter

Modifying a Worksheet

  Formatting Text

  • What is a Font?

  • The Font Group

  • The Format Cells Dialog Box

  • The 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

  Manage Worksheets & WorkBook Views

  • The Freeze Options

  • The Split Command

  • The Switch Windows Command

  • The New Window Command

Customising the Excel Environment

  Customise General & Language Options

  • The Excel Options Dialog Box

  • The General Category

  • The Language Category

  Customise Formula Options

  • The Formulas Category


  Customise Proofing & Save Options

  • The Proofing Category

  • The Save Category

  • Version Control

  Customise Ribbon & Quick Access Toolbar

  • The Customise Ribbon Category

  • The Quick Access Toolbar Category

  Customise Proofing & Save Options

  • The Proofing Category

  • The Save Category

  • Version Control

  Understanding & Enabling Add-ins

  • What Are Add-ins?

  • The Add-Ins Category

  • The Developer Tab

  Customise Advanced & Trust Centre Options

  • The Advanced Category

  • The Trust Centre Category

Powering Excel with ChatGPT (AI)
 

  • ChatGPT Explained

  • Setup and Configuration

  • Using Excel with ChatGPT

  • Boosting Your Skills & Productivity

  • Automation & Time Saving Guide

New Ribbon

Aligning Cell Content

  • Alignment Options

  • The Indent Commands

  • The Wrap Text Command

  • Merge & Centre Options

  Search For and Replace Data

  • Cell Names and Range Names

  • The Find Command

  • The Replace Command

  • The Go To Command

  Spell Check a Worksheet

  • The Spelling Dialog Box

Printing Workbook Contents

  Define a Workbook's Basic Page Layout

  • Topic Objectives

  • Print Options in Backstage View

  • Page Setup Dialog Box

  • Print Preview Option & Workbook Views

  • Headers and Footers

  • Page Margins and Page Orientation

  Refine Page Layouts & Apply Print Options

  • Zoom Options

  • Page Breaks & Options

  • Print Area 

  • Print Titles

  • Scaling Options & Workbook View

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

Microsoft Excel Foundations : Course Content

Excel Training Manual

comdex

Comdex Logo

puter

com

dex

terity

Comdex Logo
Up arrow

Back to Top

Fast Track Your Knowledge with Our Beginner Excel Course

 

Most Microsoft Excel courses take two days or more to complete, but you can fast-track your knowledge with our one-day beginner Excel courses.

 

At Comdex, our Excel courses are compact, complete, and comprehensive. Our accredited trainers boast vast industry experience, ensuring you can hit the ground running. Comdex also offers small class sizes, free email support, free course re-sit options, and more. Your beginner Excel course comes with hard-copy training manuals, and these are yours to keep at the end of the day.

 

Whether you need basic Excel for your next job or you want to enhance your IT skills, the beginner Excel courses from Comdex are perfect for you.

 

Beginner Excel Courses at a Dedicated, High-Tech Computer Training Centre

 

The state-of-the-art Comdex Training Centre is located in South Yarra, on the fringe of the CBD. This combines the central location of Melbourne’s City with plenty of car parking and public transport options.

 

Our training centre is fully equipped with dual-screen PC and Mac computers, and you can also bring your own laptop to work on if you prefer.

 

Register for our beginner Excel courses today and take home an accredited certificate of completion and a range of practical skills in just one day! For more information, feel free to enquire with the Comdex team or take our Excel quiz to review your spreadsheet skills!

Ensure your success with our top-quality short courses at Comdex

At Comdex, we can offer fast-tracked courses to job seekers, students, or those already in the workforce. 
Whether you want to upskill or just enjoy learning something new, our trainers have a range of courses to suit your experience level.

Contact us

Reach out to our friendly team and we can point you in the right direction in terms of course times, and any questions you may have prior to commencement. If you want information about our facilities, trainers, or course materials, we can let you know what to expect.

Take our free Skills Test

Taking our skills test is a comprehensive way of understanding your level of knowledge, and experience, and what course will suit you. You may be more suited to a Basic level course instead of the Advanced if you don’t have prior experience. No matter the results, you’re always welcome!

Choose your training plan

Are you on the search for a specific short course? From Excel and Xero to MYOB, Power BI, and Calxa, we provide an extensive selection of courses to boost your technical proficiency – quick smart!


Moreover, we offer individual, one-to-one training solutions for those who prefer  specifically tailored course content. We also provide customised group training sessions, which can be conducted either at your workplace or at our dedicated computer training centre. 

Take the course

Once registered, you’re ready to take the course! Our dedicated computer training centre is located conveniently near train, tram and bus - virtually at our door, and there’s ample commercial undercover car parking available.

Step 5: Expert trainers

Our certified instructors boast a blend of extensive industry experience and in-depth product understanding, ensuring top-notch technical training at all times. We maintain a direct connection with the industry demands, frequently communicating and working together with software creators to guarantee that our content is always relevant, leading-edge, and of superior quality.

Contact us now at Comdex: Industry leaders in short course training


Step up your game with Comdex Training. Whether you're looking to sharpen your existing skills, aspire to a new job role, or bolster your employability for the future, we've got you covered. For those already active in the workforce, we provide comprehensive workplace training. Call 1300 977 773 to earn a new certification and enhance your professional portfolio."
 

Computer Desktop

puter

com

dex

terity

Microsoft MIE
Top of page arrow

Back to Top

bottom of page