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.
17 August 2019 | Produced by Kandy Shaw In a previous post, ‘What does a Scrum Master do and what is their role?’ I explained that Scrum encourages collaboration and active involvement of all team members. This creates a self-organised and dedicated team as...
31 July 2019 | Produced by Kandy Shaw In a previous post; ‘What is Scrum Master and what are the Benefits of Getting a Scrum Master Qualification?’ I said that I would describe the Scrum Master’s role in more detail. Well, here, as promised is that description....
17 July 2019 | Produced by Kandy Shaw What does a Scrum Master do?As I explained in my post What is Scrum Methodology and Scrum Project Management?, a Scrum team is self-organising meaning that there is no team leader to delegate tasks. Issues are resolved by the...
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.