Excel Intermediate
THIS COURSE CAN BE RUN AS A CLOSED COURSE FOR YOUR COMPANY OR AS A 1 TO 1 COURSE FOR INDIVIDUALS. PLEASE CALL FOR INFORMATION AND DATES
This course is to continue introducing the user to the fundamental principles, following the one day course entitled Excel 2003 Foundation. Can be followed by Excel 2003 Advanced.
Sorry, there are currently no dates scheduled for this course.
Delegates Will Learn How To
• Using multiple worksheets, workbooks and workspaces
• Working with Financial functions
• Use advanced formatting techniques
• Using the Auditing Tools to track information
• Using charts to display data, including financial data
• Use Templates
Course outline
Using Multiple Sheets and Workbooks
Using Multiple Worksheets
Inserting New Worksheets
Renaming Worksheets
Deleting Worksheets
Creating Multiple Views
Freezing Panes
Viewing and Arranging Multiple Worksheet Windows
Navigating in Multiple Workbooks
Selecting and Viewing Multiple Workbooks
Creating and Opening a Workspace
Managing Multiple Worksheets and Workbooks
Selecting Multiple Worksheets
Moving and Copying Data between Worksheets
Linking Data Between Worksheets
Creating a 3-D Formula
Charting
Using Charts
Creating a Chart
Specifying the Chart Source Data
Selecting Chart Options
Selecting a Chart Location
Managing Chart Objects
Moving and Resizing Chart Objects
Deleting Chart Objects
Adding Data Series’ and Objects to a Chart
Enhancing the Chart
Changing the Chart Type
Formatting Chart Objects
Adding Text to a Chart
Printing Charts
Advanced Functions
Creating and Using Functions
Using Built-in Functions
Working with Arguments: The PMT Function
Using Dates and Times
Using Dates in Calculations
Using Nested Functions
Auditing Worksheets
Identifying the Auditing Commands
The Watch Window
The Formula Evaluator
Tracing and Correcting Worksheet Errors
Advanced Formatting
Using Comments in a Worksheet
Reviewing, Showing, and Hiding Comments
Deleting a Comment
Working with Styles
Applying a Style
Redefining and Modifying Existing Styles
Using Format Painter
Creating Custom Number Formats
Applying an AutoFormat
Applying a Conditional Format
Using Templates
Creating a Template
Editing a Template
Verifying Your Work
Using AutoCorrect