Microsoft Office

Microsoft Excel Basic – Training Course Information
Our Microsoft Excel 2016 Basic course is designed for new users of Microsoft Excel 2016, or those whom have been
self taught. The course will cover all aspects of creating spreadsheets, performing calculations, formatting and using page
setup for printing.
Course Objectives: After the course, you will be able to:
 Create and maintain spreadsheets
 Create and edit formulae
 Format and print worksheets
 Perform basic list management tasks
Course Prerequisite: You do not need any previous knowledge of Ms Excel, but should have basic windows, keyboard
and mouse skills.
Course Duration
This is a 1 day (7 hrs) Microsoft Excel Basic Course.
Course starts at 9:00 am and runs until 5:00 pm (7 hrs /lesson)
Training Course Contents
Excel Basics
 An overview of the screen, navigation and basic spreadsheet concepts
 Understand Excel terminology workbooks, worksheets, rows, columns, cells
 Various selection techniques
 Understanding the various mouse cursors
 Working with Ribbon Tabs, Groups and Dialog Boxes
 Standard and Contextual ribbons
 Use the task pane
 Understand and use the File Tab
 Saving, File types, File compatibility (earlier versions)
 Useful keyboard commands
 Quick Access Toolbar & Mini Toolbar
 Get Help!
Entering Data
 Various ways to Enter, Edit and Delete information (Text, Numbers, Dates)
 Use Auto List feature
 Date and Time are storage in Excel
 Enter Dates and Times
 Date/time formatting
 Methods to Move and Copy data
 Use the Fill Handle to copy data and create simple lists
 Create series of information
 Insert, Delete and Hiding Rows & Columns
 Insert, Delete and Move Cells
 Insert, Delete, Move and Copy Sheets
 Various navigation techniques
Creating & Editing Formula & Functions
 Define Formula
 Create & Edit Formula
 BODMAS : Mathematical Order
 Copy & Move Formula
 Use Basic Functions – Sum, Average, Max, Min, Count, Counta
 Use Autosum tool

M i c r o s o f t E x c e l – B a s i c Course Outline
Creatitude Training Centre
Formatting and Proofing
 Formatting of Cells with Number formats, Font formats, Alignment, Borders, Fill colours and Patterns
 Quick formats and themes
 Sheet tab formatting and Renaming
 Copy and Clear Formats
 Merging cells
 Spell Check, Find & Replace and AutoCorrect
Printing and Page Setup
 Page Orientation
 Add Headers and Footers
 Print a selection
 Set a print area
 Clear a print area
Multiple File & Large Workbook Tools
 Split screen tool
 Freeze panes
 Arrange workbook windows
 Zooming tools
 GoTo tool
 Name box navigation