Excel Banner.jpg
Excel Superhero.png
Excel 3d Spreadsheet Reversed 1000.png

INTERMEDIATE

Level 2

Master the world's most popular spreadsheet.

Expand on your Excel knowledge and learn how to create more productive workbooks with more complex formulas and functions.

Learn how to apply a range of number formatting and conditional formatting techniques, advanced formatting, charting and data interrogation and reporting.

About the Course: Intermediate Level

9:30am to 4:30pm

Available dates

►​​  Monday 15 November 2021

►​​  Monday 22 November 2021

►​​  Monday 29 November 2021

Dates

Users who wish to extend their knowledge and skills beyond building simple workbooks, and learn how to create more productive workbooks.

It covers formulas and function techniques, advanced formatting and charting features and data manipulation tools like goal seeking

  • use a range powerful worksheet techniques 

  • use the fill operations available to fill a data series

  • apply a variety of page setup techniques

  • apply advanced formatting techniques

  • be introduced to building basic macros

  • create more complex formulas and functions

  • create and use defined names in a workbook

  • apply conditional formatting to ranges in a worksheet

  • use goal seeking to determine the values required to reach a desired result

  • learn data validation applications

  • create and work with tables and charts

In this 1 day course you'll
This course is ideal for

Comdex Training Centre

157A Commercial Road

South Yarra 3141

Tram, Train, Bus

Commercial Offstreet

One Day - 9:30am to 4:30pm

 

$375 (concession available)

9 months

30 days

Nil

Yes, please call (2 or more persons)

Excel In-A-Day Intermediate

Instructor led, face to face

Equivalent of our Level 1 course

10 students (average 6)

PC & Mac Dual Screen

Yes, accredited

Bound, hardcopy - yours to keep

Available on all workstations

 

Online or telephone 1300 977 773

Venue

Location

Public Transport

Car Parking

Duration

Cost

Resit Guarantee

Email Support

Cancellation Fee

Group Discount

Coarse Name

Delivery Mode

Pre-requisites

Maximum No.

Computers

Certificate

Training Manual

Internet

Info
Excel Logo white.png
Credentials EXCEL.png

Comdex is a Certified Microsoft Innovative Educator

Excel Trainer

Matt

Trainer Homepage Banner.png

Vanessa

All the key components to advance your Excel skills and productivity

  • Worksheet Techniques

  • Data Table Applications

  • Page Setup Best Practice

  • Formatting Designs

  • Essential Query Functions

  • Complex Formulas

  • Defining & Using Range Names

  • Advanced Formatting inc. Conditional

  • Chart Elements

  • Chart Object Formatting

  • Pivot Tables

  • Introduction to Macros

  • Realtime linking data eg. share prices

  • Audit Your Worksheet

  • Tracing using Precedents/Dependents

  • Fast Help Resources

  • Handling Mass Data

  • Tips and Tricks

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

Course Content
Excel Logo white.png
 
excel spreadsheet
Excel In-A-Day: Intermediate Course Registration
Excel Logo white.png

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

Julie

Teacher Excel

Other EXCEL 'In-A-Day' Courses

excel logo.png

comdex

Triangle_edited.png
Comdex Logo Small.png

puter

com

dex

terity

ApprehensiveHorribleHorsemouse-size_rest

Back to Top