|
|
| About Us
| Courses
| Web Design | Consultancy
Services | Software
| Contact Us |
 |
| Microsoft Excel Intermediate |
 |
| Objectives and Overview |
| This course is designed to advance
users' knowledge of the features and functions within Microsoft Excel and
realise the advantages of using a powerful electronic spreadsheet. The course
is entirely 'hands on', so those attending will get practice in creating
and modifying actual spreadsheets, enhancing them with charts and graphics
and using more advanced formulae. |
|
| Who should attend? |
| Users with a basic understanding of
Microsoft Excel who want to consolidate and expand on their knowledge of
the basic features. |
| Course prerequisites |
| Delegates who attend this course are
normally proficient with Excel, perhaps by having already attended our foundation
Excel course. |
| |
| Working with Rows, Columns,
Worksheets and Workbooks |
| Zooming In and Out on a Worksheet
• Hiding and Unhiding Rows and Columns • Freezing and Unfreezing
Rows and Columns • Moving Between Worksheets in a Workbook • Adding
and Deleting Worksheets in a Workbook • Creating a Three-dimensional
Formula • Linking Workbooks |
| Working with Charts |
| Creating a Chart using the Chart
Wizard • Moving, Resizing and Deleting Charts • Modifying Chart
Titles and Axis Titles • Moving and Formatting Chart Elements •
Changing the Chart Type and Organising the Source Data • Updating Data
and Formatting the Axes • Adding Gridlines and Arrows • Previewing
and Printing a Chart |
| Using Formulas |
| Using the SUM Function and AutoSum
• Using the Formula Palette • Using Date Functions • Using
Absolute and Relative Cell References • Using Basic Statistical Functions
• Using Numbered Series and AutoFill |
| Using Basic Financial and
Logical Functions |
| Using the PMT Function to Forecast
Loan Payments • Calculating Cumulative Interest • Computing Investment
Value • Using the IF Function |
| Using Excel with the Internet |
| Creating and Editing Hyperlinks
• Saving Workbooks and Worksheet as Web Pages • Sending Workbooks
Via E-mail |
| Working with Workbooks |
| Using Multiple Workbooks •
Using a Workspace • Linking Workbooks • Merging Workbooks •
Grouping and Outlining Data • Previewing and Printing Workbooks •
Using the Report Manager |
| Working with Data and Named
Ranges |
| Importing Data from Text Files
• Importing Data from Other Programs • Importing HTML Tables •
Exporting Data to Other Programs • Adding and Deleting Named Ranges
• Using Names to Locate a Range • Using the HLOOKUP and VLOOKUP
Functions |
| Creating and Using Excel
Lists |
| Creating and a List • Modifying
a List • Searching for Records • Sorting Records • Setting
up a List Filter |
| Protecting Workbooks |
| Applying and Removing Password
Protection • Projecting Worksheets and Workbooks |
| Changing Print Options |
| Adding Headers and Footers •
Changing Margins and Centring a Worksheet • Changing the Orientation
and Scale • Adding and Deleting a Page Break • Setting and Clearing
the Print Area |
| |
 |
| ©
Helen Williams 2008 |
|
Courses 
Home
page