Excel 2013 Introduction Training Courses – Online or Face to Face

Duration: 1 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

  • starting Excel
  • what is a worksheet?
  • what is a workbook?
  • identifying parts of the screen
  • identifying the ribbon components
  • getting help
  • using selection techniques
  • selecting a range of cells
  • selecting nonadjacent 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
  • applying fonts
  • 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

Managing the Worksheet

  • 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
  • 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
  • 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 2013 Introduction Training Courses – Online or Face to Face Course
This course can be tailored to meet your exact requirements.
 

* fields are mandatory.

What our attendees have said about us:
Tony is a great tutor, he was very easy to understand and everything was covered. I will now b a whiz on Excel - Thank you
Lambert Smith Hampton
Brilliant tutor. Tony made sure we were all at the same pace before moving to a different topic. I really enjoyed the day.
Lewisham Homes
The trainer was very concise and patient.
Redbridge Council
Good approach, well paced. He was able to answer all questions and covered what was required by this group.
Moodys
Excellent help just what I needed, Brilliant tips and shortcuts. He was very professional and knowledgeable.
Football League
I found Tony to be very very easy to understand, and really enjoyed my course. I have learnt a great amount.
Port of Tilbury