Microsoft Office Courses

Compare courses
    • Course Overview This Microsoft Access course is for delegates who have sound skills in the use of MS Access and are now ready to expand their knowledge into some of the more specialised and advanced features of the software. This course will provide delegates with the skills needed to create complex queries, create macros to automate tasks, enhance forms and reports and use the Access programming language Visual Basic for Applications (VBA), enabling delegates to really take control of their databases.




      View Full Outline
      Public Scheduled Dates
      Prices per delegate. All prices exclude VAT
      Private Courses
    • Course Overview This Access course enables delegates to progress from the one level databases associated with holding data in Microsoft Excel, to multiple table relational databases, covering all the basics including the advantages and disadvantages. This course is a perfect starting point for a future in data manipulation.

      View Full Outline
      Public Scheduled Dates
      Prices per delegate. All prices exclude VAT
      Private Courses
    • Course Overview This course is aimed at those new to using a computer. Delegates will learn basic computer concepts and skills related to the Windows environment. In addition, delegates will also learn the basics of Microsoft Word and Outlook.
      View Full Outline
      Public Scheduled Dates
      Prices per delegate. All prices exclude VAT
      Private Courses
    • 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 Full Outline
      Public Scheduled Dates
      Prices per delegate. All prices exclude VAT
      Private Courses
    • 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 Full Outline
      Public Scheduled Dates
      Prices per delegate. All prices exclude VAT
      Private Courses
    • Course Overview This course is split into 3 main areas:

      1. Get and Transform (Power Query)
      2. Power Pivot - Data Models and DAX calculations
      3. Dashboard Creation with Pivot Tables, Charts and Slicers

      It 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 Full Outline
      Public Scheduled Dates
      Prices per delegate. All prices exclude VAT
      Private Courses
    • Course Overview This course is designed to help users get the most from the advanced functions in Excel. Advanced Lookup and Reference functions to help you gather data, Text functions to organise and validate the data, Logical functions to analyse the data. You will use the advanced features of Microsoft Excel to attain a high degree of proficiency as an Excel power user within the area of writing functions.
      View Full Outline
      Private Courses
    • 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 Full Outline
      Public Scheduled Dates
      Prices per delegate. All prices exclude VAT
      Private Courses
    • 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 Full Outline
      Public Scheduled Dates
      Prices per delegate. All prices exclude VAT
      Private Courses
    • 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 Full Outline
      Public Scheduled Dates
      Prices per delegate. All prices exclude VAT
      Private Courses
    • Course Overview This Microsoft Forms Essentials course covers how Forms, SharePoint and Power Automate integrate into data collection and storage solutions in Office 365.
      View Full Outline
      Private Courses
    • Course Overview Power BI Desktop is part of the suite of tools from Microsoft which enable data to be analysed and published from a variety of sources.

      With Power BI Desktop, you get a report authoring tool that enables you to connect to and query data from different sources using the Query Editor. From the datasets you build with Query Editor you can create Reports and Visualizations or dashboards within Power BI Desktop. Reports can then be published.

      This course covers the use of Power BI Desktop to connect to data, create Visualizations, query the data and publish reports.

      This course does not cover MS Power BI Pro, Power BI accessed via Office 365 or SharePoint Services.
      View Full Outline
      Public Scheduled Dates
      Prices per delegate. All prices exclude VAT
      Private Courses
    • Course Overview This two day course is designed for individuals who will use Microsoft Project as a tool to assist them in managing projects. The topics in this course cover the critical skills necessary to create and modify a project plan file that contains tasks, resources, and resource assignments.
      View Full Outline
      Public Scheduled Dates
      Prices per delegate. All prices exclude VAT
      Private Courses
    • Course Overview Microsoft Sway is a presentation program that allows you to create interactive reports, stories, presentations and more

      Sway can include text, pictures and media, pulling content from a variety of locations, including your own device, network or internet source.

      Sways are stored on Microsoft's servers and tied to a Microsoft account, although more content is available when accessing through an Office 365.
      View Full Outline
      Private Courses
    • Course Overview This course is for users wishing to acquaint themselves with the basic features of Microsoft Teams in Office 365. The course stresses the role of Teams, Channels, Files, Meetings and Chat.
      View Full Outline
      Private Courses
    • Course Overview This Microsoft Office 365 course is aimed at the Office 365 user wishing to manage their Office 365 Tenancy and the major Applications within it as well as automating business processes in Office 365.
      View Full Outline
      Private Courses
    • Course Overview This course is aimed at those wishing to setup Office 365 and keep it running.
      View Full Outline
      Private Courses
    • 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 Full Outline
      Private Courses
    • 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 Full Outline
      Private Courses
    • Course Overview In OneNote, notebooks never run out of paper. Notes are easy to organize, print, and share, and you can search and find important information quickly, even if you forget where you've originally captured it. Best of all, your notebooks are stored online so you can easily get to them on any of your mobile devices.
      View Full Outline
      Private Courses
    • 20 of 30 Results
Have a question about a course?
I would like IT Training solutions Ltd to keep me informed with offers and news it believes would interest me*
By submitting this form, you consent to IT Training Solutions Ltd storing your information in order to respond to your request.
  • Call us on
    0191 377 8377
    to discuss your requirements.
    Mon-Fri 9am-5pm.
    Have a Question?
    I would like IT Training solutions Ltd to keep me informed with offers and news it believes would interest me*
    By submitting this form, you consent to IT Training Solutions Ltd storing your information in order to respond to your request.
"Pivot Tables I'm going to have fun with this when I return to work! "

K.T. PX Group, Excel Level 3

Which part of the course did you find particularly valuable "Hot keys, inspiring creativity and better use of smart art and insertion of images "

A.F. , PowerPoint Essentials

Which part of the course did you find particularly valuable "Isolating my key tasks and how to field some of the distractions. "

V.W. North East Business Innovation Centre, Time Management

"I did the course remotely from home and found it very useful. "

H.N. Watmos, Microsoft Teams in Office 365 Essentials

"[The trainer] was very patient with us and was always interested in how we have done things in the past and gave a very honest opinion and honest feedback. Thank you very much. "

P. , Computers for Beginners and Getting Started with MS Office

"I found all of the course valuable as what I learned was all information I didn't know before. "

D.S. , Word Advanced Features

Which part of the course did you find particularly valuable "Extremely knowledgeable training and very clear, consistent teaching style of the trainer. Very beneficial and informative training session. "

Y.B. EGGER UK, Excel Analysing and Presenting Data with Dashboards and Pivot Tables

"The training session has been very helpful as I can apply this knowledge when using the various features and apps. "

R.K. Watmos, Microsoft Office 365 Overview

"Really enjoyed this! "

R. Labour, Excel Level 3

Which part of the course did you find particularly valuable "The instructor was a great communicator, went at a good pace for all to follow. Covered some good content and I feel I've learned some great new skills to bring to the job. "

L.A. Tekmar, Microsoft Project Essentials

How would you rate the course materials overall "FANTASTIC "

C. The Auckland Castle Trust, Photoshop Level 1

Which part of the course did you find particularly valuable "All of it, but mostly use of formula and tables "

S.H. GSK, Excel Level 2

"[The trainer] was fantastic, an absolute credit to the company. Very well presented and engaging throughout very knowledgeable. "

L.R. Public scheduled course, Excel Level 3

"A lot of detail to take on board but interesting nonetheless. "

A.P. James Jones and Sons Ltd, Excel Level 2

"Extremely useful with insights on why you use functions, not only how. "

E. , Excel Level 2

Virtual Training: What is it? Watch the video:
Welcome to IT Training Solutions!Expert trainers, courses delivered online or in person, small class sizes, flexible content, course materials included and available via your personal training account or in printed form.