Past EventMicrosoft Excel (2007) - Intermediate (1 day)

Event Outline

NOTE: You should have a good working knowledge of Excel before attending this training. If this is not the case, we recommend that you complete the Excel Level One course prior to attending this Intermediate level programme.

The course begins with a short overview of some of the Level One topics. This will act as a recap for those who have already attended Level One, and will ensure that the experienced users who have not attended Level One become more aware of the use of Speed Keys etc. The course will then cover some of the intermediate topics - working with and linking multiple worksheets, creating charts, managing lists (Sorting & AutoFilter) among some other options.

Excel Basics (An Overview)
ü  Review of Excel Basics concentrating on quick methods of performing commonly used commands / features including an overview of Speed Keys.

Formatting 
ü  Advanced Formatting Options
ü  Using the Format Painter
ü  Deleting Formats
ü  Using AutoFormat
ü  Conditional Formatting

Viewing and Modifying Worksheets
ü  Zoom Setting
ü  Splitting a Worksheet
ü  Freezing Titles
ü  Print Titles
ü  Hiding and Unhiding Columns and Rows

Formulae and Functions
ü  Recap of Basic Formulae
ü  Recap of Basic Functions
ü  Copying Formulae
ü  Relative vs. Absolute cell addressing

Custom Lists
ü  Working with Text Lists in Excel
ü  Creating Custom Lists
ü  Incrementing Numbers & Dates

Working with Multiple Worksheets
ü  Switching between sheets
ü  Inserting a new sheet
ü  Deleting sheets
ü  Renaming a sheet
ü  Moving / Copying sheets
ü  Group Edit
ü  Linking sheets using Formulae

Charts and Drawing Tools
ü  Creating a chart
ü  The Chart Wizard
ü  The Charting Toolbar
ü  Moving / Resizing the chart
ü  Formatting charts
ü  Changing the Chart Type
ü  Working with Drawing Tools

Database Features
ü  Sorting Records
ü  Using AutoFilter

Working with Dates
ü  Formatting Dates
ü  Date Calculations
ü  The Today Function

Event Details

Date 77 days ago21 June 2010
Time 9.30am - 5pm
Location E-Bridge premises, Building 1000, 2nd Floor, City Gate, Mahon, Cork
Provider E-Bridge
Event Cost € 100
Event Cost (non-members) € 140