Course Details

Manukau Institute of Technology

Faculty of Business and Information Technology Reception, Floor 2 Corner of Manukau Station Road and Davies Avenue, Manukau

Half Day
9.00am to 12.30pm

Who should attend?

Attendees must have a basic computing knowledge in the Windows environment along with mouse skills before attending Microsoft Excel 2010.

Manuals are included in the course fee

Core Content

Worksheet Basics

* The Excel 2010 screen
* What is the Ribbon?
* Quick Access Toolbar
* Moving Within a Worksheet
* Selecting Within a Worksheet

Entering & Accepting Information Entered into a Cell

* To Enter Data into the Worksheet
* Enter Data into a Range of Cells
* Editing Data

Saving Your Spreadsheet

Backstage View

Open & Close Files

Moving & Copying

* Cut, Copy & Paste
* Drag & Drop - moving using the mouse

Inserting Rows & Columns

Column Widths & Row Heights

Autofill

Formulas & Functions

* Formulas
* Functions
* AutoComplete
* AutoCalculate

Formatting Your Worksheet

* Formatting Text & Values
* Alignment Group
* Number Group
* Format Painter

Preparing the Worksheet for Printing

Preparing the Worksheet to Share with Others

* Emailing Your Worksheet to Others

There are several different ways to email your Worksheet:

* Saving your Worksheet as a PDF or XPS
* Save to Web (eg using Windows Live SkyDrive)
* Save a document to Sharepoint from Office 2010

Comments

Getting Help from Excel

Annamarieke Ymker