|
 Microsoft
Excel - Introduction
1
Day Course
On this
Microsoft Excel
Training Course
you will
learn the very basic skills needed to create and edit spreadsheets with
Microsoft Excel. You will learn to enter and edit data, create formulas,
format data, and create graphs (charts).
Who is this
Microsoft Excel Training Course for?
If you
are new to Excel or only to formalise the following basic skills: Entering
Date, Formatting Data, Basic Formulas, Creating Graphs.
Course
Prerequisites
You
should have basic knowledge of Microsoft Windows and be able to start an
application, get help, and open, close, and save files. |
|
Screen Familiarity
¨ Workbook
principles
¨ Screen
layout
Working with Cells
¨ Use
Undo and Redo
¨ Selecting
cells
¨ Go to a
specific cell
¨ Find &
Replace
¨ Cut, copy,
paste, and move cells
Autofill
¨ Copying
cells
¨ Work with
series (AutoFill)
Working
with
Data
¨ Enter text,
formulae, and numbers
¨ Edit cell
content
¨ Clear cell
content
Introduction Formulas and Functions
¨ Mathematical Operators (+. -, *, /)
¨ BODMAS
¨ Enter &
Revise formulas
¨ Use AutoSum
¨ Use basic
functions (AVERAGE, SUM, COUNT, MIN, and MAX)
¨ Use the
Paste Function
¨ Relative and Absolute cell referencing
|
Formatting
Worksheets
¨ Apply
font styles
¨ Apply
predefined number formats
¨ Modify row
and column size
¨ Modify
alignment of cell content
¨ Use the
Format Painter
¨ Apply cell
borders and shading
¨ Merge cells
¨ Wrap text
Inserting
& Deleting
¨ Insert and
delete rows and columns
Charting
¨ Types of
chart
¨ Column,
Line & Pie Charts
¨ Use the
Chart Wizard to create a chart
¨ Preview and
print charts
¨ Simple
Formatting
¨ Chart
Options
Printing
¨ Preview and
print a selection, worksheets, workbooks
¨ Change page
orientation and scaling
¨ Set page
margins and centering
¨ Insert and
remove a page break
¨ Set print,
and clear a print area
¨ Set up
headers and footers
¨ Set print
titles and options |
"The course was very easy to understand - even at my level"
|
