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

GETTING STARTED

Exploring The Excel Screen

Navigation - The Excel Ribbon

Working With Contextual Tabs
Using Live Preview
Using the Quick Access Toolbar (QAT)
Customising The QAT
Removing Icons From The QAT
Display the QAT Below the Ribbon
Introducing Dialogue Box Launchers
Accessing The Shortcut Menu Using Right Click
Introduction To Keyboard Shortcuts
Change Views
Showing And Hiding Workbook Elements

The Backstage View

Using The Backstage View
Opening An Excel Workbook
Closing An Excel Workbook
Creating a New Excel Workbook

Excel Selection Techniques

Selecting A Single Cell
Selecting A Range of Cells
Selecting A Range Of Cells Using SHIFT
Selecting An Entire Column
Selecting An Entire Row
Selecting The Entire Worksheet
Selecting Non-Adjacent Ranges

Navigating In An Excel Worksheet

Moving The ActiveCell
Move The ActiveCell Using The Keyboard
Move Using The Name Box
Moving Within A Selected Range
Insert A New Worksheet
Move To Other Worksheets

Entering Data

Enter Text Into The ActiveCell
Edit The Contents Of The ActiveCell
Edit Text Using The Formula Bar
Replace The Contents Of The ActiveCell
Delete The Contents Of The ActiveCell
Undoing And Redoing Edits
Enter A Date In A Cell
Enter A Heading
Entering Numbers
Enter Numbers As Text In A Cell

AutoFilling

AutoFill A Series Of Months
AutoFilling Days
Entering Dates Using AutoFill
AutoFilling A Series Of Numbers

Customising AutoFill

Customise A Custom List
Deleting A Custom List
Using A Custom List To Enter Data
Entering Data Into A Range Of Cells
Fill The Same Data Into A Range Of Cells

Saving Workbooks

Saving A Workbook For The First Time
Saving A Copy Using Save As
Saving A Workbook With A Different File Format
Save To Another Folder
Saving A Workbook To A USB
Closing A Workbook
Opening A Workbook

PERFORMING CALCULATIONS IN EXCEL

Creating Simple Formulas

Resizing The Formula Bar
Entering Formulas Using The Keyboard
Manually Entering Formulas
Using Relative Cell References
Using Absolute Cell References
Applying Absolute Cell Reference

Using Common Functions

Enter A Function
Using AutoSum To Total Columns Or Rows
Manual Select Ranges With AutoSum
Enter A Function
Use AutoComplete To Enter Formulas
Enable/Disable Formula AutoComplete
Insert Other Functions Using Extended AutoSum
Using The Insert Function Wizard

Using AutoCalculate In Excel

Get A Quick Result Using AutoCalculate

MANAGE WORKSHEET AND WORKBOOK INFO

Manage Worksheet Information

Moving Data Using Cut And Paste
Drag And Drop Data
Copy And Paste Data
Changing Paste Options
Drag And Drop To Copy Data
Inserting A New Row
Inserting Multiple Rows
Deleting A Row
Inserting A New Column
Inserting Multiple Columns
Deleting Columns
Inserting Cells
Deleting Cells
Renaming A Worksheet
Adding A New Worksheet
Moving a Worksheet
Deleting a Worksheet

FORMAT WORKSHEETS

Adjust Column Widths And Row Heights

Using The Mouse To Adjust The Column Width
Using The Menu To Adjust The Column Width
Using The Mouse Adjust The Row Height
Hide / Unhide Columns And Rows
Freezing Panes
Unfreezing Panes
Splitting A Worksheet
Remove A Split

Using The Ribbon To Format Cells

Change The Font Style
Changing The Font Size
Bolding Text
Italicise Text
Underline Text
Change Font Colour
Align Data Horizontally and Vertically In A Cell
Indenting Data In A Cell
Merging Data In A Cell
Wrapping Text In A Cell
Changing Numbers To Percentages
Increasing Or Decreasing Decimal PlacesCopying A Format Using The Format Painter
Fix Display Problems

Formatting Data Using Format Cells

Double Underline Information
Changing Text Orientation In A Cell
Wrapping Text In A Cell
Formatting Numbers As Currency
Formatting Dates
Change The Background Colour Of A Cell
Setting An Outline Border
Setting A Double Line Border
Drawing Borders Using The Mouse

PAGE SETUP AND PRINTING

Page Setup

Inserting And Removing And Page Breaks
Setting and Clearing Print Areas
Setting Page Margins Using The Page Layout View
Change The Page Orientation
Set Scaling Size
Changing The Paper Size
Change The Page Margins
Centring The Printout On The Page
Adding Headers And Footers

Print Preview in Excel

Viewing Print Preview
Printing Options
Printing Active Sheets
Printing Selected Cells
Printing Multiple Copies