Download a Course Outline 
|
Excel 2007 Advanced Training Course
Excel is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Excel 2007, you can manage more data than ever, with increased worksheet and workbook sizes. Excel also makes your job easier by providing an easy to use interface and an array of powerful tools to help you turn your data into usable information – we’ll show you how.
|
|
OUTCOMES
By the end of this training course, participants will:
- Use SmartArt
- Insert Objects
- Create Charts
- Create Pivot Tables
- Work with Pivot Tables
- Create Pivot Charts
- Solve Formula Errors
- Use What-If Analysis
- Manage Your Data
- Group and Outline Data
|
Course Length:
1-day
|
Why our clients choose us:
- Receive practical tools to take away with you.
- Be involved all day. There are about 20 activities each day (10 lessons with 1-3 activities per lesson).
- Realistic and relevant. We take the time to learn about you, then tailor the training to your needs.
Looking for death by Powerpoint? You will need to call another training company!
|
|
View the scheduled classes tab for a class near you or
Call now to discuss a cost-effective, tailored class at your workplace.
1300 121 400
|
|
|
OUTLINE
Microsoft Excel 2007 Advanced Training Outline
Download a Course Outline
Foreword:
Knowing how to use the advanced features of Microsoft Excel 2007 leads to a completely new experience in using this spreadsheet program. The novice user tends to use Excel 2007 as a holding place for report data. They may know how to insert data and move columns around, but rarely go into the deeper functions that Excel 2007 offers.
This workshop will teach you the most common advanced features of Microsoft Excel 2007.
The goal of this course is to get you familiar with these functions in a safe learning environment. Once you complete the course, your familiarity and confidence in using the advanced feature of Excel 2007 will increase, making Excel 2007 a more useful tool for you at work or at home.
|
Excel 2007 Advanced Training Course - Lesson 1
Getting Started
|
Excel 2007 Advanced Training Course - Lesson 2
SmartArt
- Inserting SmartArt
- An Overview of the SmartArt Tabs
- Adding Text to the Diagram
- Resizing and Moving the Diagram
- Resetting the Diagram
|
Excel 2007 Advanced Training Course - Lesson 3
Inserting Objects
- About Contextual Tabs
- Adding Pictures from Your Computer
- Adding ClipArt
- Adding Text Boxes
- Drawing Shapes
|
Excel 2007 Advanced Training Course - Lesson 4
Creating Charts
- Inserting a Chart
- Overview of the Chart Tools Tabs
- Understanding the Parts of a Chart
- Changing the Chart Style
- Resizing and Moving the Chart
|
Excel 2007 Advanced Training Course - Lesson 5
Creating Pivot Tables
- Inserting a Pivot Table
- Overview of the Pivot Table Tools Tab
- Choosing Fields
|
Excel 2007 Advanced Training Course - Lesson 6
Working with Pivot Tables
- Changing the Data Displayed
- Applying a Style to Your Pivot Table
- Some Real-life Examples
|
Excel 2007 Advanced Training Course - Lesson 7
Creating Pivot Charts
- Creating a Pivot Chart from a Pivot Table
- Creating a Pivot Chart from Data
|
Excel 2007 Advanced Training Course - Lesson 8
Solving Formula Errors
- Using Named Ranges
- Understanding Formula Errors
- Tracing Dependents and Precedents
- Using the Trace Errors Commands
- Evaluating Formulas
|
Excel 2007 Advanced Training Course - Lesson 9
Using What-If Analysis
- Using Goal Seek
- Using the Scenario Manager
- Using a One Input Data Table
- Using a Two Input Data Table
|
Excel 2007 Advanced Training Course - Lesson 10
Managing Your Data
- Transposing Data from Rows to Columns
- Using the Text to Columns Feature
- Checking for Duplicates
- Creating Data Validation Rules
- Consolidating Data
|
Excel 2007 Advanced Training Course - Lesson 11
Grouping and Outlining Data
- Grouping Data
- Adding Subtotals
- Outlining Data
- Viewing Grouped and Outlined Data
|
Excel 2007 Advanced Training Course - Lesson 12
Wrapping Up
|
|
Public training courses in Brisbane now include: lunch, a games room, unlimited espresso coffee and WiFi.
|
| IN-HOUSE TRAINING |
|
|
'your place or ours'
In-House training benefits:
- tailored to your needs and goals
- cost effective - from $140 per person (full day)
- you choose the day, place and time
- greatest impact in the shortest time
- tailoring ensures practical tools directly applicable to your workplace
- great team building opportunity
- more convenient, people don't need to go off-site
You'll be surprised at the price - check now! |
Ph: 1300 121 400
|
Tailored Delivery - standard
We will always tailor the delivery of your In-House Training course to ensure it is relevant to your team, and targeted at your learning goals. We can incorporate your company's examples and terminology to ensure you the training can be directly related back to your workplace. This is standard, and included in the price.
Your delivery options
We offer a range of different class types to suit your operational needs.
|
|
|
The "1-hour Motivator" training sessions
These 60-90 minute sessions are highly motivating and thought provoking - ideal for those people who need to fit training in around a busy work schedule - great as an early morning kick-start or lunch time boost! Read more...
|
 |
The "3-hour Power" sessions
3-hour power sessions – are a great solution when you have very specific outcomes you are targeting, or scheduling the team to be off the job for a whole day is proving to be a challenge Read more...
|
 |
Full-day short courses
1-2 day short courses delivered with a unique focus on 80% activities 20% content – just the way learning should be!
Read more...
|
 |
Conferences and workshops
Do you want your conference to be memorable, fun, interactive and have a real highlight? pdtraining's dynamic trainers can add that flair, excitement and much much more!
Read more...
|
|
1. We really listen
We take the time to understand your needs and goals
|
2. Flexible delivery
We always tailor the course to suit your needs
|
3. The best trainers
We only provide the best trainers and the best courseware
|
|
Most importantly the participants 'love' pdtraining courses because our courses are:
- Practical - 20% theory:80% practical - everyone will be constantly involved and engaged.
- Very interactive - our trainers facilitate people sharing and learning from each other's experience
- Applicable on the job - we are all about skills and techniques you can actually use!
- Fun - we help people enjoy learning because courses should be fun! Also people are more likely to implement what they learn if they enjoyed the learning experience.
- Delivered by a fantastic trainer - we only use the best, engaging expert trainers
We believe you learn more when you're having fun!
|
Q: Who else uses Professional Development Training?
A: Take a look at some of our recent clients
Q: Are they Happy?
A: This is what they say about us testimonials
 Questions?
Email:
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
or
Phone: 1300 121 400
|
 |
The top 5 reasons participants 'love' pdtraining
- 20% theory:80% practical - everyone will be constantly involved and engaged.
- Lots of collaboration - our trainers facilitate people sharing and learning from each other's experience
- Applicable on the job - we are all about skills and techniques you can actually use!
- Fun - we help people enjoy learning because courses should be fun! Also people are more likely to implement what they learn if they enjoyed the learning experience.
- Delivered by a fantastic trainer - we only use the best, engaging expert trainers
Yes! this is the right choice for me! 
|
Don't take our word for it: testimonials
Cost:
$413 inc gst per person
Length
1 - day high-energy class
Course venues:
Sydney
Level 1
111 Harrington Street
Sydney
NSW 2000
View Map
|
Melbourne
123 Queen Street
Melbourne
VIC 3000
View Map
|
Brisbane
Unit 11
121 Newmarket Road
Windsor Brisbane
QLD 4030
View Map
|
Adelaide
International Visualisation Centre
19 Young Street
Adelaide
SA 5000
View Map
|
Perth
Perron House
61 Kitchener Avenue
Victoria Park Perth
WA 6000
View Map
|
Canberra
Manuka Oval
Manuka Circle
Canberra
ACT 2603
View Map
|
 Times
Public classes start at 9.00am and finish around 4.30pm.
Class Size
Public classes will be a small relaxed group of between 4 and 12 people.
The small group helps ensure that everyone will gets a chance to ask questions and learn at their own pace.
What is provided?
All participants will be provided with morning tea, afternoon tea, printed bound courseware to keep and an Excel 2007 Advanced Certificate of Completion. Public training courses in Brisbane now include: lunch, a games room, unlimited espresso coffee and WiFi.
|
|
Excel 2007 Advanced Training Courses are delivered by pdtraining's Excel 2007 Advanced Training specialists and counsellors in Brisbane, Sydney, Canberra, Melbourne, Adelaide, Perth and Australia wide.
|
|
