Updated: 13/3/25
Some businesses want their staff trained to use Microsoft applications but can’t afford to send them away for a few days due to added expense and time lost away from the organisation.
So we we have developed a series of online or e-learning Microsoft training courses that will develop your employees’ understanding of the programs while keeping costs down and saving time.
The e-learning format allows participants to progress at their own pace, providing flexibility to accommodate individual schedules. Upon enrolment, learners will have access to all course materials and resources necessary to develop advanced Excel skills.
The courses are straightforward to access and can be viewed across all devices, including desktop, tablets and smartphones.
The online Microsoft courses we have available are centred around Excel and Project, two of the most important applications for businesses.
Microsoft Excel
Microsoft Excel spreadsheets are integral to all businesses in every sector. It is very flexible, meaning users can structure information however they please.
Employees that can master using Excel will be able to produce high quality work but in order to get to grips with the more technical features, training is highly recommended.
We have the following Microsoft Excel online courses:
Microsoft Excel Formulas and Functions
Microsoft Excel Pivot Tables and Advanced Filtering
Microsoft Excel Data Visualised & Formatting
NILC also offer a Microsoft Excel Masterclass Bundle incorporating the 6 courses above.
All courses are taught by Richard Walters, a Microsoft Certified Trainer who has been training Microsoft Excel for the past 16 years throughout the UK.
Microsoft Excel Introduction
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 Microsoft Excel Introduction e-learning training course, delegates will create and edit basic worksheets and workbooks. This course is designed for students who want to gain the necessary skills to create, edit, format, and print basic Microsoft Excel worksheets.
After completing this course delegates will be able to:
- Create basic worksheets using Microsoft Excel
- Perform calculations in an Excel worksheet
- Modify an Excel worksheet
- Modify the appearance of data within a worksheet
- Manage Excel workbooks.
As an example of what we have to offer, here is a video on how to freeze panes in Excel:
Microsoft Excel Intermediate
The Microsoft Excel Intermediate e-learning training course from NILC is meticulously crafted for individuals aiming to elevate their Excel proficiency by mastering advanced functionalities. This comprehensive course delves into sophisticated formulas, data management techniques, and the integration of illustrative elements to enhance data presentation. Participants will gain hands-on experience in creating and customizing charts, as well as applying advanced formatting to ensure data is both visually appealing and professionally structured.
Course Objectives:
Upon successful completion of this course, participants will be equipped to:
-
Master Advanced Formulas and Functions: Develop a deep understanding of complex formulas and functions to perform intricate calculations and data analysis.
-
Efficiently Manage and Analyse Data Lists: Learn to convert, sort, filter, and manage extensive data lists, facilitating seamless data organization and retrieval.
-
Create and Customise Charts: Acquire the skills to design, modify, and format various chart types, transforming raw data into insightful visual representations.
-
Integrate Illustrations into Worksheets: Discover how to insert and adjust illustrations, such as images and shapes, to enrich the informational value of worksheets.
-
Utilise Tables for Structured Data: Understand the creation and manipulation of tables to systematically organize data, enhancing clarity and accessibility.
- Apply Conditional Formatting and Styles: Learn to implement conditional formatting and styles to highlight critical data points and maintain consistency across worksheets.
Microsoft Excel Formulas and Functions
NILC offers a comprehensive Microsoft Excel Formulas and Functions online training course, tailored for individuals seeking to enhance their ability to create, edit, and effectively utilise Excel’s diverse formulas and functions.
Course Objectives:
Upon completion, participants will be proficient in:
-
Creating Formulas Using BODMAS Rules: Applying the correct order of operations to construct accurate formulas.
-
Utilizing Absolute and Mixed Cell Referencing: Implementing various cell reference types to maintain formula integrity during data manipulation.
-
Defining and Using Named Cells and Ranges: Simplifying formula creation and enhancing worksheet clarity by assigning names to specific cells or ranges.
-
Developing Consolidated and Grouping Formulas: Combining data from multiple sources and creating grouping formulas for comprehensive analysis.
-
Applying Conditional Formatting with Formulas: Setting rules to dynamically format cells based on specific criteria, enhancing data visualization.
-
Auditing Formulas and Functions: Employing tools to trace and validate formulas and functions, ensuring data accuracy.
Microsoft Excel Advanced
Are you looking to improve your Excel skills to become an advanced level user?
This Microsoft Excel Advanced 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 Introduction.
In this course we will cover a variety of advanced level Functions, Advanced Charts, Paste Special, Scenario’s Formulas Auditing and Locking and Security.
After completing this course, students will be able to:
- Create pivot tables and charts. Trace precedents and dependents
- Convert text and validate and consolidate data
- Collaborate with others by protecting worksheets and workbooks
- Create, use, edit, and manage macros
- Import and export data
It’s perfect for those that are looking to improve their Excel working knowledge.
Microsoft Excel Formulas and Functions
This course is most appropriate for students looking for a comprehensive, engaging, and interactive approach to Excel training
This Microsoft Excel Formulas and Functions e-learning 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.
After completing this course delegates will be able to:
- Creating formulas and using BODMAS Rules
- Absolute Cell Referencing & Mixed Cell Referencing
- Named Cells and Named Range Formulas
- Consolidated Formulas and Grouping Formulas
- Conditional Formatting Formulas
- Auditing Formulas and Functions
Microsoft Excel Pivot Tables and Advanced Filtering
NILC’s Microsoft Excel Pivot Tables and Advanced Filtering online training course course is designed to empower participants with the skills to efficiently explore and analyse raw data using Excel’s advanced features.
Course Objectives:
Upon completion, participants will be proficient in:
-
Applying Multiple and Custom Filters: Learn to implement various filtering techniques to refine data analysis.
-
Enabling Filtering by Colour: Understand how to utilise colour-based filtering to enhance data visualization.
-
Designing and Creating Pivot Tables: Develop the ability to construct pivot tables for dynamic data summarization.
-
Applying Pivot Table Calculations and Report Pages: Gain expertise in performing calculations within pivot tables and generating comprehensive report pages.
-
Filtering Pivot Tables: Master the techniques to filter pivot table data effectively for targeted analysis.
Microsoft Excel Data Visualised & Formatting
NILC offers the Microsoft Excel Data Visualised and Data Formatting online training course self-paced e-learning program designed to help participants quickly interpret and analyse data sources using Excel’s advanced features.
Course Objectives:
Upon completion, participants will be able to:
-
Apply Conditional Formatting Rules: Implement various conditional formatting techniques to highlight critical data points.
-
Apply Conditional Formatting Formulas: Use formulas to create dynamic formatting based on specific criteria.
-
Manage and Delete Formatting Rules: Efficiently handle existing formatting rules, including modifications and deletions.
-
Add and Utilise Sparklines: Incorporate sparklines – miniature charts within cells – to provide visual summaries of data trends.
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 Introduction
- Microsoft Project Advanced
NILC also offer a Microsoft Project Masterclass Bundle incorporating the 2 courses above.
Your trainer for these courses will again be senior trainer Richard Walters, who has been training Microsoft Project for over 16 years.
Microsoft Project Fundamental Skills for Users
Are you looking to build your skills in using Microsoft Project?
Microsoft Project is fast becoming the must have project management tool of choice. This course is designed to teach you the necessary skills every Microsoft Project user should be familiar with.
In this course we will cover Task Management, Constraints, Resources, Calendar Management, Managing A Project and Print Settings.
Microsoft Project Introduction
Microsoft Project is the ultimate tool for managing your projects effectively and efficiently. Designed specifically for project managers, Microsoft Project helps you seamlessly create detailed project plans, assign tasks and resources, track progress, manage budgets, and analyse workloads – so you can keep your projects on time and on budget.
Our Microsoft Project Introduction e-learning course provides you with both foundational and intermediate-level skills, enabling you to quickly master the software. Perfectly tailored for busy professionals and business owners, you’ll learn how to confidently utilise Microsoft Project in your day-to-day activities.
Whether you’re looking to enhance your career prospects, manage your team’s workflow better, or simply ensure your projects stay on budget and on time, this flexible e-learning course fits around your schedule. Boost your skills with practical training and gain valuable expertise recognised by employers.
Microsoft Project Advanced
Microsoft Project Advanced is your gateway to mastering complex project management scenarios with precision and confidence. Tailored for experienced project managers and those familiar with Microsoft Project basics, this advanced-level e-learning course delves deeper into sophisticated features, enabling you to fully leverage the power of Microsoft Project to deliver even your most ambitious projects efficiently.
In this course you’ll explore advanced resource allocation strategies, custom reporting, and enhanced tracking methods to monitor progress with pinpoint accuracy. Learn to handle intricate budgets, resolve scheduling conflicts with ease, perform in-depth workload analysis, and customise views and reports to gain actionable insights and maintain control of your projects at all times.
Designed with flexibility in mind, this e-learning course allows you to enhance your skills without disrupting your busy schedule. Gain proficiency in advanced project scheduling techniques, resource optimisation, critical path analysis, and advanced reporting features, ensuring your projects not only stay on track but exceed expectations.
Take your project management skills to the highest level with recognised expertise valued by employers across industries. Enrol today to unlock the full potential of Microsoft Project Advanced and elevate your project management capability to new heights.
Here is an example training video of linking tasks in Microsoft Project, so you know what to expect from our training:
Please contact us if you would like further information about any of these courses or if you have any other queries.
We also offer over 500 courses delivered in the classroom, by a live instructor online and we also have self-paced training courses.
