Microsoft Excel Fundamentals

Level
Total time

Microsoft Excel Fundamentals

Hemsley Fraser
Logo Hemsley Fraser

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

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

Enteri…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

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
There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.