Microsoft Excel 2013
Part
1
Course Code: AD644

A “hands on” introductory course, approved for the Microsoft Office User Specialist Program. Learn the basic features and functions of Excel and create spreadsheets to meet your financial needs.

Objectives
After completing the course, participants will be able to:

  • Use the Excel menu system

  • Open, Close & Print Excel files

  • Enter Formulas into Worksheets

  • Use Task Panes

  • Adjust Column Width and Row Height

  • Automatically compute totals and fill ranges

  • Insert Columns and Rows

  • Realign cell entries

  • Change the Font and Numeric Format

  • Include print titles on every page of a printout

  • Use Excel functions

What you will learn
Topics covered by this course include:

Getting Started

  • Excel Menus

  • Using the File tab

  • Use the Quick Access toolbar

  • Customising a Ribbon

  • Displaying Help

Modifying an Existing Worksheet

  • Resetting the Working Folder

  • Moving the Cell Pointer

  • Changing Data in a Worksheet

  • Reversing an Edit Operation

  • Saving a Workbook

  • Adding Data to a Worksheet

  • Entering a Formula into a Worksheet

  • Saving & Printing a Worksheet

 

Building a New Worksheet

  • Opening a New workbook and populating it with data

  • Using Spell Checker

Editing a Worksheet

  • Using the AutoFill & AutoSum Features

  • Copying, Moving & Clearing Cell Entries

  • Inserting Cells, Rows & Columns

  • Working in Edit mode

Formatting a Worksheet 

  • Realigning Cell Entries

  • Changing the Font & Numeric Format of Cells

  • Adding Borders & Shading to a Worksheet

  • Using the AutoFormat Feature

Enhancing Printed Output

  • Changing the Page Setup

  • Previewing a Worksheet and Printing a Selected Area

  • Inserting a Manual page break and including Print titles in a printout

Using Excel Functions

  • Using the Sum, Average, Max, Min and Count Functions

  • Using the Insert Function button

 

Prerequisites
Basic computer skills are recommended for this course.

Dates and times
Please refer to your Fourth R centre for dates and times.

© Copyright The Fourth R®

 [Back to MS Office Training Courses]