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.
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...
13 Decemeber 2018 Merry Christmas and a happy new year from all at NILC Talk To Our Learning Experts We understand that every individual and business has different learning needs. That is why our team of experienced learning professionals is always on hand to...
Produced by Tony Perks | 07 December 2018 What is PRINCE2? PRINCE2 (PRojects IN Controlled Environments) is a structured project management framework based on experience drawn from thousands of projects - and from the contributions of countless project sponsors,...
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.