Ardito Computer Training

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