Microsoft Excel: Introduction

Course details

This one-day course is designed to help a delegate to obtain the basic skills required to create and use a spreadsheet using Microsoft Excel. A delegate will learn to enter and edit data, create formulas and format elements of a worksheet.

Course Outline

Module 1

• What is a Microsoft Excel Spreadsheet?
• Start & Quit Microsoft Excel
• Minimize/Maximize/Restore/Close
• The Excel Application Window
• Sheet Tabs
• Shortcut Menus, Toolbars, Menus
• Using Dialog Boxes
• Using Toolbars
• Office Assistant
• Using Help
• Manipulating Windows

Module 2

• Create a New Spreadsheet
• Types of Information
• Entering Information
• Deleting Information
• Undo & Redo Edits
• Selecting Cell(s)/Column(s)/Row(s)
• Edit the Title of a Worksheet (Text)
• Use AutoFill to Copy a Series
• Freezing Panes
• Grouping Sheets
• Insert/Delete/Rename Sheets
• AutoCorrect
• AutoComplete & Pick List
• Finding & Replacing
• Hiding & Un-hiding Worksheets

Module 3

• Saving Workbooks
• Saving with File Properties
• Password Protection
• Closing Workbooks
• Open a New Workbook
• Understand Templates
• Open an Existing Workbook

Module 4

• AutoSum - Total Rows & Columns
• Create Simple Formulas
• Basic Concepts on Formulas
• Date / Time Formula
• Create Formulas — Function Wizard
• Name Ranges
• Cut / Copy / Paste
• Paste Special
• Move Data between Cells
• Inserting / Deleting Rows & Columns
• Relative & Absolute References
• Formula Error Messages

Module 5

• Copy & Move Sheets
• Format Data — AutoFormat
• Format Painter
• Change Number Formats
• Hiding Zeros
• Formatting Cells (Font, Size, Colour)
• Row Height / Column Width
• Wrapping Text in a Cell
• Shrink Text to fit in a Cell
• Merge Cells
• Alignment
• Merge & Center Text
• Indent Cell Contents
• Cell Background Colour
• Borders

Module 6

• Check Spelling
• Preview Worksheet
• Page Set-up
• Print Titles
• Page Breaks
• Headers & Footers
• Print Worksheet Data
• Print Gridlines
• Exercise
• Glossary