Display & Accessibility Options
Excel 2010 Introduction
Microsoft Office 2010
 Next available Norwich date: 06 March 2012   |
Course Aims:
This course is designed to give an introduction to the essential aspects of this powerful integrated spreadsheet product from Microsoft. It is entirely 'hands on' and those attending will gain a good basic understanding of spreadsheet production including formatting, editing and printing.
Assumed Knowledge:
A basic understanding of PCs, use of a keyboard and mouse plus knowledge of Microsoft Windows is required, gained either by previous experience or by attending a Jarrold Training "PCs, Windows and Internet Introduction" course.
Version:
Microsoft Office 2010
What people say:
A fantastic course, well delivered, suited to a pace of the group. Indivual support as necessary. 'Human' teacher with excellant subject knowledge.
Elizabeth FitzRoy Support - Feb 2012
Special Offer
Book one person onto any two levels of Excel training and receive £30 off the total price.
Profile Outline:
Introduction to Microsoft Excel
- What is a spreadsheet?
Getting Started
- Starting Excel
- The Excel screen and The Ribbon
- Quick Access Toolbar and shortcut keys
- Formula bar and name box
- Sheet tabs and the status bar
- Active cell, column and row headers
- Moving around the spreadsheet
- Exiting Excel
Spreadsheet Basics
- Creating a new workbook
- Data types
- Entering and editing data
- Entering dates and times
- Deleting data
- Undo
- Selection techniques
- Saving and closing a workbook
- Opening a workbook
- File Formats and Working in Compatibility mode
Cut, Copy and Paste
- The clipboard
- Using cut, copy and paste
- Drag and drop
- AutoFill
- Custom lists and Excel Options
Entering Basic Calculations
- Entering calculations
- AutoSum
- Auto Complete
- Statistical functions
Formatting the Worksheet
- Home and Page Layout Tab
- Working with columns and rows
- Number formats
- Date and time formats
- Alignment and orientation
- Borders and patterns
- Cell Styles
- Format painter
Printing
- Print preview
- Page Layout View
- Page setup
- Page breaks
- Print titles
- Headers and footers
- Printing
Working with Larger Spreadsheets
- Splitting the screen
- Freezing panes
Introduction to Charting
- Creating a chart
- Printing a chart
DO NOT DELETE THIS TEXT
Profile Details:
-
Price: £155.00 
Duration: 1 day
Print Page
Norwich Dates:
-
06 March 2012
-
12 March 2012
-
03 April 2012
Links:
People who attended this course, also booked:
Information & print:
