Microsoft Excel

Requirements:

Familiar with Windows, no previous Excel experience necessary.

Duration:

3 Half Day Sessions

Cost:

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

Course Materials:

Handbooks provided for each trainee.

Further Training:

Follow on one-to-one sessions at £30.00 plus VAT per hour on an Address your Requirements basis.

Session 1

• 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

Session 2

• Changing the Style of the Spreadsheet
• Data alignment, number formatting, changing column and row sizes
• Adding lines and 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
• Producing a Printed Output
• Using page set-up
• Saving the page set-up and creating reports
• Toolbar Facilities
• Creating a useful custom Toolbar

Session 3

• Multi-Spreadsheet Activities
• Manipulating and viewing worksheets
• Copying, moving and linking between worksheets and workbooks
• Functions
• Using more advanced functions including Lookup and If functions
• Working with Macros
• Different ways to run a macro
• Recording and assigning macros
• Database Facilities
• Sorting and filtering techniques
• Subtotals and pivot tables
• What-If Features
• Goal Seek, Solver and Scenarios
• Controls for Custom Forms
• A look at controls including Check boxes, Option Buttons and List Boxes