Microsoft Excel 2013
Introduction

Course Overview

In this course you will learn the fundamentals of working with spreadsheets with Microsoft Excel 2013. You will learn how to produce a professional looking worksheet by entering numbers and creating timesaving Excel formulas and use the predefined Excel functions. You will also learn how to quickly and easily change the layout of your worksheet and enhance the appearance of your worksheet using the format commands. You will also learn how to work with multiple sheets within a file and how to setup and print your worksheet.

Course InformationRelated Training

Duration: One-Day Course
Platform: Windows Only
Fee: Call for information

We recommend one to eight people for this course.

Course Content Download PDF (57kb)

Create and Edit a Worksheet

The Excel 2013 interface: the Backstage View, Ribbon and Quick Access Toolbar in Office 2013.
Efficiently move through a worksheet.
Select cells and ranges.

Create Formulas and Functions

Enter data and create time-saving Excel formulas.
Use the SUM, AVERAGE, MIN, MAX and COUNT functions.

Manage your Worksheet

Insert, delete and hide cells, rows, and columns.
Discover the many techniques to cut, copy and paste.
Use the new Flash Fill features.

Format your Worksheet

Enhance the appearance of your worksheet using the many formatting commands.

Manage your Workbook

Name, group, move, copy and colour your worksheet tabs.

Print your Worksheet

Setup and print your worksheet.

Application Overview: Microsoft Excel 2013

Microsoft Excel is a powerful tool to create and format spreadsheets and to analyze, evaluate, calculate data, create rich data visualization and professional-looking charts. You can compile your company's data into a Microsoft Office Excel workbook that can contain many worksheets.
Microsoft Excel can be used to manage numbers and calculations. You can create formulas in Excel that automatically update when you change your data.

Users: IT, Database, Engineering, Finance, Legal, Marketing and Admin Professionals as well as anyone who needs create and edit spreedsheets that can be searched, sorted, analysed, reported, updated and shared with other users.

Microsoft Excel 2013 Introduction