OUTCOMES

By the end of this training course, participants will:

• Open and close Excel
• Differentiate between worksheets, workbooks, rows, columns and cells
• Enter labels and values
• Edit data
• Check spelling
• Open, close, and save workbooks (including publishing to PDF)
• Switch between Excel views
• Use Zoom
• Set up your page
• Preview and print your workbook
• Build and edit formulas

• Copy formulas
• Use absolute referencing appropriately
• Use basic Excel functions including SUM, AVERAGE, MAX, and MIN
• Use Selection Statistics
• Use AutoFill and AutoComplete
• Sort and filter data
• Format text and numbers
• Apply borders
• Use cell styles
• Change the workbook theme

Course Length:

1-day

OUTLINE

Microsoft Excel 2007 Essentials Training Outline

Download a Course Outline 

Foreword:

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 – and better information leads to better decision making!

• Workshop Objectives

• Opening Excel
• Understanding the Interface
• Understanding Worksheets
• Understanding Workbooks
• Closing Excel

• Entering Data
• Using the Wrap Command
• Editing Data
• Adding Rows and Columns
• Checking Your Spelling

• About the New File Format
• Saving Files
• Publishing Files to PDF
• Closing Files
• Opening Files

• An Overview of Excel’s Views
• Switching Views
• Using Zoom
• Switching Between Open Files

• An Overview of the Page Layout Tab
• Setting Up Your Page
• Using Print Preview
• Printing Data

• The Math Basics of Excel
• Building a Formula
• Editing a Formula
• Copying a Formula
• Relative vs. Absolute Referencing

• Formulas vs. Functions
• Understanding the Formulas Tab
• Using the SUM Function
• Using Other Basic Excel Functions
• Using the Status Bar to Perform Calculations

• Using AutoFill
• Using AutoComplete
• Sorting Data
• Filtering Data

• Changing the Appearance of Your Text
• Changing the Appearance of Numbers
• Setting Alignment Options
• Using Merge
• Removing Formatting

• Adding Borders
• Adding Fill Color
• Using Cell Styles
• Using Conditional Formatting
• Changing the Theme

• Words From the Wise
• Your Notebook

Public training courses in Brisbane now include: lunch, a games room, unlimited espresso coffee and WiFi.

'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

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...

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

Scheduled Excel 2007 Essentials Training Courses
Classes fill up fast - click a date to enrol now!

Questions?

Email: This e-mail address is being protected from spambots. You need JavaScript enabled to view it  or
Phone: 1300 121 400