Microsoft Excel Introduction Course Outline
Course Aims
This one-day course is designed to let users get to grips with the main features of Excel and realize the advantages of using a powerful electronic spreadsheet. The course is entirely 'hands on', so those attending will get practice in creating and modifying actual spreadsheets.
Course Outline
MS Excel Introduction
What is a Spreadsheet?
Getting Started with Excel
Starting Excel; Excel Opening Screen
The Title Bar; The Menu Bar; Toolbars
Scroll Bars; Active Cell, Column and Row Headers
Sheet Tabs; The Status Bar; Menus and Submenus
SpeedKeys; Dialogue Boxes; Exiting Excel
Getting Assistance with Excel
Using the Office Assistant
Getting Help Without the Office Assistant
Manipulating the Help Window
Finding Out What is On the Screen
Workbooks and Worksheets
Creating and Opening Workbooks
Working with Workbooks
Working with Worksheets
Working with Cells
Navigating within a Worksheet
Navigating the Workbook
Spreadsheet Data
Entering Data
Using Timesaving Features
Checking the Spelling |
Formatting and Customising Data
Selecting Items in Excel
Formatting Text
Formatting Numbers
Manipulating Data
Formatting Columns and Rows
Formatting with Colours and Patterns
Adding and Editing Borders
Using Autoformat
Editing Spreadsheets
Cutting, Copying and Pasting
Inserting and Deleting
Using Find and Replace
Using Undo and Redo
Formulas and Functions
Entering Formulas
Entering Functions
Using Named Cells and Ranges in Formula
Printing Worksheets
Using Page Setup
Margins
Headers and Footers
Printing a SpreadsheetS |
Target Audience
New or intending users of MS Excel who want to gain a good understanding of how to use the software in a short space of time.
Assumed Knowledge
Working knowledge of using a PC, keyboard and mouse plus Windows is assumed, gained from the workplace or by prior attendance on a "Windows User Introduction" course.
Related Courses
Excel Intermediate and Advanced; Windows; other MS Office applications
|
