Excel 2010 Introduction Training Courses

Duration:

Bespoke One-to-One / Group Courses: From £350.00 + VAT per day

Course Objective:

Delegates will identify basic worksheet and workbook concepts and terms. Enter & edit data, modify the worksheet, use functions to calculate and return values, format cells to enhance the appearance of your worksheet. Use drawing features and other enhancements.

Course Contents:

Excel Essentials Managing the Worksheet
  • Starting Excel
  • What is a Worksheet?
  • What is a Workbook?
  • Identifying parts of a Screen
  • Identifying the Ribbon Components
  • Getting Help
  • Using Selection Techniques
  • Selecting a Range of Cells
  • Selecting Non Adjacent Cells and Ranges
  • Selecting an Entire Worksheet
  • Entering Data
  • Entering Text Data into a Cell
  • Entering Values
  • Entering Data into a Range
  • Quickly Adjusting a Column Width
  • Finishing a Workbook
  • Saving a Named Workbook
  • Saving the Workbook in HTML Format
  • Printing a Worksheet
  • Closing a Workbook and Exiting from Excel

Formatting Text & Printing a Document

  • Opening a Workbook
  • Creating a New Workbook
  • Opening a Recently Used Workbook
  • Creating Simple Formulas
  • Creating a Formula by Pointing
  • Using Functions
  • Using the AutoSum Button
  • Using the Formula Palette
  • Editing Data on the Worksheet
  • Editing the Data in a Cell
  • Editing a Formula
  • Clearing the Contents from a Cell or Range
  • Navigating in a Worksheet
  • Using the Scroll Bars and Boxes
  • Changing Worksheets
  • Using Go To
  • Changing the Worksheet Structure
  • Deleting Cells, Rows and Columns
  • Performing a Simple Sort
  • Creating and Using Named Ranges
  • Automatically Naming Ranges
  • Navigating with Named Ranges
  • Using Range Names in Formulas
  • Pasting a List of Named Ranges
  • Deleting and Editing Range Numbers
  • Creating Named Constants

Printing

Formatting the Worksheet 

  • Moving and Copying Data
  • Copying Data with AutoFill
  • Defining Relative, Mixed, and Absolute References
  • Copying Formulas
  • Changing the Appearance of Data
  • Changing Row Height
  • Applying Fonts
  • Adding Enhancements
  • Aligning Data in Cells
  • Merging & Centering Cells
  • Rotating & Indenting Text
  • Adding Borders & Shading
  • Using Drawing Tools
  • Creating & Editing 3-D Objects
  • Using other Drawing Tool

Enquire About Excel 2010 Introduction Training Courses Course

This course can be tailored to meet your exact requirements.
 

* fields are mandatory.

What our attendees have said about us:
The trainer had very good knowledge of Excel. He had a great sense of humour which made the day go better.
The Football League
This was the most fun Excel training course I have been on. Thanks
Liberty
The tutor was very calm and easy to understand. He explained everything again if asked.
Senator Pens
Very friendly, helpful, positive, patient, and good at explaining each topic
Bovis
Very helpful course, the information was interesting
REC