MS Excel Level 1: Beginner

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