Excel 2007 Level 1

IT Training Solutions Limited

Course

Inhouse

Price on request

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Inhouse

This course will enable delegates to gain a good general understanding of the main features of Excel, giving them the ability to produce standard spreadsheets, create formulae and format and print spreadsheets.

About this course

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. Delegates should specifically be able to launch and close programs, navigate to information stored on the computer and manage files and folders.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Course Overview

This course will enable delegates to gain a good general understanding of the main features of Excel, giving them the ability to produce standard spreadsheets, create formulae and format and print spreadsheets.
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.
  • Delegates should specifically be able to launch and close programs, navigate to information stored on the computer and manage files and folders.


Objectives


    Delegates will be able to :
  • Create a spreadsheet that will contain data, navigate the spreadsheet using keyboard shortcuts, add new columns & rows and save the spreadsheet to their own folder.
  • Create and format a spreadsheet using the main features of the formatting toolbar to change the appearance of the spreadsheet.
  • 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 to speed up basic calculation.
Follow on Courses
  • Excel 2007 Level 2
  • Excel 2007 Level 3
  • Excel Pivot Tables
Training Options
  • Bespoke course (a course written to your specific needs) at your company office throughout the UK, at our training venue or at an independent location, convenient to you
  • Private course at your company office throughout the UK, at our training room or at an independent location, convenient to you
  • Scheduled public course at one of our training venues
Whats Included
  • 1 delegate per computer
  • 12 Months telephone and email support
  • Comprehensive colour course manual and exercises
  • Use of a Modern Training suite with 19 inch flat screen monitors
  • Lunch (When at our training venue)
  • Refreshments (When at our training venue)
  • Relaxed refreshment area at our training room
Course Content
Exploring the Excel environment
  • Exploring the user interface
  • Exploring the ribbon
  • Obtaining help
  • Customising the quick access toolbar
Working with an Excel worksheet
  • Creating a new workbook
  • Saving a workbook
  • Opening a workbook already created
  • Navigating in excel
  • Selecting and entering data
  • Saving a workbook
Modifying a worksheet
  • Entering text and numbers
  • Entering numbers as text
  • Inputting dates and times
  • Editing the contents of a cell
  • Manipulating data
  • Using the fill handle
  • Using the undo and redo buttons
Ranges
  • Selecting a range of cells
  • Selecting more than one range
  • Selecting an entire column and row
  • Highlighting the entire worksheet
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 unhiding a column or row
  • Searching for data in a worksheet
Developing a workbook
  • Formatting worksheet tabs
  • Repositioning worksheets in a workbook
  • Inserting and deleting worksheets
  • Copying and pasting worksheets
  • Splitting a worksheet
  • Arranging windows
  • Freezing and unfreezing rows and columns
  • Hiding and unhiding worksheets
  • Making copies of cell contents
  • Moving the contents of cells
Printing workbook contents
  • Setting print titles
  • Creating a header and footer
  • Setting page margins
  • Changing page orientation
  • Setting page breaks
  • Setting a print area
  • Printing a range
  • Starting the spell checker
Formatting a worksheet
  • Converting text to columns
  • Modifying fonts
  • Merging cells
  • Applying number formats
  • Aligning cell contents
  • Finding and replacing formats
  • Applying AutoFormat
  • Applying cell styles
  • Applying themes
  • Applying borders to a selection
  • Deleting borders around a selection of cells
  • Applying a date format to a cell or range
  • Changing the alignment of the contents of a cell
  • Using the format painter
  • Clearing cells (removing formats)
Performing calculations
  • Creating basic formulas
  • Calculating with functions
  • Copying formulas and functions
  • Creating a mixed reference
  • Order of operation
  • Displaying formulae on a worksheet
  • Auto sum button
  • Useful functions
Spelling and printing
  • Starting the spell checker
  • Viewing a print preview
  • Printing the spreadsheet
  • Printing a section of a worksheet
  • Clearing a print area

See related categories

Excel 2007 Level 1

Price on request

The best Excel courses

See all

See all