£40 – £80

Microsoft Excel - unharness the power with the number one Business Tool

Event Information

Share this event

Date and Time

Location

Location

China Fleet Country Club

Saltash

PL12 6LJ

United Kingdom

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Event description

Description

Excel

You will create and edit Microsoft Excel 2016 worksheets and workbooks.

Target Audience

This course is designed for those who wish to gain the necessary skills to create, edit, format and use key formulae and functions within Microsoft Excel 2016 worksheets.

Prerequisites

  • Use a mouse
  • Type and use a keyboard

Delegates will learn how to:

  • Navigate through Windows files and folders
  • Work with windows - minimise, maximise, open and close
  • Get started with Excel
  • Create a worksheet
  • Modify a workbook
  • Use formulas and functions
  • Creat charts and tables
  • Format an Excel worksheet
  • Manage worksheets and workbooks
  • Set up printing options


Module 1: Getting Started with Excel

• Excel and the Excel Environment

• Navigate and Select in Worksheets

• Create a Workbook

• Open, Save and Close Workbooks

• Use Microsoft Help

Module 2: Modifying a Workbook

• Cut, Copy and Paste Commands

• Flash Fill

• AutoFill Options

• Find and Replace

• Spelling

• Undo and Redo

• Insert and Delete Options

• Column Width and Row Height

• Hide and Unhide Options

Module 3: Using Formulas and Functions

• Create Relative Formulas

• AutoCalculate

• Insert Functions

• Use AutoSum

• Copy Formulas

• Create 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: Printing Options

• Print Preview

• Print Worksheets and Workbooks

• Page Setup

• Print Titles

• Page Layout View

Share with friends

Date and Time

Location

China Fleet Country Club

Saltash

PL12 6LJ

United Kingdom

View Map

Refund Policy

Refunds up to 7 days before event

Save This Event

Event Saved