| Excel
Introduction
What is Microsoft Excel?
Starting Excel
The Excel Screen
Excel Menus
Excel Toolbars
Keyboard Shortcuts
Using Help
Workbooks and Worksheets
The Structure of Excel Files
Opening an Existing Workbook
Saving a Workbook
Starting a New Workbook
Navigating a Workbook
Managing Worksheets
Entering Information
Spreadsheet Information
Formatting Cells for Specific Contents
Entering Labels
Using Numbers as Labels
Using Spellcheck
Using AutoComplete
Entering Numbers
Using Currency
Accountancy
Date and Time
Using Percentages
Using Fractions
Selecting a Range
Using Autofill
Entering Formulas
Basic Formulas
Order of Operations (BODMAS)
Basic Mathematical Functions
Using SUM
Using AVERAGE
Using COUNT
Using MAX
Using MIN
Using AutoSum
Referencing Other Cells in Formulas |
Formatting
Workbooks
Editing Cell Contents
Selecting Cells
Copying Cells
Moving Cells
The Clipboard
Inserting and Deleting Cells, Rows and Columns
Using Undo and Redo
Using Find and Replace
Cell Comments
Formatting Cells
Formatting Values
Advanced Cell Formatting
AutoFormat
Using Format Painter
Row Height and Column Width
Charts
Chart Types
Creating a Chart
Formatting and Editing Chart Objects
Changing the Source Data of a Chart
Charging a Charts Type
Annotating Charts
Sorting data
Sorting Data
Multilevel Sorting
Filtering a List With AutoFilter
Printing a Worksheet
Using Print Preview
Printing a Large WorkSheet
Printing a Chart
Additional Print Options |
Course
Overview
Delegates will gain an introductory level of
understanding of the Microsoft Excel 2003 application.
|
Course Aims
Delegates will be able to identify the disadvantages
of paper spreadsheets and the advantages of electronic spreadsheets,
create a basic worksheet by entering text, values, and formulas,
create formulas by using Excel’s built-in functions, move
and copy data by using shortcut menus, drag-and-drop editing,
and toolbar buttons, change the appearance of worksheet data
by using a variety of formatting techniques, prepare a document
for printing by using the spell checking feature and a variety
of printing options, produce charts from the data. |
Course Pre-requisites
Delegates
should be comfortable working in a Windows environment. No prior
knowledge of Excel is assumed. |
Qualification
Map
None. |
|
|
NEOS
IT Training Limited
Suite 3, 3rd Floor, Marmion House
Copenhagen Street
Worcester
WR1 2HB
tel: 01905 726222
fax: 01905 613001
info@neos-it-training.com |
|
|