Excel 2007: Basic
Description
This course will give you the skills to create, edit, format, and print basic worksheets and charts in Excel. You will create basic worksheets and charts.
This course is designed for persons desiring to prepare to be a certified Microsoft Office User Specialist (MOUS) in Excel, and who already have knowledge of Microsoft Windows 98 or above operating system, and desire to gain the skills necessary to create, edit, format, and print basic worksheets and charts in Excel.
Entrance Requirements
Participants should have the ability to navigate the desktop and work with multiple windows, participants should also have an understanding of the computer file storage and a basic awareness of the keyboard (eg. the purpose of the [spacebar] or the [shift] key).
Who Should Attend
This course is for those who want to cover the basics to enable you to use MS Excel efficiently.
Course Outline
Getting started
- Spreadsheet terminology
- Exploring the Excel window
- Getting help
- Opening and navigating workbooks
- Closing workbooks
Entering and editing data
- Creating workbooks
- Entering and editing labels and values
- Entering and editing formulas
- Saving and updating workbooks
Modifying a worksheet
- Moving and copying data
- Moving and copying formulas
- Using absolute references
- Inserting and deleting ranges
Using functions
- Entering functions
- Using AutoSum
- Using AVERAGE, MIN, and MAX
Formatting worksheets
- Formatting text
- Formatting rows and columns
- Number formatting
- Using Format Painter and AutoFormat
Printing
- Preparing to print
- Page Setup options
- Printing worksheets
Creating charts
- Chart basics
- Modifying charts
- Printing charts
Web features
- Saving workbooks as Web pages
- Hyperlinks
- Sending workbooks via e-mail
Learning Materials
All standard learning materials are included in the course fee.
Links and Further Information
Duration and Times
We run this course as both full time (1 day) and part time (2 evenings) course. Contact us for current starting dates and times.