About this course

Course type Performance
Course code VCEX13INT
Duration 1 Day
Special Notices

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

You will create and edit basic Microsoft Excel 2013 worksheets and workbooks.

Target Audience
This course is designed for those who wish to gain the necessary skills to create, edit, format and print basic Microsoft Excel 2013 worksheets.

What’s included

QA offers more benefits. Here is what's included with this course:

Pre-Course Reading

Tutor Support

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

  • Get started with Excel 2013
  • Create a basic worksheet
  • Modify a workbook
  • Use formulas and functions
  • Format an Excel worksheet
  • Manage worksheets and workbooks
  • Set up printing options

Outline

Module 1: Getting Started with Excel 2013

  • Excel and the Excel Environment
  • Navigate and Select in Worksheets
  • Create a Basic Workbook
  • Open, Save and Close Workbooks

Module 2: Modifying a Workbook

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

Module 3: Using Formulas and Functions

  • Creating Relative Formulas
  • AutoCalculate
  • Insert Functions
  • Use AutoSum
  • Copy Formulas
  • Creating Absolute Formulas

Module 4: Formatting an Excel Worksheet

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

Module 5: Managing Worksheets and Workbooks

  • Manage Worksheets
  • View Worksheets and Workbooks
Performance

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.