Excel 2003 Advanced

ELECTUS
Adelaide, SA, Australia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' In this 2 day program, participants will gain the knowledge and skills to allow them to use Microsoft Excel 2003 to an advanced level, particularly for those interested in data analysis, data management and more complex calculations.



You will learn to

Ø Customise the interface

Ø Create new default worksheets and workbooks

Ø Use workbook collaboration

Ø Write advanced formulas and functions

Ø Use advanced database filtering

Ø Use Pivot Tables to analyse data

Ø Use What If analysis

Ø Record macros



What skills you need

The ability to use Excel’s basic Functions, write formulas, manage lists using AutoFilter .

Course Content




Using Custom toolbars and menus

· Creating a custom toolbar

· Editing toolbar buttons

· Editing a buttom image

· Attaching a custom toolbar

· Creating a custom menu

· Adding custom menu commands

Customising Excel options

· Setting View options

· Setting Edit options

· Setting manual recalculation

· Resetting automatic recalculation

· Setting General options

· Automating data entry

Using Templates

· Saving a workbook as a template

· Using a template

· Editing a template

· Inserting a worksheet

· Creating default templates

· Finding online templates

Sharing Workbooks

· Saving a shared workbook

· Viewing users sharing a workbook

· Viewing shared workbook changes

· Highlighting Changes

· Managing Conflicts

· Reviewing Tracked Changes

· Merging Shared Workbooks

Using Paste Special

· Copying Values between Worksheets

· Copying Formulas between worksheets

· Performing mathematical operations

· Transposing data
Consolidating Worksheets

· Consolidating by Category

· Consolidating by Position

Using Scenarios & Goal Seek

· Using Scenario Manager

· Displaying a Scenario

· Editing a Scenario

· Creating a Summary Report

· Using Goal Seek

User Solver

· Saving a solution as a scenario

· Restoring original values

· Changing a constraint

· Creating a Solver report

· Viewing solutions as scenarios

Using Data Tables

· Placing formulas in data tables

· Creating a one-variable table

· Creating a two-variable table

Using Advanced Functions

· Using LOOKUP Functions

· Using Nested IF Functions

· Using Functions to trap errors

· Using Functions to manage and format data

· More Nested Functions

Using Auditing Tools

· Viewing dependent and precedent arrows

· Removing all tracer arrows

· Tracing cells causing errors

· Using the Error Checking button

· Using the Evaluate Formula button

· Using the Watch window

Working with Outlines

· Applying an outline

· Collapsing/Expanding outlines

· Modifying outline settings

· Using AutoOutline
Working with Views

· Preserving a Normal View

· Creating a Custom View

· Displaying a View

Working with Advanced Filters

· Using a criteria range

· Showing all records

· Using comparison criteria

· Using an Advanced AND condition

· Using an Advanced OR condition

· Copying filtered records

· Using Database Functions

Working with the Data Form

· Viewing the Data Form

· Viewing Data Form records

· Editing Data Form records

· Adding Data Form records

· Defining Criteria

· Clearing Data Form criteria

· Deleting Data Form records

Creating/Revising Pivot Tables

· Creating a Pivot Table report

· Adding report fields

· Selecting a Page Field item

· Changing the Summary function

· Add new fields to a report

· Hiding/unhiding report items

· Deleting report fields

· Creating a Page Field report

· Formatting a PivotTable report

· Creating a PivotChart report

· Publishing reports to the Web

· Using a PivotTable list

Using Macros

· Defining macros

· Running a macro

· Recording a macro

· Assigning a macro

· Creating a macro button

...''

Phone:08 8221 5517

School Address:

37 Angas St
Adelaide SA 5000

Jobs & Resumes: Adelaide
Houses & Roommates: Adelaide

Speaking to Groups
Telephone Techniques
Indispensable Assistant
Leadership
Time Management
Access - Advanced
Access 2003
CorelDRAW 12
Dreamweaver MX 2004 Advanced
Dreamweaver MX 2004
Excel 2003 Intermediate
Excel 2003
FrontPage 2003 Advanced
FrontPage 2003
Outlook 2003
Photoshop CS2 Advanced
Photoshop CS2
PowerPoint 2003 Advanced
PowerPoint

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Schools can use this unlimited free web marketing service by submitting their course descriptions and school introductions. Two outbound links will be granted to each posting.