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 2003 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
Review of Excel Formulas
Using AutoCalculate
Using Basic Functions
Using Formulas
Using AutoSum
Using AutoFill
Viewing Worksheets
Renaming worksheets
Deleting and Inserting Worksheets
Customising View Options
Displaying toolbars
Grouping and ungrouping worksheets
Hiding workbooks and worksheets
Freezing Panes
More Formatting Techniques
Using Styles
Conditional formatting
Using the Format Painter
Using gridlines
Hiding and displaying cells
Displaying hidden rows and columns
More Formulas and Functions
Using the Series command
Using the Insert Function wizard
Using the Excel Function categories
Introducing the LOOKUP functions
Database and List Management
Basic database terminology
Creating and editing an Excel database
Sorting a database
Using Autofilters
Using Advanced filter
Working with filtered data
Creating Subtotals
Using Data forms
Charts
Using the Chart Wizard
The Chart toolbar
Working with charts
Formatting charts (ie. labels, plot area, axis, etc.)
Drawing and Pictures
The Drawing toolbar
Working with AutoShapes
Creating text boxes
Adding pictures
Layering objects
Grouping and ungrouping objects
Excel and Other Applications
Converting files from other applications (e.g. Word)
Copying data from another application
Embedding and linking objects
Creating hyperlinks
Managing links