Excel 2013 – Introduction

Duration: 1 day

Course Aims and Objectives:

Microsoft Excel is a useful tool for generating spreadsheets from a number of data sources. Using calculations and functions, users can easily manage any type of data including budgets, financial data, statistical data, reports, charts, graphs and small lists.

Who should attend:

This course is designed for those who wish to gain the necessary skills to create, edit, format and print basic Microsoft Excel 2013 Spreadsheets.

Assumed Knowledge

A working knowledge of PCs and a mouse is assumed.

Course Outline Summary

The Excel Introduction course covers a range of topics which will introduce you to Excel features and the steps required to use these features correctly. On completion of this course, all participants will be able to perform the following:

Creating a Basic Workbook

  • Getting Started
  • Signing In
  • Creating a New Workbook
  • Parts of a Workbook
  • Opening and Saving a Workbook

 

Working with Data

  • Selecting Data
  • Entering and Deleting Data
  • Using Undo and Redo
  • Using Cut, Copy and Paste
  • Using Paste Special
  • Inserting Rows and Columns
  • Merging and Splitting Cells

 

Using Basic Excel Tools

  • Understanding Cell Reference and Formulas
  • Using Basic Formulas and Functions
  • Using Spell Check
  • Using Sort and Filter

 

Using Timesaving Tools

  • Using AutoFill, Flash Fill, AutoSum and Auto Calculate

 

Formatting Data

  • Applying Text Effects
  • Applying Borders and Fill
  • Clearing Formatting
  • Wrapping Text
  • Changing the Size of Rows and Columns
  • Changing Number Formats

 

Inserting Art and Objects

  • Inserting SmartArt
  • Inserting Text Boxes
  • Inserting Pictures
  • Drawing Shapes

 

Viewing, Printing and Sharing Your Workbook

  • Using Views
  • Saving a Workbook as PDF or XPS
  • E-Mailing a Workbook
  • Sharing Your Workbook on SkyDrive

 

Customising the Interface

  • Changing Ribbon Display Options
  • Customizing the Quick Access Toolbar
  • Creating Custom Ribbon Tabs