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.
Home >> News Updated by Kandy on 14 October 2019 | Originally Produced by Sam on 03 April 2019 Although short, this post compliments What Jobs can I get with a PRINCE2® Qualification? which is a much more comprehensive look at jobs and salaries...
Home >> News Produced by Kandy Shaw | Update 18 September 2019 | Originally Published 18 September 2017 What jobs can I get with a PRINCE2® Qualification? I first wrote this post in September 2017, so here is the much-needed update. Whilst a lot of...
Home >> News 23 August 2019 | Produced by Kandy Shaw Within a Scrum Team, trust and transparency are the ‘glue’ for effective collaboration. They create a no-blame culture and environment within which every team member feels confident to share ideas,...
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.