converting website visitors

Microsoft Excel Courses

Below are an example of the types of courses that we can run for the software you have chosen. 

We run courses for Microsoft Office 2010, 2013 and 2016, and specialise in 'bespoke offerings' which means we can cater a course around what suits you and your business. All our courses are run 'In House' at your offices which makes it as simple and straight forward for your team as possible.

Microsoft Excel Level 1 Training Course

Duration : 1 day

Objectives
 

This course provides an introduction to the basic concepts of Microsoft Excel. On completion of this course, the delegate will be able to create and use spreadsheets effectively for straightforward calculation and simple data manipulation. The material covered in this course provides a foundation for the Excel Level 2 course.

Designed for

This course is suitable for delegates who wish to learn to use spreadsheets
effectively. No previous knowledge is assumed, but familiarity with one or more other Windows applications would be an advantage.

Description

The course covers the essential techniques for creating a spreadsheet, entering and editing data and formulas, formatting a spreadsheet and printing spreadsheets.

Topics

  • Introduction to Microsoft Excel
  • Entering and Amending Data
  • Saving and Opening Workbooks
  • Navigating and Selecting Ranges
  • Entering Formulas
  • Inserting/Deleting Rows and Columns
  • Formatting Worksheets
  • Using Simple Functions
  • Copying, Moving and AutoFill
  • Relative vs. Absolute References
  • Previewing and Printing

Microsoft Excel Level 2 Training Course

Duration : 1 day

Objectives
This course builds on the Excel Level 1 course; on completion of the course, the delegate will be familiar with the main features of Excel that are generally used on a day to day basis. This course provides a foundation for the Excel Level 3 course that introduces some of the more advanced features of the product.

Designed for

This course is suitable for delegates who are familiar with using Excel spreadsheets, including entering simple formulas and functions, copying and pasting, using AutoFill, and formatting and printing spreadsheets.

Description

The course covers the main features of Excel that are used by most people on day to day basis, including text functions, simple logical functions, creating Charts, Sorting and Filtering Lists, inserting diagrams and comments, and Importing and Exporting data. It also introduces some useful features such as Range Names that form a basis for some of the more advanced features covered in the Level 3 course.

Topics

  • Find and Replace
  • Introduction to Range Names
  • Using Multiple Worksheets
  • Cell Styles and Conditional Formatting
  • Paste Special
  • Text and Date Formulas
  • IF Function
  • Using Charts
  • Sorting and Filtering Lists
  • Using Tables
  • SmartArt and Drawings
  • Comments and Hyperlinks
  • Importing and Exporting Data

Microsoft Excel Level 3 Training Course

Duration : 1 day

Objectives
 

This course introduces some of the more advanced features of Excel, to enable the delegate to make the most effective use of the software, including the use of linked Workbooks. On completion of the course, the delegate will be familiar with most of the main features of Excel, including several features for Data Analysis.

Designed for

This course is aimed at delegates who are familiar with the essentials of Microsoft Excel covered in the Level 1 and Level 2 courses and wish to extend their knowledge to make the most of the facilities available in the software.

Description

The course covers some of the more advanced Functions, a range of Data Analysis techniques including Advanced Filter, Database Functions and Pivot Tables, and Workbook management facilities such as multiple linked workbooks, Auditing, Shared Workbooks, Protection and Templates.

Topics

  • Managing Range Names
  • Date and Time Formulas
  • Custom Formats
  • IF and Related Functions
  • VLOOKUP and Related Functions
  • Advanced Filter / Subtotals
  • Database Functions
  • Multiple Workbooks / Consolidation
  • Data Validation
  • Auditing
  • Pivot Tables
  • Shared Workbooks / Tracking
  • Protecting Worksheets
  • Using Templates
Intec Business Colleges - Established For Over 30 Years
Microsoft Office Specialists - Approved Microsoft Courseware
Intec Business Colleges Ltd, Old School, Pennington Court, Rugby, Warwickshire, CV21 2BB, UK. VAT Number: 695223026 Company Number: 2494959
tel:01788 575090 fax:01788 575411 email:tracey.chaplin@getoncourse.net
Website Design by ZARR Ltd