Duration:1 day | Book this course
Cost: $275.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
- Using the Drawing tools
- 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