Microsoft Excel: Introduction (Level 1)

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.

Duration: 1 Day
Who should attend? Any delegate wanting to obtain basic skills in using a spreadsheet, such as updating data, applying formatting, printing and making basic calculations.
Course Prerequisite: Microsoft Windows: Introduction

Course Outline

  • What is an Excel Spreadsheet?Start Excel
  • Minimize/Maximize/Restore/Close
  • The Excel Application Window
  • The Quick Access Toolbar
  • The Ribbon
  • Sheet Tabs
  • Backstage View
  • Shortcut Menus
  • Using Dialog Boxes
  • Using Help
  • Tiling Windows and Sheets
  • Create a New Spreadsheet
  • Types of Information
  • Enter Information
  • Delete Information
  • Undo & Redo Edits
  • Selecting cell(s), Column(s), Row(s)
  • Edit the Text in a Worksheet
  • Using Autofill to Copy or Fill a Series
  • Freezing Panes, Grouping Sheets
  • Insert/Delete/Rename Sheets
  • AutoCorrect
  • AutoComplete
  • Pick List, Find & Replace
  • Hide & Unhide Worksheets
  • Saving Workbooks
  • Recover Unsaved Files
  • Saving with File Properties
  • Password Protection
  • Closing Workbooks
  • Create a New Workbook
  • Understand Templates
  • Open an Existing Workbook
  • AutoSum – Total Rows & Columns
  • Create Simple Formulas
  • Basic Concepts on Formulas
  • Date/Time Function
  • Name Ranges
  • Cut/Copy/Paste
  • Paste Special
  • Move Data between Cells
  • Inserting/Deleting Rows & Columns
  • Formula Error Messages
  • Copy & Move Sheets
  • Format Data
  • Format Painter
  • Change Number Formats
  • Hiding Zeros
  • Formatting Cells (Front, Size, Colour)
  • Row Height/Column Width
  • Wrapping Text in a Cell
  • Shrink Text to fit in Cell
  • Merge Cells
  • Alignment
  • Merge & Center Text
  • Indent Cell Contents
  • Cell Background Colour
  • Borders
  • Spell Check
  • Preview a Worksheet, Adjust the Scaling of a Worksheet
  • Print Titles
  • Page Breaks
  • Headers & Footers
  • Print Worksheet Data
  • Print Gridlines
  • Exercise
  • Glossary
  • Comprehensive Manual
  • Lunch & Refreshments (not applicable to on-site training)
  • Electronic Certificate (on successful completion of the course)
  • Electronic Trainer Feedback Report
  • Electronic Delegate Feedback Questionnaire

Download Information

Click on the button to download

Course Schedule

View the available course dates

Contact Us

Contact Us now to find out more…