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 2007 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 :

What’s new for Excel 2007

An overview of the new features in Excel 2007

Advanced formatting

Establishing a theme
Conditional formatting (new & improved) using data bars, colour scales and icon sets
Using the Format Painter
Changing the worksheet background
Using styles and style sets to improve consistency and maintainability

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
Naming cells using the Name Manager
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 the old 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 new Chart Ribbons
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

© 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.

Gold Coast and Brisbane Computer Training In Microsoft Office, Adobe and Accounting software.