Tailored Courses for IT and Business Professionals
|
Microsoft Excel 2003 Guided Tour
Objectives
This course will enable Excel users to design Excel worksheets for a variety of
reporting, budgeting, and numerical forecasting tasks.
Duration
One Day
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
Prerequisites
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
Topics covered
Getting started
- 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
- Movement techniques in worksheets
- Introduction to workbooks
Using functions
- 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
Modifying worksheets
- Editing cell contents
- Absolute and Relative cell references
- Dealing with circular cell references
- Inserting rows and ranges
- Checking the spelling of a worksheet
Formatting techniques
- 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
|