About this course

Course type Essentials
Course code VCEX10L1
Duration 1 Day
Special Notices

Shorter bite-size virtual sessions are available on key topics from this course. Please contact us for further details.

In this course you will create and edit basic Microsoft Office Excel 2010 worksheets and workbooks.

Target Audience:
This course is designed for students who desire to gain the necessary skills to create, edit, format, and print basic Microsoft Office Excel 2010 worksheets.

Prerequisites

  • Use a mouse
  • Type and use a keyboard
  • Navigate through Windows files and folders
  • Work with Windows - minimise, maximise, open and close

Delegates will learn how to

At the end of this course you will be able to:

  • Create a basic worksheet using Microsoft Office Excel 2010.
  • Perform calculations in an Excel worksheet.
  • Modify an Excel worksheet.
  • Format a worksheet.
  • Print an Excel workbook.
  • Manage Excel worksheets.

Outline

Module 1: Getting Started with Excel 2010

  • Excel and the Excel Environment
  • Navigate and Select in Worksheets
  • Create, edit & save a Workbook

Module 2: Modifying a Workbook

  • Cut, Copy and Paste Commands
  • AutoFill Options
  • Insert and Delete Options
  • Column Width and Row Height

Module 3: Using Formulas and Functions

  • Creating Relative Formulas
  • Insert Functions
  • Use AutoSum
  • AutoCalc
  • Copying Formulas
  • Creating Absolute Formulas

Module 4: Formatting a Worksheet

  • Font Group
  • Add Borders and Fill Colours
  • Cell Alignment
  • Number Formatting

Module 5: Managing Worksheets & Workbooks

  • Managing Worksheets (Worksheet Tabs)
  • Freeze Panes
  • Arrange workbooks

Module 6: Printing Options

  • Print Preview
  • Print Worksheets and Workbooks
  • Page Set Up
Essentials

1 Day

Duration
Microsoft Excel
Delivery Method

Delivery method

Virtual learning

Recreates a classroom experience online, enabling full interactions with the learning professional leading the course.

Find dates and prices

Sorry, we don't have any public dates scheduled for this course, but it can be run as a closed event for your company.
Please contact us for details on alternative ways we can help you 0845 757 3888 or email us at info@qa.com.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.