OUTCOMES

By the end of this training course, participants will:

• Start Microsoft Excel
• Identify Excel interface components
• Identify worksheet components
• Use Help
• Open, close and save workbooks
• Enter and edit text and values
• Use AutoFill to complete a series
• Enter formulas
• Insert, move and resize pictures
• Save a workbook as a PDF file
• Move and copy data and formulas
• Apply absolute references
• Insert and delete ranges

• Use SUM, AVERAGE, MIN, MAX, COUNT and COUNTA functions
• Use the AutoSum button
• Format text and numbers
• Apply conditional formatting
• Change page orientation
• Hide and unhide data
• Rename, insert, copy, move, and delete worksheets
• Insert and modify screenshots

Course Length:

1-day

OUTLINE

Microsoft Excel 2010 Introduction Training Outline

Download a Course Outline 

Foreword:

This Excel 2010 Introduction training course running in Sydney, Brisbane, Adelaide, Canberra, Melbourne and Perth, is rated 5.0/5.0 in overall quality by ProCert Labs, teaches the basic functions and features of Excel 2010. After an introduction to spreadsheet terminology and Excel's window components, participants will learn how to use the Help system and navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks in various formats.

Participants will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, and printing. Finally, participants will create and modify charts, and learn how to manage large workbooks.

This course will help participants prepare for the Microsoft Office Specialist core-level exam for Excel 2010 (exam 77-882) and the Microsoft Office Specialist Expert exam for Excel 2010 (exam 77-888). For comprehensive certification training, participants should complete the Introduction, Intermediate, and Advanced courses for Excel 2010.

• Introduction
• Personal learning goals of each participant
• Plan and structure for the day

• Text formatting
• Row and column formatting
• Number formatting
• Conditional formatting
• Additional formatting options

• Spreadsheet terminology
• The Excel environment
• Getting help
• Navigating a worksheet

• Preparing to print
• Page Setup options
• Printing worksheets

• Entering and editing text and values
• Entering and editing formulas
• Working with pictures
• Saving and updating workbooks

• Chart basics
• Formatting charts

• Moving and copying data
• Moving and copying formulas
• Absolute and relative references
• Inserting and deleting ranges, rows and columns

• Viewing large worksheets
• Printing large worksheets
• Working with multiple worksheets

• Entering functions
• AutoSum
• Other common functions

• Conditional formatting with graphics
• SmartArt graphics
• Screenshots

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 2010 Introduction 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