Course code: 2E2ExcelF - 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 delivered in Excel versions 2000, 2002 or 2003.
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