Course code: 2E2-ExcelF - call 0845 071 2801
Overview
Course duration: 1 day.
By the end of this course you will be able to produce a formatted worksheet, confidently create basic dynamic formulae and create a visual representation of the data, using the provided manual if required.
This course can be run in versions 2000 / 2002 / 2003 and 2007.
This course is delivered in partnership with 2e2 Training.
Pre-course Activity
This course requires that you have a good working knowledge of Microsoft Windows and you should also be able to use a mouse and keyboard.
What will it cover?
Excel Basics
- 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
Printing
- Preparing To Print
- Page Set Up Options
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
- Other Formatting Features
Creating Charts
- Chart Basics
- Printing Charts
Web Features
- Saving Worksheets As Web Pages
- Hyperlinks
- Workbooks And Email