


1300 977 773
9am to 9pm 7 days
EXCEL IN-A-DAY


Master the world's most popular spreadsheet.
ADVANCED
Level 3

Take your Excel skills to the elite level
Building on your solid excel experience, our Advanced Excel course will elevate your skill set to rarefied heights. Learn how to use Excel's high end productivity and critical decision tools. Create advanced formulas, import and export data. Create and use look-ups and queries, pivot tables, macros, charting, consolidations.
Prerequisites: Solid Excel skills to at least Level 2.
-
experienced Excel users who want to advance their skills to elite level
-
potential Power BI users who want a firm grounding in Excel's data mining and reporting features.
-
learn about Excel's powerful data aggregation, management and reporting tools
-
see how macros can automate tasks from mundane to complex
-
advance your financial modelling skills to elite level
-
start building powerful and interactive dashboards
Comdex Training Centre
157A Commercial Road
South Yarra 3141
Tram, Train, Bus
Commercial Offstreet
One Day - 9:30am to 5pm
$330 (concession available)
9 months
12 months
Nil
Yes, please call (2 or more persons)
Excel In-A-Day Advanced
Instructor led, face to face
Skills equivalent to Level 2
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

Fast track to Excel Elite Level
Face to face, instructor led
(illustrative)

Advance your Excel skills to elite level
-
modify Excel options
-
protect data in worksheets and workbooks
-
import data into Excel and export data from Excel
-
use data linking to create more efficient workbooks
-
group cells and use outlines to manipulate the worksheet
-
create summaries in your spreadsheets using subtotals
-
use the Data Consolidation feature to combine data from several workbooks into one
-
create, use and modify data tables
-
create and work with scenarios and the Scenario Manager
-
understand and create simple PivotTables
-
construct and operate PivotTables using some of the more advanced techniques
-
create and edit PivotCharts
-
use advanced filters to analyse data in a list
-
use a variety of data validation techniques
-
create and use a range of controls in a worksheet
-
share workbooks with other users
-
create recorded macros in Excel
-
Tips & Techniques
-
Help & Support Resources
Our skilled and experienced trainers will guide you through an interactive, hands-on session.

comdex training
Comdex is a Certified Microsoft Innovative Educator






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