Excel - Basics

Get Brochure »

Course Name
Excel - Basics
Course Number
163-81015V01
Qualification
TAFE Plus Statement

Summary

This Excel Basic Course will introduce participants that are new to Excel, to all of the fundamentals of the program. Users will learn how to build a spreadsheet from scratch including the creation and alteration of formulas. Users will then learn how to format a spreadsheet using the applications various formatting features. Finally, attendees will be shown how to setup and manage the various printing and page setup options of Excel.

PART ONE - WORKSHEET AND WORKBOOK BASICS
* The Excel Interface
* Workbook and Worksheet Views
* Building a Spreadsheet from Scratch
* Inserting / Deleting / Renaming Sheets
* Cells & Data
* Highlight Cells, Rows, Columns
* Insert / Delete / Hide Columns and Rows
* Cut, Copy & Paste
* Entering & Editing Cell Data
* Using the AutoFiller
* Formula Fundamentals
* Multiplication, Division, Addition, Subtraction
* AutoSUM
* Checking Spelling and other Proofing Options
* Find & Replace (Data and Formatting)
* Comments


PART TWO - MANAGING WORKSHEETS AND WORKBOOKS
* Formatting Worksheets (Row, Cell & Column formats)
* Numeric Formats
* Aligning, Rotating, Merging, Indents, Text Wrapping
* Borders & Colours
* Column Widths and Row Heights and AutoFit
* Freeze and Split Panes
* Previewing, Printing & Altering Page Setups
* Page Setup Configuration
* Headers & Footers
* Sheet and Print settings
* Page Breaks
* Export workbooks (e.g. PDF, CSV, Other Formats)
* File Management

Study Options

For further information contact the Customer Service Centre on 1800 448 176 (Free Call).