- Excel to Power BI: Data Preparation Essentials
- Excel Level 1
- Excel Level 2
- Excel Level 3
- Excel Analysing and Presenting Data with Dashboards and Pivot Tables
- Excel Advanced Macros
- Excel Business Intelligence using Excel Power Tools
- VBA Essentials using Microsoft Excel
- Microsoft Power Apps and Power Automate Essentials
- Office 365 Introduction - 365 Small Business or Enterprises
- Office 365 User Essentials
Recommending to everyone!
Sheard Packaging
M.C., Excel Level 1
Looking forward to putting what I've learnt into practice!
Northumbria University
C.G., Microsoft Power BI Desktop
One of the best courses I have ever attended. The pace was good and there were not any questions that the trainer could not answer
LDEUTC
K.H, Microsoft Power BI Desktop
Course Overviews at a Glance
Excel to Power BI: Data Preparation Essentials Course
Course Overview: This practical, hands-on course is designed for Excel users who want to prepare their data effectively for use in Power BI Desktop. Delegates will learn how to structure, clean, and optimise Excel data so it can be imported, modelled, and visualised seamlessly in Power BI. By the end of the day, participants will understand the key differences between Excel and Power BI data handling, and will be confident in applying best practices that reduce errors, improve efficiency, and create a solid foundation for insightful reporting. View Course
Excel Level 1 Course
Course Overview: Microsoft Excel is a spreadsheet program that can be used for storing, organising and manipulating data.This Excel introductory course will enable delegates to gain a good general understanding of the main features of Microsoft Excel, giving them the ability to produce standard spreadsheets, create formulae and format and print spreadsheets. View Course
Excel Level 2 Course
Course Overview: In Microsoft Office Excel Level 1, delegates created, edited, formatted, and printed basic spreadsheets. This course will enable delegates to streamline repetitive tasks and display spreadsheet data in more visually effective ways. The target students for this course are students who desire to gain the skills necessary to create spreadsheets from scratch using more advanced functions and formulas, sort and filter data, analyse data and present data in visual and vibrant ways. View Course
Excel Level 3 Course
Course Overview: This course will benefit those who are already up to speed with Microsoft Excel but would now like to automate some common tasks and apply advanced analysis techniques to more complex data sets. This Excel course is aimed at anyone desiring to gain the skills necessary to create macros, audit and analyse worksheet data, create Excel PivotTables and Excel PivotCharts, use lookup tables and import and export data. View Course
Excel Analysing and Presenting Data with Dashboards and Pivot Tables Course
Course Overview: This outline below contains an overview of a wide range of features within Excel that when used together can be used to create interactive visual reports and dashboards. The course will show delegates how these features can be used individually to present data but can also be used in combination to make powerful and insightful reports. The course content has been pulled from a mix of our Excel courses, some content will be recapped to ensure all delegates are at the same level as they are used in conjunction with each other to effectively present data and build reports. View Course
Excel Advanced Macros Course
Course Overview: This course is designed to introduce you to the Macro environment of Excel, it will provide you with the confidence to record macros in Excel and then be able to gain a better understanding of the code and make changes to it. We even teach you some commands that cannot be recorded, such as how to show a message to the person who runs the macro.It will not turn you into a fully-fledged programmer, but you will feel more confident in the Visual Basic Editor, and thus be able to explore more aspects of programming in Excel.For example, if you record a macro before the course and you make a mistake in the recording, you invariably have to start the recording again. After this course you will be able to step through the code, decide what you wish to keep and what you wish to get rid of, then record an extra part and add it to the code you kept thus running all the code at once.Important Note : An Excel Macro is created from lines of code of Visual Basic for Applications. These lines of code are stored in a collection called a 'Macro' or a 'Procedure'. It all depends on which angle you are coming from. If you're a programmer, you call these lines of code a Procedure; if you are an advanced user of Excel you call these lines of code a Macro. View Course
Excel Business Intelligence using Excel Power Tools Course
Course Overview: This course is split into 3 main areas:1. Get and Transform (Power Query)2. Power Pivot - Data Models and DAX calculations3. Dashboard Creation with Pivot Tables, Charts and SlicersIt is aimed at users who want to analyse data from multiple sources and want to create effective data dashboards.This course will be delivered on Excel 2016 or above and using generic data files that aim to appeal to a wide audience. View Course
VBA Essentials using Microsoft Excel Course
Course Overview: This course is aimed at those people who find they have reached their limit with the menu items of Excel and need to modify Excel to be better suited to their environment, by creating their own functions and procedures. View Course
Microsoft Power Apps and Power Automate Essentials Course
Course Overview: Are you ready to unlock the potential of the Power Platform? Our beginner-friendly course will empower you to build applications using Microsoft’s powerful suite of tools. Whether you’re a non-technical enthusiast or a budding developer this course is tailored for you.Since this is a beginner's course we will cover two of the four Power Platform tools within the course curriculum Power Apps and Power Automate. You will also learn to integrate with common Office 365 products such as Outlook and One Drive. View Course
Office 365 Introduction - 365 Small Business or Enterprises Course
Course Overview: This course is aimed at the user wishing to acquaint themselves with the basic features of Office 365. The course stresses the role of Outlook as an "All in One" messaging, SharePoint for Team collaboration and Lync 2010 for unified communications. View Course
Office 365 User Essentials Course
Course Overview: This course is aimed at the user wishing to acquaint themselves with the basic features of Office 365. The course covers the role of using the Office Online Applications to create, edit, comment and share documents. This course can be tailored to meet your organisations requirements. Each topic area is 90 minutes. Choose 4 x 90 minute modules for a 1 day course, or 2 x 90 minute modules for a half day course View Course
Some of our clients include:
Excel Courses
We provide Excel courses , our Excel Courses can be available as scheduled or private courses, meaning that you can benefit from training that fits your exact requirements. If you are unsure which Excel Courses would suit you, or if you would like help deciding, please give us a call on 0191 377 8377 or contact us online, we will be happy to help.
Private Courses
Private Courses the ultimate in flexible training. You choose the timescale, you choose the location, you choose the delegate(s) and you choose the content.
Public Scheduled Courses
Scheduled Courses, easy to book - we set the date, location and outline, so all you need to do is let us know which course you would like to attend. If a public scheduled course is not available for Excel , we can provide private, onsite or virtual courses for you . One way or another, contact us to let us know how we can help or to book your courses.