Excel 2013 Introduction

Course details

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.

Objectives

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:

Content

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

Prerequisites

A working knowledge of PCs and a mouse is assumed.

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.