|
 This course is designed for people who have a basic knowledge of Excel, and who want to increase their knowledge of the practical uses of Excel 2007. By the completion of this course, participants will have a thorough knowledge of Excel.
Duration:
2 Days
Audience:
The course has been designed for users of Excel 2003 who have a basic knowledge of Excel.
Prerequisites:
Participants must have basic knowledge of entering data, formatting and simple formulas.
Course Content:
Using Absolute References
• Relative -v- Absolute
• Absolute Formulas
• Using Mixed References
Working with large worksheets
• Magnification
• Using Full Screen View
• Splitting a Window
• Freeze and Unfreezing panes
Range Names
• Creating with Range Names
• Navigating Named Ranges
• Assigning Names
• Range Names in Formulas
• Applying / Deleting Range Names
• Managing Names
Working with Outlines
• Overview of Outline
• Adding an Outline
• Expanding / Collapsing an Outline
• Clearing an Outline
Paste Special
• Working with Paste Special
• Copying Formats or Values only
• Performing mathematical operations
• Transposing data
• Copying ranges with hidden data
• Copying visible cells only
Multiple Worksheets & Workbooks
• Navigating between Worksheets
• Insert and deleting Worksheets
• Select Multiple Worksheets
• Grouping and Ungrouping Sheets
• Move & Copy Worksheets
• Print Selected Worksheets
• 3-D Formulas
• Managing workbooks
Shapes and Effects
• Working with shapes
• Adding and formatting lines
• Changing shape fill colour
• Adding 3D rotation effect
• Adding shadows and reflections
• Using Soft edges
• Shape and Text styles
• Adding Pictures and applying styles
Functions
• AutoSum
• Mathematical functions
• Pi, TRUNC, INT, RANDBETWEEN, SQRT functions
• Date and Time functions
• Statistical functions
• COUNT, COUNTA and COUNTIF functions
• SUMIF functions
Linking
• Linking data
• Using Copy & Paste method
• Linking formulas
• Updating and Managing links
• Creating Hyperlinks
Proofing
• Correcting recurring errors
• Find and Replace
• AutoCorrect
Advanced Formatting
• Conditional Formatting
• Formatting cell backgrounds
• Using patterns and colours
• Adding a background to a worksheet
• Creating and Modifying Styles
• Copying styles to another workbook
Data Validation
• Restrict Cell entries to data from a list
Working with Lists
• Data Lists
• Using Filters
• Sorting Data
• Using multiple sort keys
Protecting your Sheets
• Worksheet Protection
• Using passwords
• Unprotecting a worksheet
Comments
• Creating comments in a worksheet
• Viewing and Printing comments
Templates
• Saving a workbook as a template
• Using and Editing a template
• Insert a new worksheet based on a template
• Deleting a template
• Creating a default template
Sharing Workbooks
• Routing a Document
• Shared workbooks
• Identifying users
• Tips on shared files
• Resolving conflicts
• Reviewing history
Online Forms
• Worksheet forms
• Text boxes and drop down lists
• Adding data to controls
• List box controls
• Check box and option buttons
• Setting up for on-line use
|
Software Courses 
(07) 3210 0002
info@CTStraining.com.au
