|
 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 2003. 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:
Absolute References
• Relative & Absolute Cell Referencing
• Absolute Formulas
Charting
• Creating a Chart
• Chart Types and Components
• Modifying a Chart
• Adding / Deleting a Chart Sheet
• Editing Chart
• Changing the Data Source
• Formatting Chart Objects
• Labels, Titles and Legends
• Printing Charts
Working with large worksheets
• Changing the Magnification
• Full Screen View
• Splitting the Window
• Freeze/Unfreeze Panes
Range Names
• Creating with Range Names
• Navigating Named Ranges
• Assigning Names
• Range Names in Formulas
• Applying / Deleting Range Names
• Display a List of Names
Working with Outline
• Expand and Collapse an Outline
• Ungroup rows/columns in an outline
• Clearing an Outline
Paste Special
• Working with Paste Special
• Copy Formats between Worksheets
• Copy Formulas / Values between Worksheets
• Mathematical Operations
• Transposing Data
• Copy Ranges with Hidden Data
• Copy Visible Cells only
Working with Multiple Worksheets
• Navigating between Worksheets
• Insert and deleting Worksheets
• Select Multiple Worksheets
• Grouping and Ungrouping Sheets
• Move & Copy Worksheets
• Print Selected Worksheets
• 3-D Formulas
Adding Drawing Objects
• Drawing and formatting Lines, Arrows and Objects
• Adding Text to an Object
• 3-D Effect and Shadow Effects
• Adding Pictures to a worksheet
Functions
• Mathematical Functions:
- Pi, TRUNC, INT, RAND, SQRT functions
• Date and Time Functions
• Statistical Functions: Count and CountA functions
• Financial Functions
• Logical Functions: IF, CountIF, SumIf Functions
Creating and Working with Links
• Linking Data with Linking Formulas
• Managing Links
• Creating Hyperlinks
Enhanced Formatting
• Conditional formatting
• Background formatting
• Using Styles
Working with Lists
• Data Lists
• Using an AutoFilter to filter list data
• Clearing AutoFilter Criteria
• Creating a Custom AutoFilter
• Sorting Data with single or multiple Sort Keys
Data Validation
• Data Validation
• Restrict Cell Entries to Data List
Worksheet Protection
• Cell Protection
• Using Passwords
• Unprotecting a Worksheet
Comments
• Creating Comments
• Viewing /Editing a Comment
• Printing Comments
Sharing Workbooks
• Shared Workbooks
• Tips on Shared Files and Resolving Conflicts
Templates
• Creating and Working with Templates
Online Forms
• Worksheet Forms
• Creating a Form
• Adding Controls
• Selecting and moving Controls
• Adding Data to Controls
• Setting up for on-line use
|
Software Courses 
(07) 3210 0002
info@CTStraining.com.au
