The following outline is for example only.
All courses can be tailored to your exact requirement
based on training needs analysis.
Training needs analysis may be purchased as a separate service or
can be provided free to any company
with an estimated training requirement of 10 or more days of training
in a given 6 month period.
A sample of the delegate notes, slides and exercises from
this course is available on request.
Please send an email stating your interest and any relevant information
to: Andrew @ Bindon . org.
This course will enable Excel users to design Excel worksheets for a variety of
reporting, budgeting, and numerical forecasting tasks.
Delegates will learn ...
- how to build, manage, save, retrieve, and print Excel worksheets
- the application of formatting choices and printing options
- shortcuts that make the time spent in Excel more productive
- an overview of Excel's advanced features
Knowledge of the windows environment is a prerequisite.
Delegates need not have prior knowledge of spreadsheets.
This course is suitable for new users to MS Excel or users who are self taught
and have been using MS Excel for a few of months.
Delegates may like to review the recommended pre-course text: Patrick Blattner, Using Microsoft Excel 2003
prior to attending. Although this may enhance a delegates enjoyment of the course
it is not a requirement.
Suggested Next Courses
Microsoft Excel 2003 Power User
- The Excel working environment
- Menus, Toolbars, Workbooks
- The help system
Introduction to worksheets and workbooks
- Creating, Opening, Saving and Closing a file
- Some examples of where we're heading
- Practical examples of usage of Excel
- "What-if" analysis
More detail on creating a basic worksheet
- Entering and editing data
- Working with ranges
- Naming ranges
- Working with long text
- Movement techniques in worksheets
- Introduction to workbooks
- Working with functions
- Screen tips for functions
- Functions with 3-D references
- The Function Wizard
Moving and copying data
- Moving data
- Copying data
- Filling series of data
- Editing cell contents
- Absolute and Relative cell references
- Dealing with circular cell references
- Inserting rows and ranges
- Checking the spelling of a worksheet
- Formatting cell contents
- Working with dates
- Advanced formatting
- Copying and pasting formats
- Printing a worksheet
Using Print Preview
- Printing the entire worksheet
- Printing specified ranges
Introduction to Excel charting