IT Training | Microsoft Excel | Summary

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.

Title: Spreadsheets Made Easy
Course Code: ITS12 | Duration: 1 Day | Level: Introduction | Price Grade: Standard
  Course Description: 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. Delegate’s confidence will quickly grow allowing them to start learning filtering and subtotal functions.
  Click here for more information.
Title: Complex Formulas
Course Code: ITS13 | Duration: 1 Day | Level: Intermediate | Price Grade: Standard
  Course Description: 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.
  Click here for more information.
Title: Excel Advanced
Course Code: ITS14 | Duration: 1 Day | Level: Advanced | Price Grade: Standard
  Course Description: 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.
  Click here for more information.
Title: Excel Accreditation
Level: Microsoft Office Specialist | Price Grade: Premium
  Course Description: If you are looking to start a career in business or finance, having a working knowledge of Microsoft's Excel 2016 is a must. This course will teach you how to reveal insights hidden in your data with the help of new features. We recommend that delegates complete the intermediate and advanced levels at PCS beforehand.
  Click here for more information.