Microsoft Excel Course Outlines

Microsoft Excel Introduction

Course Duration

One Day

Course Level

Introduction

Course Overview

Our introduction to Microsoft Excel training course is suitable for complete beginners to Microsoft Excel. At the end of this training course you will have a good working knowledge of Microsoft Excel basics. You will feel more confident using Microsoft Excel and be able to create a spreadsheet from scratch. Understanding and using some of the built in calculation and formula functionality will allow you to be more productive in your work and home Excel environments. Microsoft Excel spreadsheets that you create will be easier to use and look presentable.

Those who complete the Introduction to Microsoft Excel course satisfactorily will receive a certificate at the end of the computer training course.

Course Requirements

A working knowledge of Microsoft Windows is required or attendance on one of our Microsoft Windows introduction courses. No experience of Microsoft Excel is required.

Course Contents

Creating Workbooks

  • Enter Text and Numbers
  • Enter Formulae
  • Open, Save, Name & Close Workbooks
  • Print & Preview Options

Editing Workbooks

  • Open Existing Workbooks
  • Moving Around the Worksheet
  • Selecting Areas
  • Deleting Data
  • Editing Cell Contents
  • Copying and Moving Data

Charting

  • Chart Example
  • Creating a Chart
  • Formatting Chart Objects

Formatting

  • Apply Font Formats
  • Number Formats
  • Text Alignment
  • Handling Percentages

Working with Columns / Rows

  • Changing Column Widths
  • Changing Row Heights
  • Autofit
  • Insert/Delete Columns and Row

Further Formulae

  • Absolute Cell Referencing
  • Statistical Functions
  • AutoSum

Useful For

This course is useful for people who are in an administration role, needing to deal with a few figures and lists. The course is also a very good foundation, (followed by the intermediate and advanced course) for any one in a role that would require a high level of understanding for data manipulation.

Availability

Contact us to see how we can schedule the Microsoft Excel introduction course into your corporate schedule. We are also able to offer places on our scheduled open courses.

Our Experience

F1 Computer Services offer in-house training and open courses to companies located in Hampshire, Dorset, Wiltshire, Bournemouth and Salisbury. F1 Computer Services have been offering Microsoft courses in Dorset and Hampshire to companies and individuals for over 20 years.

Microsoft Excel Intermediate

Course Duration

One Day

Course Level

Intermediate

Course Overview

Our intermediate Microsoft Excel training course is suitable for those with a basic working knowledge of Microsoft Excel. This computer training course is designed for those users who wish to step up their current knowledge of Microsoft Excel to take advantage of the more complex features. To be able to create, edit and format large or multiple spreadsheets.

Delegates will also be able to perform calculations and functions within a workbook, manipulate data lists and create custom charts which will enable the user to maintain and present data in a professional environment. Those who complete the Intermediate Microsoft Excel course satisfactorily will receive a certificate at the end of the computer training course.

Course Requirements

A working knowledge of Excel or attendance on one of our Excel introduction courses.

Course Contents

Formulae

  • Review of Cell Addressing within Formulae
  • Copy Formulae
  • Absolute Cell Referencing

Functions

  • Use of the Average, Min, and Max Functions
  • If Function and Logical Functions
  • VLookup Function
  • Date Related Functions
  • Text and Date Functions
  • Nested Functions

Data Lists

  • Sorting Lists
  • Using AutoFilter
  • Grouping Data with Summary Rows
  • Remove Duplicates

Ranges

  • Creating Named Ranges
  • Using Range Names in Formulae

Multiple Sheets

  • Renaming Sheets
  • Inserting and Deleting Sheets
  • Copying Sheets
  • Group Edit Mode

Pivot Tables

  • Creating a Pivot Table
  • Updating
  • Creating a Pivot Chart

General

  • Protecting Sheets
  • Using Comments
  • Borders, Colours, Patterns
  • Autoformat
  • Conditional Formatting

Useful For

The Excel Intermediate course is good for people who need to extract statistics from data, report financial and sales information or to track and forecast trends.

This course is an excellent building block for the Excel advanced course.

Availability

Contact us to see how we can schedule the Microsoft Excel Intermediate course into your corporate schedule. We are also able to offer places on our scheduled open courses.

Our Experience

F1 Computer Services offer in-house training and open courses to companies located in Hampshire, Dorset, Wiltshire, Bournemouth and Salisbury. F1 Computer Services have been offering Microsoft courses in Dorset and Hampshire to companies and individuals for over 20 years.

Microsoft Excel Advanced

Course Duration

One Day

Course Level

Advanced

Course Overview

Our Advanced Microsoft Excel training course is suitable for those with a sound working knowledge of Microsoft Excel who wish to progress to the most complicated functions and features. At the end of this course you will have a complete understanding of the higher functions of Microsoft Excel.

You will be able to perform the most advanced calculations and functions, manipulate data using pivot tables and ‘advanced’ analysis, record macros and integrate with other office applications. You will then be qualified to progress to the VBA course for Excel.

Those who complete the Advanced Microsoft Excel course satisfactorily will receive a certificate at the end of the computer training course.

Course Requirements

A working knowledge of Excel or attendance on one of our Excel intermediate courses.

Course Contents

Auditing Data

  • Auditing Tools
  • Error Values
  • Removing Trace Arrows
  • Automatic Error Checking
  • Checking for Errors
  • Watch Window
  • Evaluate Formula
  • Rounding Values
  • Validating Data

Customising Formats

  • Customising Numbers
  • Conditional Formats

Using Multiple Workbooks

  • Saving a Workspace
  • Linking Workbooks

Problem Solving

  • Goal Seek
  • Solver

Scenarios and Custom Views

  • Scenario Manager
  • Custom Views

Macros

  • Absolute / Relative References
  • Recording a Macro
  • Running a Macro
  • Assigning a Macro to a Button
  • Macro Module

Working with Ranges of Cells

  • Using Labels in Formulae
  • Naming Ranges

Working with Databases

  • Groups and Outlines
  • Sub-Totals
  • Pivot Tables

Sharing Workbooks

  • Adding Comments
  • Creating and Using Templates
  • Creating a Template
  • Using a Template
  • Editing a Template

Useful For

This course is ideal for financial and statistical professionals. It is also excellent for people who need to develop and automate large spreadsheet models.

Availability

Contact us to see how we can schedule the Microsoft Excel Advanced course into your corporate schedule. We are also able to offer places on our scheduled open courses.

Our Experience

F1 Computer Services offer in-house training and open courses to companies located in Hampshire, Dorset, Wiltshire, Bournemouth and Salisbury. F1 Computer Services have been offering Microsoft courses in Dorset and Hampshire to companies and individuals for over 20 years.

Microsoft Excel Macros Introduction

Course Duration

One Day

Course Level

Introduction

Course Requirements

This Excel VBA course requires prior knowledge of Excel up to Advanced. No prior knowledge of Excel macros or Visual Basic for Applications (VBA) is required.

Course Contents

Introduction To Excel Macros

  • Discuss Excel VBA macros.
  • Discuss the Excel object model.
  • Create macros using the macro recorder.
  • Discuss the Excel object model.
  • Create macros using the macro recorder.
  • Absolute and relative references.
  • Running a recorded macro.
  • View macro security settings.
  • Recording a macro.
  • Running a recorded macro.
  • Absolute and relative recording View macro security settings .

Making your Macros accessible

  • Add macros to your quick access toolbar.
  • Add macro form buttons to your worksheet.
  • Create tabs on the ribbon to hold macro buttons.

Visual Basic Editor (VBE)

  • Discuss the VBE interface.
  • Discuss sub and function procedures.
  • Edit a recorded macro.
  • Discuss procedures and modules.
  • Create modules.
  • Create sub routines.

Working With Variables

  • VBA data types
  • Introduction to variables
  • Declaring and initialising variables
  • Use the MsgBox function

Creating user defined functions

  • Create UDFs.
  • Work with function arguments.
  • Use the insert function dialog box.
  • Displaying the function’s description.
  • Distributing your code using an add in file.

Availability

Contact us to see how we can schedule the Microsoft Excel Macros course into your corporate schedule. We are also able to offer places on our scheduled open courses.

Our Experience

F1 Computer Services offer in-house training and open courses to companies located in Hampshire, Dorset, Wiltshire, Bournemouth and Salisbury. F1 Computer Services have been offering Microsoft courses in Dorset and Hampshire to companies and individuals for over 20 years.

Microsoft Excel Introduction

Course Duration

One Day

Course Level

Introduction

Course Overview

Our introduction to Microsoft Excel training course is suitable for complete beginners to Microsoft Excel. At the end of this training course you will have a good working knowledge of Microsoft Excel basics. You will feel more confident using Microsoft Excel and be able to create a spreadsheet from scratch. Understanding and using some of the built in calculation and formula functionality will allow you to be more productive in your work and home Excel environments. Microsoft Excel spreadsheets that you create will be easier to use and look presentable.

Those who complete the Introduction to Microsoft Excel course satisfactorily will receive a certificate at the end of the computer training course.

Course Requirements

A working knowledge of Microsoft Windows is required or attendance on one of our Microsoft Windows introduction courses. No experience of Microsoft Excel is required.

Course Contents

Creating Workbooks

  • Enter Text and Numbers
  • Enter Formulae
  • Open, Save, Name & Close Workbooks
  • Print & Preview Options

Editing Workbooks

  • Open Existing Workbooks
  • Moving Around the Worksheet
  • Selecting Areas
  • Deleting Data
  • Editing Cell Contents
  • Copying and Moving Data

Charting

  • Chart Example
  • Creating a Chart
  • Formatting Chart Objects

Formatting

  • Apply Font Formats
  • Number Formats
  • Text Alignment
  • Handling Percentages

Working with Columns / Rows

  • Changing Column Widths
  • Changing Row Heights
  • Autofit
  • Insert/Delete Columns and Row

Further Formulae

  • Absolute Cell Referencing
  • Statistical Functions
  • AutoSum

Useful For

This course is useful for people who are in an administration role, needing to deal with a few figures and lists. The course is also a very good foundation, (followed by the intermediate and advanced course) for any one in a role that would require a high level of understanding for data manipulation.

Availability

Contact us to see how we can schedule the Microsoft Excel introduction course into your corporate schedule. We are also able to offer places on our scheduled open courses.

Our Experience

F1 Computer Services offer in-house training and open courses to companies located in Hampshire, Dorset, Wiltshire, Bournemouth and Salisbury. F1 Computer Services have been offering Microsoft courses in Dorset and Hampshire to companies and individuals for over 20 years.

Microsoft Excel Intermediate

Course Duration

One Day

Course Level

Intermediate

Course Overview

Our intermediate Microsoft Excel training course is suitable for those with a basic working knowledge of Microsoft Excel. This computer training course is designed for those users who wish to step up their current knowledge of Microsoft Excel to take advantage of the more complex features. To be able to create, edit and format large or multiple spreadsheets.

Delegates will also be able to perform calculations and functions within a workbook, manipulate data lists and create custom charts which will enable the user to maintain and present data in a professional environment. Those who complete the Intermediate Microsoft Excel course satisfactorily will receive a certificate at the end of the computer training course.

Course Requirements

A working knowledge of Excel or attendance on one of our Excel introduction courses.

Course Contents

Formulae

  • Review of Cell Addressing within Formulae
  • Copy Formulae
  • Absolute Cell Referencing

Functions

  • Use of the Average, Min, and Max Functions
  • If Function and Logical Functions
  • VLookup Function
  • Date Related Functions
  • Text and Date Functions
  • Nested Functions

Data Lists

  • Sorting Lists
  • Using AutoFilter
  • Grouping Data with Summary Rows
  • Remove Duplicates

Ranges

  • Creating Named Ranges
  • Using Range Names in Formulae

Multiple Sheets

  • Renaming Sheets
  • Inserting and Deleting Sheets
  • Copying Sheets
  • Group Edit Mode

Pivot Tables

  • Creating a Pivot Table
  • Updating
  • Creating a Pivot Chart

General

  • Protecting Sheets
  • Using Comments
  • Borders, Colours, Patterns
  • Autoformat
  • Conditional Formatting

Useful For

The Excel Intermediate course is good for people who need to extract statistics from data, report financial and sales information or to track and forecast trends.

This course is an excellent building block for the Excel advanced course.

Availability

Contact us to see how we can schedule the Microsoft Excel Intermediate course into your corporate schedule. We are also able to offer places on our scheduled open courses.

Our Experience

F1 Computer Services offer in-house training and open courses to companies located in Hampshire, Dorset, Wiltshire, Bournemouth and Salisbury. F1 Computer Services have been offering Microsoft courses in Dorset and Hampshire to companies and individuals for over 20 years.

Microsoft Excel Advanced

Course Duration

One Day

Course Level

Advanced

Course Overview

Our Advanced Microsoft Excel training course is suitable for those with a sound working knowledge of Microsoft Excel who wish to progress to the most complicated functions and features. At the end of this course you will have a complete understanding of the higher functions of Microsoft Excel.

You will be able to perform the most advanced calculations and functions, manipulate data using pivot tables and ‘advanced’ analysis, record macros and integrate with other office applications. You will then be qualified to progress to the VBA course for Excel.

Those who complete the Advanced Microsoft Excel course satisfactorily will receive a certificate at the end of the computer training course.

Course Requirements

A working knowledge of Excel or attendance on one of our Excel intermediate courses.

Course Contents

Auditing Data

  • Auditing Tools
  • Error Values
  • Removing Trace Arrows
  • Automatic Error Checking
  • Checking for Errors
  • Watch Window
  • Evaluate Formula
  • Rounding Values
  • Validating Data

Customising Formats

  • Customising Numbers
  • Conditional Formats

Using Multiple Workbooks

  • Saving a Workspace
  • Linking Workbooks

Problem Solving

  • Goal Seek
  • Solver

Scenarios and Custom Views

  • Scenario Manager
  • Custom Views

Macros

  • Absolute / Relative References
  • Recording a Macro
  • Running a Macro
  • Assigning a Macro to a Button
  • Macro Module

Working with Ranges of Cells

  • Using Labels in Formulae
  • Naming Ranges

Working with Databases

  • Groups and Outlines
  • Sub-Totals
  • Pivot Tables

Sharing Workbooks

  • Adding Comments
  • Creating and Using Templates
  • Creating a Template
  • Using a Template
  • Editing a Template

Useful For

This course is ideal for financial and statistical professionals. It is also excellent for people who need to develop and automate large spreadsheet models.

Availability

Contact us to see how we can schedule the Microsoft Excel Advanced course into your corporate schedule. We are also able to offer places on our scheduled open courses.

Our Experience

F1 Computer Services offer in-house training and open courses to companies located in Hampshire, Dorset, Wiltshire, Bournemouth and Salisbury. F1 Computer Services have been offering Microsoft courses in Dorset and Hampshire to companies and individuals for over 20 years.

Microsoft Excel Macros Introduction

Course Duration

One Day

Course Level

Introduction

Course Requirements

This Excel VBA course requires prior knowledge of Excel up to Advanced. No prior knowledge of Excel macros or Visual Basic for Applications (VBA) is required.

Course Contents

Introduction To Excel Macros

  • Discuss Excel VBA macros.
  • Discuss the Excel object model.
  • Create macros using the macro recorder.
  • Discuss the Excel object model.
  • Create macros using the macro recorder.
  • Absolute and relative references.
  • Running a recorded macro.
  • View macro security settings.
  • Recording a macro.
  • Running a recorded macro.
  • Absolute and relative recording View macro security settings .

Making your Macros accessible

  • Add macros to your quick access toolbar.
  • Add macro form buttons to your worksheet.
  • Create tabs on the ribbon to hold macro buttons.

Visual Basic Editor (VBE)

  • Discuss the VBE interface.
  • Discuss sub and function procedures.
  • Edit a recorded macro.
  • Discuss procedures and modules.
  • Create modules.
  • Create sub routines.

Working With Variables

  • VBA data types
  • Introduction to variables
  • Declaring and initialising variables
  • Use the MsgBox function

Creating user defined functions

  • Create UDFs.
  • Work with function arguments.
  • Use the insert function dialog box.
  • Displaying the function’s description.
  • Distributing your code using an add in file.

Availability

Contact us to see how we can schedule the Microsoft Excel Macros course into your corporate schedule. We are also able to offer places on our scheduled open courses.

Our Experience

F1 Computer Services offer in-house training and open courses to companies located in Hampshire, Dorset, Wiltshire, Bournemouth and Salisbury. F1 Computer Services have been offering Microsoft courses in Dorset and Hampshire to companies and individuals for over 20 years.