Home >
Microsoft Office >
MS Excel Level 1: Beginner
MS Excel Level 1: Beginner
| Course Code: |
OFFEX1 |
| Duration: |
1 day |
| Prerequisites: |
Familiarity with the Windows operating system.
|
| Objectives: |
Upon completion of this presentation, the participant should
be able to use Excel to organise, enter and format
data. Additionally, the participant should be able to create basic formulas
and use some of Excel's built-in functions.
|
| Core Topics: |
Excel Basics
- Worksheets and workbooks
- Menus & toolbars
- Save a workbook
- Moving around a workbook
- Keyboard shortcuts
- Adjust column width/row height
Working With Cells
- Select cells
- Edit, delete cell content
- Spelling check
- AutoCorrect, AutoComplete, AutoFill
- Undo, redo
- Cut, copy, paste
- Find and Replace
Formatting Data
- Character formatting
- Data Alignment
- Indents
- Merge cells
- Borders, patterns, colour
- Formatting numeric data
- AutoFormat
Introduction to Formulas & Functions
- Arithmetic operators
- Enter a formula
- What are functions?
- Autosum
- Using simple functions (Average, Min, Max)
Introduction to Charts
- Chart Wizard
- Formatting a chart
Page Setup & Printing
- Page setup
- Print Preview
- Printing options
|
