9am to 9pm 7 days
COMDEX TRAINING CENTRE
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.
Price
$
375 incl GST
Duration
Method
Level
Transport
Car Parking
One Day 9:30am - 5pm (approx.)
Classroom (Maximum 10, Avg 6)
Beginner
Tram, Train, Bus
Secure Commercial Off-street
Other EXCEL 'In-A-Day' Courses
Unsure if the 'Basic' level is suitable for you?
Take our free online Excel quiz.
$
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
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
-
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.
Course Objectives & Content
Unsure if the 'Basic' level is suitable for you? Take our free online Excel quiz.
Other EXCEL 'In-A-Day' Courses
FAST TRACK ONE DAY SHORT COURSE | SMALL CLASSES | AWESOME TRAINERS | SOUTH YARRA COMDEX TRAINING CENTRE
Prefer to call? 1300 977 773
We make Excel Super Heroes!
Excel Foundations
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
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
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."
comdex
puter
com
dex
terity
Back to Top