Courses

Troubleshooting & supporting Windows 7 in the Enterprise. This course is designed for Information Technology (IT) professionals who have experience with Windows XP and Windows Vista who work as Windows 7 Enterprise Desktop Support Technicians (EDSTs) in Tier 2 support environments. The goal of this training is to enable these individuals to support the Windows 7 operating system and solve technical troubleshooting problems in a Windows 7 and Windows Server 2008 R2 networking environment.

In this 1 day training course we look at all of the aspects of creating and manipulating Pivot tables. They are useful if you are looking to extract more meaningful information from your data. A PivotTable is an interactive table that quickly summarizes large amounts of numeric data so you can then analyse in it detail Prerequisites: Candidates should have knowledge of Excel to an advanced level and have ideally attended level1, level2 & level 3 training or have the equivalent working knowledge.

An Excel dashboard is a visual dynamic interface showing a summary of consolidated data on a single screen. On this course you will learn how to create Dashboards using the existing tools in Excel. You don’t need any knowledge of Visual Basic macros and there is no need for extra ‘add-ins’.