Microsoft Office Specialist Courses

This Microsoft Access course is for delegates who have sound skills in the use of MS Access and are now ready to expand their knowledge into some of the more specialised and advanced features of the software. This course will provide delegates with the skills needed to create complex queries, create macros to automate tasks, enhance forms and reports and use the Access programming language Visual Basic for Applications (VBA), enabling delegates to really take control of their databases.

This Access course enables delegates to progress from the one level databases associated with holding data in Microsoft Excel, to multiple table relational databases, covering all the basics including the advantages and disadvantages. This course is a perfect starting point for a future in data manipulation.

Microsoft Excel is a spreadsheet program that can be used for storing, organising and manipulating data.

This Excel introductory course will enable delegates to gain a good general understanding of the main features of Microsoft Excel, giving them the ability to produce standard spreadsheets, create formulae and format and print spreadsheets.

In Microsoft Office Excel Level 1, delegates created, edited, formatted, and printed basic spreadsheets. This course will enable delegates to streamline repetitive tasks and display spreadsheet data in more visually effective ways. The target students for this course are students who desire to gain the skills necessary to create spreadsheets from scratch using more advanced functions and formulas, sort and filter data, analyse data and present data in visual and vibrant ways.

This course will benefit those who are already up to speed with Microsoft Excel but would now like to automate some common tasks and apply advanced analysis techniques to more complex data sets. This Excel course is aimed at anyone desiring to gain the skills necessary to create macros, audit and analyse worksheet data, create Excel PivotTables and Excel PivotCharts, use lookup tables and import and export data.

Many of us use Outlook every day but that doesn't mean you're getting the most out of it. As the versions progress new features are introduced and there are also some hidden features too that you wouldn't stumble across unless you went looking for them. This course will help you work better, faster and more efficiently ensuring you get the most out of Microsoft Outlook.

This course is aimed at those new to PowerPoint, or who have limited knowledge of the package. During this course delegates will explore the PowerPoint environment and create presentations.

Delegates will format text on slides, add graphical objects to a presentation, modify objects on slides, add tables to a presentation, add charts to a presentation and prepare to deliver a presentation.

This Word course covers the advanced features of Microsoft Word for delegates who need to work with forms, large or complex documents, and sharing documents among multiple team members.

This course is for delegates who want to learn to be more productive with Microsoft Word. Delegates will learn how to use the essential day to day functions of Word including how to create and edit documents and use character and paragraph formatting. Delegates will also be shown ways to ensure word documents are consistent and engaging using headers and footers, SmartArt and many other design features.