Recognition of Prior Learning
High School Students
Get Brochure »
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)* CommentsPART 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
Friday 13 October 2017
9.00am to 5.00pm. This program is classroom based.
Payment of all fees is required in full at time of registration
For further information contact the Customer Service Centre on 1800 448 176 (Free Call).