Microsoft Excel 2013 Courses

Instructor led Courses << Back to Home

Excel 2013 - Introduction

Microsoft Excel 2013 Introduction - 1 Day

This one day course is designed to introduce delegates to the concepts and functionality of an electronic spreadsheet.

Delegates will be able to use Excel efficiently and confidently by creating spreadsheets encompassing simple financial and mathematical functions.

Delegates should have a
- Basic understanding of the Windows Environment
- Be comfortable using a mouse
- You do not need
  - Previous experience of Microsoft Excel
If you would like to discuss this course further or wish to enquire if you're at the correct level call us on 08458 62 62 65 we'll be only too pleased to help.

By the end of this course you'll be able to
- Recognise the different elements that comprise an Excel workbook.
- Create and save Excel workbooks
- Manipulate worksheets in terms of naming, moving, adding and deleting
- Enter data into a new and existing worksheet
- Apply formatting to change the appearance of text
- Apply cell borders and shading
- Change the appearance of numeric data using shortcut icons and menus
- Calculate using simple mathematical functions
- Calculate using built-in functions
- Modify page margins, orientation and scaling
- Apply headers and footers to the printed page
- Print the whole worksheet or specific areas of the worksheet only
- Utilise the Office Assistant & Help features

Lesson 1 - Tour of Excel
- - The Office Button
  - Ribbons
- - Groups
  - Clipboard

Lesson 2 - Creating & Saving a Workbook
- - Autofill and Editing Data
  - Row & Column widths
  - Inserting Rows & Columns
  - Selecting / Deselecting
  - Organising Sheets
- - Renaming Worksheets
  - Inserting Blank Worksheets
  - Moving Worksheets
  - Copying and Deleting Worksheets

Lesson 3 - Entering & Editing Data
- - Creating and Editing Custom Lists
  - Cut, Copy and Paste
- - Creating a New Workbook

Lesson 4 - Creating Formulae
- - Creating simple calculations
  - AutoSum
- - Numeric Order – BODMAS
  - Absolute Cell Referencing

Lesson 6 - Formatting
- - Themes
  - Quick Format Icons
  - Currency Formatting
  - Formatting Fractions
- - Formatting as a Table
  - Cell Styles
  - Cell & Font Formatting
  - Alignment