1300 977 773
9am to 9pm 7 days
EXCEL IN-A-DAY
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.
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
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
Comdex is a Certified Microsoft Innovative Educator
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.
FAST TRACK ONE DAY SHORT COURSE | SMALL CLASSES | AWESOME TRAINERS | SOUTH YARRA COMDEX TRAINING CENTRE
Other EXCEL 'In-A-Day' Courses
comdex
puter
com
dex
terity
