Are you looking to build your skills in using Microsoft Excel?
This course gives you a deep understanding of how to use some of the most popular functions in Excel. We will build you from a base skill level and assume you have no prior knowledge in using Microsoft Excel or its functions.
In this course we will cover Excel Basics, Formatting and Manipulation, Creating Formulas and Cell Referencing, Automatic Functions, Creating and Formatting Charts, Managing and Linking Worksheets, Using AutoFill, Freeze Panes and Printing.
As an example of what we have to offer, here is a video on how to freeze panes in Excel:
Are you looking to improve your Excel skills to become an advanced level user?
This course gives you a deep understanding of how to use some of the advanced level features in Microsoft Excel. We will assume you have all the knowledge taught in our prerequisite course, Microsoft Excel – A Beginners Introduction To Excel.
In this course we will cover a variety of advanced level Functions, Advanced Charts, Paste Special, Scenario’s Formulas Auditing and Locking and Security.
It’s perfect for those that are looking to improve their Excel working knowledge.
This course is most appropriate for students looking for a comprehensive, engaging, and interactive approach to Excel training
This course gives you a deep understanding of how to use some of the most popular formulas functions in Excel. We will build you from a base skill level but will assume you have a good working knowledge of Microsoft Excel before we go into more advanced features.
In this course we will cover some advanced Excel features, such as Nested functions, IF functions, VLOOKUP, HLOOKUP, Match and Index and many more! Upon completion, you will also receive a Verifiable Certificate of Completion.
Microsoft Project Training Courses
Microsoft Project is designed for managers to build and execute projects easily and effectively.
However, like Excel, to get the most out of the program, training is required so your managers can improve their understanding and use the information to deliver better results.
We have the following Microsoft Project online courses:
Microsoft Project Fundamental Skills for Users
Microsoft Project: 10 Steps To Using MS Project
Programme Management Using Microsoft Project
How To Use Automation Features In Microsoft Project
Your trainer for these courses will again be Richard Walters, who has been training Microsoft Project for just as long as developing Excel skills.
This 10-step approach, which has been developed and delivered to organisations throughout the UK over the past 10 years, teaches you the fundamental skills of controlling and implementing a project using Microsoft Project.
In this course we will start from the beginning and discuss the initial stage of any project – the Project Initiation Document (step 1).
Once complete, we will move onto utilising Microsoft Project and will learn how to Customise Microsoft Project, Set a Project Start or Finish Date, Enter Date into Microsoft Project, Modify Tasks and Enter Resources, Assign Resources To Tasks, Display Project Costs and Set a Project Baseline.
01 May 2019 | Produced by Kandy Shaw In response to ever-growing dependence on IT the UK Government CCTA (Central Computer and Telecommunications Agency) developed a set of recommendations in the ‘80s. It did so in recognition of the fact that without standard...
Produced by Sam | 03 April 2019 We all want to do the best that we can in our careers and sometimes the best thing that you can do is to make sure that you train, learn and develop your skills. When you want to work within project management, or you already do but...
How To Create Master and Sub Projects in Microsoft Project 04/01/2019 - Tutorial produced on 2/10/17 https://youtu.be/srqKqE7bH7M Talk To Our Learning Experts We understand that every individual and business has different learning needs. That is why our...
Our registered office and postal address is 50 Commercial Road, Newport, Gwent, NP20 2PE
All quoted prices are exclusive of VAT for consumers who pay no VAT or can recover VAT. The current rate of VAT is 20% for consumers that are required to pay VAT. All course bookings are subject to availability.