Duration: 1 day | Book this course
Cost: $265.00 + GST
Course Description
This one-day course guides participants through Excel's more advanced features. Participants learn how to create and edit databases; create and modify charts; format chart objects; work with multiple worksheets and workbooks, and use financial, logical and date functions. Students also gain hands-on experience using styles, custom formats, and conditional formatting.
Prerequisites
Participants should have completed the Excel 2007 Introduction level or have equivalent experience. If you are unsure, you may phone our Booking Administrator on (07) 857.0770 or (09) 630.1220 to request for a Training Needs Assessment form.
Who Should Take This Course
Users of Excel who want to learn about the software's advanced charting, financial, database and formatting features.
Course Outline
Manipulating Data & Named Ranges
Paste Special Techniques
Importing a text file and delimit by comma, space or tab
Named ranges
Sub-totaling
Templates
Formatting & Display Techniques
Cell Styles
Table Styles
Conditional Formatting
Custom number formats
Freezing row and column titles
Hiding and un-hiding rows and columns
Hiding / un-hiding worksheets
Sorting and Querying Data
Sorting data by multiple columns
Custom sorts
Using AutoFilter
Using advanced query / filter options
Linking & Consolidating Data
Linking data or a chart within a worksheet
Linking data or a chart between worksheets [within a workbook]
Linking data or a chart between spreadsheets [workbooks]
Linking data or a chart into a word processing document
Consolidating data in adjacent worksheets using a 3D sum function
Charts Formatting Techniques
Protection and Security
Workbook password protection
Protecting / un-protecting a worksheet with a password