EXCEL IN-A-DAY

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

INTERMEDIATE

Level 2

Master the world's most popular spreadsheet.

Spreadsheet Wide Shadow 2.png

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 5pm

Available dates

►​​  New post-Covid dates coming soon!

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 5:00pm

 

$330 (concession available)

9 months

12 months

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

Course Name

Delivery Mode

Pre-requisites

Maximum No.

Our Computers

Certificate

Training Manual

Internet

Info
Excel Logo white.png
Credentials EXCEL.png

Comdex is a Certified Microsoft Innovative Educator

Excel Trainer
Trainer Homepage Banner.png

All the key components to advance your Excel skills and productivity

  • Creating Advanced Formulas

  • Using Range Names

  • Using Specialised Functions

  • Text Functions

  • Logical Functions

  • Lookup Functions

  • Date Functions

  • Financial Functions

  • Organising Sheet Data with Tables

  • Creating and Formatting Tables

  • Modifying Tables

  • Table Referencing

  • Visualising Data with Charts

  • Creating Charts

  • Modifying and Formatting Charts

  • Creating Trendlines

  • Creating Advanced Charts

  • Creating PivotTables

  • Analysing Data with PivotTables,

Slicers, and PivotCharts

  • Filtering Data Using Slicers

  • Analysing Data with PivotCharts

  • Working with Graphical Objects

  • Inserting & Modifying Graphic Objects

  • Layer and Group Graphical Objects

  • Incorporating SmartArt

  • Enhancing Workbooks

  • Customising Workbooks

  • Managing Themes

  • Workbook Security

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

Course Content
Excel Logo white.png
 
Spreadsheet Wide Shadow 2.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  

Teacher Excel

Other EXCEL 'In-A-Day' Courses

Mouse_Training-3 connectors Green.png
excel logo.png

comdex

Triangle_edited.png
Comdex Logo Small.png

puter

com

dex

terity

ApprehensiveHorribleHorsemouse-size_rest

Back to Top