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 them 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
  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
  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: Advanced
Course Code: ITS14 | Duration: 1 Day | Level: Advanced
  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: Train The Trainer: Excel Masterclass
Course Code: ITM02 | Duration: 5 Days | Level: Masterclass
  Course Description: This course will give you all the Skills, Tools and Documentation to become an Advanced Microsoft Excel Trainer. Once untaken this course you will have skills, knowledge and confidence to be able teach to the highest level, instead of paying an outgoing cost to sub-contractors trainers save your company money and increase performance within you team.
  Click here for more information.

Telephone: 0114 2813350 | Email: Info@pringlepcs.co.uk