Microsoft Excel - Introduction

Introduction

A one-day instructor led workshop providing an introduction to the basic skills for working with Excel. By the end of the course delegates will be able to create, modify and print Excel spreadsheets, write simple formulas and build basic charts.

 

Pre-Requisites

To optimise the training, it would be best if attendees were able to select and open menus and icons and have a working knowledge of a computer keyboard, i.e. Shift, Ctrl, TAB and Home keys on the keyboard

 

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

  • Create a basic worksheet
  • Perform calculations in an Excel worksheet
  • Modify an Excel worksheet
  • Format a worksheet
  • Create charts
  • Print the content of an Excel workbook

Course Content:

 

Getting Started with Excel

  • Tour the Excel Screen
  • Creating a new Excel workbook
  • Entering and editing labels and values
  • Selecting cells and data ranges
  • Moving and copying data
  • Saving and updating a workbook
  • Navigate and Select Cells in Worksheets
  • Customise the Quick Access Toolbar

Calculations in an Excel Worksheet

  • Creating new formulas
  • Using SUM function
  • Using AVERAGE, MIN, MAX and COUNT
  • Using Autofill
  • Copying formulas and functions
  • Editing formulas and functions

Modifying a Worksheet

  • Edit Worksheet Data
  • Find and Replace Data
  • Using Sorting and Filtering

Modifying a Worksheet Structure

  • Formatting text
  • Formatting rows and columns
  • Formatting numbers
  • Inserting rows and columns
  • Deleting rows and columns
  • Freezing panes
  • Splitting the screen

Creating Charts

  • Creating a simple chart using Chart Wizard
  • Formatting a chart

Printing Excel Workbooks

  • Define the Page Layout
  • Print a Workbook