Introduction / Intermediate Microsoft Excel

Requirements:

Familiar with Windows, no previous Excel experience necessary.

Duration:

2 Half Day Sessions

Cost:

£140.00 plus VAT one-to-one with reductions for group
training.

Course Materials:

Handbooks provided for each trainee.

Further Training:

3rd Session available covering Further Features at £70.00 plus VAT one-to-one with reductions for group training, which can be followed by one-to-one sessions at £35.00 plus VAT per hour on an Address your Requirements basis.

• Getting Around
• The Excel window
• Moving around the spreadsheet
• Mouse control - selecting cells and ranges, filling and moving
  Managing files - new and existing workbooks
• Changing defaults and settings
• Starting the Spreadsheet
• Entering text, numbers and dates
• Totalling columns of data
• Introduction to formula types and techniques
• Editing the Spreadsheet
• Inserting rows and columns
• Copying formula - methods and techniques
• Filling and naming ranges
• Clearing and deleting data
• Changing the Style of the Spreadsheet
• Data alignment
• Number formatting
• Changing column and row sizes
• Adding lines
• Changing fonts
• Protection and hiding data
• Changing the Views
• Saving custom views
• Freezing titles and splitting the worksheet
• Using Charts and Graphics
• Creating and customising a chart
• Deleting and inserting series
• Changing the type of chart
• Toolbar Facilities
• Creating a useful custom Toolbar
• Printing Basics
• Using page set-up