Microsoft Excel is a complex and powerful spreadsheet program that you can use to create, edit and format professional tabled reports. It uses grid sheets that can easily create simple lists of organised data which can be made into complex linked spreadsheets utilising formulas, functions and macros.

Excel is designed to make life easier and save you huge amounts of time. The user does not need to be a mathematical genius to create powerful statistics or advanced graphs from your data, but instead letting Excel be the calculator. As with any IT application, it will only save the delegate’s time if they know how to use it. Our Excel courses take you through the most essential commonly used features and help build up their confidence to master this fundamental office program.

PowerPoint

Excel Introduction: Spreadsheets Made Easy

Course Code: ITEE01 | Duration: 1 Day | Level: Introduction
One of the hardest problems users face in Excel is Percentages (Finding, Adding and Deducting). This course shows some simple steps of how to conquer this problem allowing users to create more complicated spreadsheets that they can trust and use effectively. In addition, linking spreadsheets is one of the easiest ways to improve your readable data with the introduction of some new formulas i.e. Today, Median, Mode and Absolute Cell Referencing. Delegates confidence will quickly grow allowing them to start learning filtering and subtotal functions.
PowerPoint

Microsoft Excel Intermediate: Combined & Complex Formulas

Course Code: ITEE02 | Duration: 1 Day | Level: Intermediate

This course introduces more complex features. By the end of this course delegates will be in a position to use some of Excel’s most beneficial functions such as If, Sumif, Countif, And, Or, Vlookup, and Hlookup and is an introduction to using combined formulas. In addition, PCS will also look at more advanced data analysis techniques with combined formulas such as Pivot tables.
PowerPoint

Microsoft Excel Intermediate Part 2: Pivot Tables & Data Reports

Course Code: ITEE03 | Duration: 1 Day | Level: Intermediate / Advanced

This 1-day hands-on training course is designed to help participants master the essential tools for organizing, analyzing, and presenting data in Excel. Whether you’re looking to enhance your reporting skills or improve decision-making through better data management, this course provides practical knowledge to elevate your Excel expertise.
PowerPoint

Microsoft Excel Advanced: Excel Masterclass

Course Code: ITEE04 | Duration: 1 Day | Level: Advanced

The previous levels of Excel introduce several very useful functions and tools, as introduced in the previous level; one single function cannot always provide you with a solution. The advanced course focuses on how to combine the features, functions and tools of Excel together. This course is not just about integration, but several new functions will also be introduced such as Financial, Text & Date formulas. This will give the user confidence to master any formula. In addition this course also introduces Macros VBA.