Close Window Print Outline Download PDF

Preparing Outline For Print

Raising the Bar | Austrlia's Leading Training Provider

EXCEL BEGINNER 2013

Course Overview

This course is designed for people with no prior knowledge of Excel or Excel spreadsheets. They may be able to enter data into their excel spreadsheets however would like to be able to format the spreadsheet to give it a more professional look and feel for printing. They may want to learn how to enter a formula so that it automatically updates when changes are made or learn how to make a chart out of the data already entered into their existing Excel worksheets. It would be beneficial to have a basic understanding of computers and basic typing skills. As a result of this course students will gain understanding of the concepts and terminologies used in Microsoft Excel. They will be able to confidently enter, edit, navigate and format data, create and edit basic formulas and print their workbooks. Students will also gain an insight into working with Excel charts, understand and navigate the new Excel ‘ribbon’ and work with multiple windows.

Course Prerequisites

Basic computer and keyboard skills

Raising the Bar
1300 937 782
www.rtb.com.au
Excel Beginner 2013 Course

GETTING STARTED

Exploring The Excel Screen

Navigation - The Excel Ribbon

The Backstage View

Excel Selection Techniques

Navigating In An Excel Worksheet

Entering Data

AutoFilling

Customising AutoFill

Saving Workbooks

PERFORMING CALCULATIONS IN EXCEL

Creating Simple Formulas

Using Common Functions

Using AutoCalculate In Excel

MANAGE WORKSHEET AND WORKBOOK INFO

Manage Worksheet Information

FORMAT WORKSHEETS

Adjust Column Widths And Row Heights

Using The Ribbon To Format Cells

Formatting Data Using Format Cells

PAGE SETUP AND PRINTING

Page Setup

Print Preview in Excel