Excel Level 1 - Essentials

Excel Level 1 - Essentials Course Overview

Course Prerequisites

• • Delegates should be familiar with using computers and have used a mouse and keyboard. Delegates should be comfortable in the Windows environment and be able to use Windows to manage information on their computer.

Course Objectives

• • Create a spreadsheet containing data, navigate using keyboard shortcuts, add new columns and rows and save the spreadsheet.
  • Create and format a spreadsheet using the main features of the formatting tools,
  • Perform the following calculations on a range of numbers: addition, subtraction, multiplication and division.
  • Use: sum, average, count, min and max on a range of numbers.
  • Present the data in a chart and print the spreadsheet

Included with this course

• • Lunch and refreshments when training is delivered at our training venues
  • Comprehensive course materials and exercises
  • Telephone and Email Support

Excel Level 1 - Essentials Course Content

• Exploring the Microsoft Excel environment

  Exploring the user interface
  Exploring the ribbon
  Obtaining help
  Customising the quick access toolbar

• Understanding Workbooks and Worksheets

  Creating a new workbook
  Saving a workbook
  Opening a workbook already created
  Navigating in Microsoft Excel
  Selecting and entering data
  Saving a workbook

• Entering and Editing Specific Data

  Entering text and numbers
  Entering numbers as text
  Inputting dates and times
  Editing the contents of a cell
  Manipulating data
  Undo and redo buttons

• Using and Understanding Cell Formats

  Cell Formats options
  Understanding the General Format
  Date and Time Formats
  Currency and Accounting Formats
  Text Formats
  Clearing and Resetting Formats
  

• Ranges

  Selecting a range of cells
  Selecting more than one range
  Selecting an entire column and row
  Highlighting the entire worksheet

• AutoFill

  Using Autofill to automate data entry
  Text AutoFill
  Number Autofill
  Date AutoFill
  Custom Lists
  FlashFill

• Columns and rows

  Inserting and deleting cells, columns and rows
  Changing column widths and row heights
  Auto-fitting a column to its contents
  Changing back to standard widths
  Hiding and un-hiding a column or row
  Searching for data in a worksheet
  Freezing and unfreezing rows and columns

• Developing a workbook

  Formatting worksheet tabs
  Repositioning worksheets in a workbook
  Inserting and deleting worksheets
  Copying and pasting worksheets

• Formatting a worksheet

  Modifying fonts
  Merging cells
  Aligning cell contents
  Finding and replacing formats
  Applying borders to a selection
  Deleting borders around a selection of cells
  Changing the alignment of the contents of a cell
  Using the format painter
  Clearing cells (removing formats)

• Cut, Copy and Paste

  Cut, Copy and Paste
  Shortcuts
  Copying and Pasting to different sheets
  Paste Options

• Performing calculations

  Adding and Subtracting Numbers
  Multiplication and Division
  BODMAS
  Cell references
  SUM function
  AUTOSUM
  Useful Basic Functions AVERAGE, MIN, MAX and COUNT
  

• Basic Sorting and Filtering Data

  Sorting data
  Filtering data

• Basic Charts

  Chart types
  Simple Chart Customisations
  

• Spelling and Printing

  Spell checker
  Print preview
  Printing the spreadsheet
  Printing a section of a worksheet
  Clearing a print area