Excel 2003 Advanced

Two Rivers Software Training
Gold Coast, QLD, Australia

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

Course Description:

'' This course covers the top-end functions of Excel. It is aimed at experienced Excel users who work with large volumes of data and require methods to better handle and maintain this data.

TOPICS :
Custom Formatting

Using number, currency and date placeholders
Creating custom formats
Advanced Functions

Advanced date and time functions
Text functions
Lookup functions
Financial functions
Database functions
Resolving common formula errors

Using Smart Tags
Using the IS functions to hide errors
The Formula Auditing toolbar
Using the Error Finder
Tracing precedents and dependents
Tracing an error
Resolving a circular reference
The “What If?�tools

Scenarios, Goal Seek, Solver and Data Tables
How to set the answer and work backwards to one or more source values
Adding constraints
Keeping a solution or restoring original data
Save a Solver solution as a scenario
‘Creating a Solver Report
Custom Views

What can be stored in a view?
Creating, editing, displaying and deleting a view
Importing data into Excel

Importing a CSV file
Importing an entire or filtered Access database table
Consolidating worksheets

Consolidating data by position
Consolidating data by category
Macros

Record a macro
Running a macro using a macro menu, a custom menu item, a toolbar icon or a graphic
Exploring macro code using VBA
PivotTables

Creating a basic pivot table
Exploring pivot-table components
Filtering data using page, column and row fields
Moving, adding and removing data from the pivot table.
Updating the original data and refreshing the pivot-table
Changing the data function
Renaming a field
Using the Show Pages tool
Showing how a data total was generated
Formatting a pivot-table
Exploring the pivot-table options
Collapsing and expanding data
Using calculated fields and calculated items
Grouping text items.
Grouping data into date or numerical bins
Sorting data manually and automatically
Creating and customising a PivotChart Report
Arrays (Bonus)

Creating an array formula
Understanding array rules and characteristics
Locating and editing an array formula
Using logic functions with arrays
Creating a Frequency Distribution
Creating a Histogram
On-line forms (Bonus)

Exploring the Forms toolbar
Adding labels
Adding a drop-down list or list box
Adding a spinner control
Adding tick boxes or option buttons
Grouping options together
Adding a scrollbar
Showing or hiding the gridlines
Selecting and moving controls
Save the form so it can be used
Sharing Workbooks (Bonus)

Allowing a workbook to be shared
Protecting worksheets and workbooks
Handling conflicts
Implications of sharing a workbook
Sending a workbook for review by mailing or routing slip

...''

Phone:0405 760 820

School Address:

PO Box 1354, Southport BC, QLD 4215, Australia

Jobs & Resumes: Gold Coast
Houses & Roommates: Gold Coast

Windows XP
Excel 2003 Introduction
Access 2003 Introduction
Access 2003 Advanced
Powerpoint 2003
Publisher 2003
Microsoft Project 2003
Dreamweaver
MYOB

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: ASKEDU jobs and talents message board can help you find jobs related to your experience in a specific city, or hire somebody in place with particular knowledges.