MS Excel courses

In this course we will learn techniques to speed up navigation and use utilities to analyse large spreadsheet files. We will also teach you to how to work with linked files and templates so that reports are both professional and in keeping with the corporate image.

Participants will take advantage of some of the more complex Excel 2007 features including working with multiple sheets, linking data across files, Auto Filtering, Subtotals and the creation and protection of templates. They will also learn how to use conditional formatting, logical, lookup and nested formulae and create custom charts enabling the user to present professional reports.

Participants will explore advanced Formulae and Function techniques, including understanding arguments and the use of Array Functions. They will also learn various methods to analyze data using Conditional Formatting, Advanced Filters, What If, Goal Seek, MS Query and PivotTable reports.

Participants will cover the essential skills required to work with Excel 2007. During the day we will enter and edit data, enter formulas and functions, save, open and create workbooks, manipulate cell ranges, format sheet appearances, print, and create professional charts and reports. During the session we will also explore the enhanced features of the 2007 interface.

The course will focus on the capability of Excel 2007 to handle very large amounts of data which can be analysed, manipulated and then presented into professional looking reports. Excel can be used to download data from many applications such as bespoke databases and many of its features such as Advanced Filters, SubTotals, PivotTable Reports and MS Query can be used to analyze the result.

This two-day course takes you through Visual Basic for Applications in Excel from recording macros through to advanced form design. You will learn how to write object-oriented programs and how to create loops and implement error-handling.

In this course we will learn techniques to speed up navigation and use utilities to analyse large spreadsheet files. We will also teach you to how to work with linked files and templates so that reports are both professional and in keeping with the corporate image.

Participants will take advantage of some of the more complex Excel features including working with multiple sheets, linking data across files, Auto Filtering, Subtotals and the creation and protection of templates. They will also learn how to use conditional formatting, logical, lookup and nested formulae and create custom charts enabling the user to present professional reports.

Participants will explore advanced Formulae and Function techniques, including understanding arguments and the use of Array Functions. They will also learn various methods to analyze data using Conditional Formatting, Advanced Filters, What If, Goal Seek, MS Query and PivotTable reports.

Participants will cover the essential skills required to work with Excel. During the session we will learn how to enter and edit data, enter formulas and functions, save, open and create workbooks, manipulate cell ranges, format sheet appearances, print, and create professional charts and reports.

The course will focus on the capability of Excel to handle very large amounts of data which can be analysed, manipulated and then presented into professional looking reports. Excel can be used to download data from many applications such as bespoke databases and many of its features such as Advanced Filters, SubTotals, PivotTable Reports and MS Query can be used to analyze the result.