Microsoft Excel 2003 (Intermediate - one day)

Home | About Us | FAQs | Bookmark | Contact Us

Computer training courses, Excel training and much more.

Windows courses

Windows XP

Windows Vista

Office 2003 courses

Office 2007 courses

Other courses

Microsoft Excel 2003 Intermediate
One Day Course

DESCRIPTION :

This course is designed to improve a user's productivity within Excel. It teaches the real 'guts' of the product - the features that are likely to be useful on an everyday basis. It shows techniques to achieve quick results and how to produce slicker, more efficient workbooks that are better laid out, more consistent and easier to maintain.

PRE-REQUISITES :

This course assumes that users are able to create and maintain simple workbooks and are comfortable with entering and formatting various types of data, including simple formulas and functions. It is designed to follow on from the Excel Introduction course. Please view the contents of the Introduction course and make sure that you could confidently handle 80% of the contents before considering this course. As a rough guide, users should have at least two months experience in Excel before attending this course.

PDF :

Click here to download a PDF version of this page.

Click here to download a plugin to view a PDF file within the Firefox browser

TOPICS :

Advanced formatting

Conditional formatting
Using styles
Using the Format Painter
Changing the worksheet background

Relative and Absolute cell addressing

Using AutoFill and Smart tags
Absolute cell addressing?
The importance of dollar signs
F4 - The magic key
Partially-absolute addressing

Naming cells and ranges

Naming a cell using the Name box
Using the Define Name dialog box
Creating a constant
Using named cells for navigation
Using named cells within a formula
Modifying and deleting named cells
Creating names from existing headings
Applying names to existing formulas
Displaying a list of named cells

Data validation

Setting the rules
Giving instructions to the user
Alerting the user of an error
Conveying the severity of invalid data
Highlighting invalid data

Working with Excel databases

Entering data using AutoComplete
Entering data using Pick From List
Entering data using a Data Form
Filtering data using AutoFilter
Filtering data using Advanced Filter
Sorting rows or columns into order
Creating and using custom lists
Applying subtotals to a list

Data Outlines

Creating an outline manually or automatically
Collapsing and expanding an outline
Removing one or all outlines
Expanding the range of an outline
Using outlines with charts
Outline styles

Using Excel functions

Using AutoCalculate
Using AutoSum
Overview of the five basic functions
Using the Function Wizard
Exploring the COUNT functions
Using the PI function
Using the logical functions
Exploring the Date and Time functions
Exploring functions that manipulate numbers
Exploring Combination functions

Protection

Protecting a cell, a worksheet and a workbook.
Setting and un-setting a password

Charts

Creating a chart using the Chart Wizard
Modifying a chart
Changing the chart type
Changing the source of the data
Setting the chart options
Showing or hiding different chart components
Changing the chart location
Selecting and formatting a chart component
Applying a gradient, texture, pattern or picture fill to a chart component
Manipulating 3D charts
Using the Chart toolbar
Creating and saving custom chart types
Previewing and saving a chart as a web page

Using the Drawing toolbar (Bonus)

Drawing lines, arrows, rectangles, squares, circles, ovals and autoshapes
Changing the line, fill and font colour
Making an object three dimensional
Adding shadow to an object
Adding text to an object
Insert a clipart or picture
Selecting, aligning, spacing, grouping, layering, rotating and flipping objects
Using WordArt
Creating an Organisation Chart
Creating Cycle, Radial, Pyramid, Venn and Target diagrams

© 2005-8 Two Rivers Software Training | ABN: 23 446 823 468 | PO Box 1354, Southport BC, QLD 4215 | 0405 760 820
Delivering professional computer training at your business, at your convenience, anywhere in Queensland. Microsoft Software Training Specialists.