Microsoft Excel Introduction

DURATION

1 Day

LOCATION

Exeter – Devon, Central London, Bristol or onsite at your premises.

OVERVIEW AND OBJECTIVES

This course is designed to help you to obtain the basic skills required to create and use a spreadsheet using Microsoft Excel. You will learn to enter and edit data, create formulas, format elements of a worksheet, and insert charts.

TARGET AUDIENCE

Those wanting to obtain basic skills in using a spreadsheet, such as updating data, applying formatting, printing, and making simple calculations.

COURSE PREREQUISITES

Ideally, you will have completed the course “Microsoft Office 2003 and Windows XP Introduction”. You should be able to use Microsoft Windows and basic functions in Office to start an application, get help, and open, close, and save files.

SUBJECT AREAS

A FIRST LOOK AT EXCEL

  • Starting the Excel program
  • What is the Active Cell?
  • The Excel cell referencing system
  • Entering numbers and text
  • Default text and number alignment
  • Adding a column of numbers
  • Worksheets and Workbooks
  • Saving a workbook
  • Closing a workbook
  • Creating a new workbook
  • Opening a workbook
  • Switching between workbooks
  • Saving a workbook using another name
  • Saving a workbook using a different file type

HELP

  • Getting help
  • Searching for Help
  • The Help ‘Table of Contents’
  • Printing a Help topic
  • Alt key help

USING EXCEL
SELECTION TECHNIQUES

  • Why are selection techniques important?
  • Selecting a cell
  • Selecting a range of connecting cells
  • Selecting a range of non-connecting cells
  • Selecting the entire worksheet
  • Selecting a row
  • Selecting a range of connecting rows
  • Selecting a range of non-connected rows
  • Selecting a column
  • Selecting a range of connecting columns
  • Selecting a range of non-connecting columns

MANIPULATING ROWS AND COLUMNS

  • Inserting rows into a worksheet
  • Inserting columns into a worksheet
  • Deleting rows within a worksheet
  • Deleting columns within a worksheet
  • Modifying column widths
  • Modifying column widths using ‘drag and drop’
  • Automatically resizing the column width to fit contents
  • Modifying row heights

COPYING, MOVING AND DELETING

  • Copying the cell or range contents
  • Deleting cell contents
  • Moving the contents of a cell or range
  • Editing cell content
  • Undo and Redo
  • AutoFill
  • Sorting a cell range
  • Searching and replacing data

WORKSHEETS
MANIPULATING WORKSHEETS

  • Switching between worksheets
  • Renaming a worksheet
  • Inserting a new worksheet
  • Deleting a worksheet
  • Copying a worksheet within a workbook
  • Moving a worksheet within a workbook
  • Copying or moving worksheets between workbooks

FORMATTING
FONT FORMATTING

  • Font type
  • Font size
  • Bold, italic, underline formatting
  • Cell border formatting
  • Formatting the background colour
  • Formatting the font colour

ALIGNMENT FORMATTING

  • Aligning contents in a cell range
  • Centring a title over a cell range
  • Cell orientation
  • Text wrapping
  • Format painter

NUMBER FORMATTING

  • Number formatting
  • Decimal point display
  • Comma formatting
  • Currency symbol
  • Date styles
  • Percentages

FREEZING ROW AND COLUMN TITLES

  • Freezing row and column titles

FORMULAS AND FUNCTIONS
FORMULAS

  • Creating formulas
  • Easy way to create formulas
  • Copying formulas
  • Operators
  • Formula error messages

CELL REFERENCING

  • Relative cell referencing within in formulas
  • Absolute cell referencing within formulas

FUNCTIONS

  • What is a function?
  • Common functions
  • Sum function
  • Average function
  • Max function
  • Min function
  • Count function

CHARTS
USING CHARTS

  • Inserting a column chart
  • Inserting a line chart
  • Inserting a bar chart
  • Inserting a pie chart
  • Resizing a chart
  • Deleting a chart
  • Chart title or labels

CUSTOMIZING EXCEL

  • Modifying basic options
  • Minimising the Ribbon
  • AutoCorrect options

PRINTING
WORKSHEET SETUP

  • Worksheet margins
  • Worksheet orientation
  • Worksheet page size
  • Headers and Footers
  • Header and footer fields
  • Scaling your worksheet to fit a page(s)

PREPARING TO PRINT A WORKSHEET

  • Visually check your calculations
  • Gridline display when printing
  • Printing titles on every page when printing
  • Printing the Excel row and column headings
  • Spell checking
  • Previewing a worksheet
  • Comparing Workbooks side by side
  • Zooming the view
  • Printing options

TO BOOK

For more information or to book onto our Microsoft Excel Introduction training course please contact us on 01392 824 022.

If there is a Microsoft course that is not listed on our site, that you are interested in attending then please let us know and we can arrange one to one training onsite with our Trainer.

Still not convinced?
We can help you!

Fill out the form below and one of our IT specialists will contact you.



Testimonials

EmailFacebookTwitterSupport PortalAME Support Tool