Reset your passwordTo start, please enter your username
Reset your passwordIf an account exists using the username you entered, you will receive an email with a reset code, please use this to reset your password.
Please check your spam folder or call us on 0191 377 8377 if you have trouble finding your reset code.
Cookies are small text files that are stored on your computer, phone, tablet or other web enabled device when you visit a website.
We use the following cookies linked to analytics:
_ga, __gat_gtag_UA_845645_1 and _gid
Our cookies do not store private data or data that can identify you personally.
Overview:
This 1-day course is designed for anyone new to creating and implementing flows in Microsoft Power Automate. The content will introduce delegates to the key concepts of Power Automate, with the goal of empowering them to design and implement their own solutions in the workplace.
At course completion, attendees will possess sufficient knowledge to work with Power Automate to automate and manage common everyday business processes. Delegates will understand when and why Power Automate should be implemented and be able to create practical and useful flows to suit individual requirements. In essence, all the skills necessary to help them design and develop their own office automation solutions.
The course includes automating processes in Microsoft SharePoint, Outlook, Excel Online, OneDrive, and Microsoft Teams.
Please note, this course is about automated cloud flows. In other words, automation in the cloud, not desktop automation.
The training is delivered with plenty of illustrated examples and augmented with practical hands-on exercises to enhance the learning experience. Also, as Power Automate is continually evolving, this course is regularly reviewed and updated to keep the delivered content as fresh and relevant as possible, thus ensuring the best return on investment from the learning experience. As such, the content delivered may vary slightly from the advertised course outline depending on new and updated features.
Private Courses:
Private courses start from £845 for up to 8 delegates
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.
Public Scheduled Dates:
Public scheduled prices per delegate. All prices +VAT
Private Courses:
Private courses start from £745 for up to 8 delegates
Overview:
Power Apps is a suite of apps, services, connectors, and a data platform that provides you with an opportunity to build custom apps for your business needs.
This 1-day course explores the basic building blocks and allows you to create your own Apps and understand how to develop your skills to the next level.
Public Scheduled Dates:
Public scheduled prices per delegate. All prices +VAT
Private Courses:
Private courses start from £845 for up to 8 delegates
Overview:
This course is available on a private course basis only. We run the Microsoft Power BI Desktop course as a public scheduled event and also as a private course.
This 4-day course is intended for anyone who is new to designing and implementing self-service Business Intelligence (BI) solutions using Microsoft Power BI Desktop and the Power BI Service. It is ideal for anyone who needs a total immersion in the subject matter as the course structure is very comprehensive. The training is delivered with plenty of illustrated examples and augmented with practical hands-on exercises to enhance the learning experience. Also, as Power BI Desktop and the Power BI Service are continually evolving, this course is regularly reviewed and updated to keep the delivered content as fresh and relevant as possible, thus ensuring maximum productivity from the learning experience. Due to the very comprehensive nature of this course, the content delivered may vary depending on new and updated features, delegate requirements, and course objectives.
This course is also commensurate with the “PL-300 Microsoft Power BI Data Analyst” course and serves as ideal preparation for the Microsoft PL-300 exam. In addition to providing the knowledge required for this exam, this course takes a broader and more practical approach to Power BI, demonstrating useful techniques that will prove extremely helpful in the workplace.
The first part of the course introduces the capabilities and components of Power BI Desktop before delving into the realms of discovering and loading data from a variety of sources. Primarily focussed on using Power Query to create queries for implementation in data models, students will learn how to shape and transform loaded data, mashup data from various sources by merging and appending data, and manage, structure, and parameterise queries. Delving behind the scenes, students will also be introduced to the M language, highlighting ways in which existing code can be tweaked and how user defined code and functions can be implemented.
Part two of the course introduces students to tabular data modelling concepts, preparing the data in readiness for use in reports and dashboards. The importance of implementing relationships is also covered. In order to enhance the data model, students will be introduced to the DAX expression language to enable them to implement calculated columns, measures, and tables. Consideration is also given to implementing time intelligence in the design of data models.
In part three, you will learn how to create and design reports and implement visualisations. We will first look at text-based visuals before moving on to graphical components like charts, gauges and KPIs (Key Performance Indicators). The implementation of maps in reports is also given coverage. To create interactivity in reports, students will also learn how to implement various types of filters and slicers.
Finally, in part four, we turn our attention to the Power BI Web Service. Attendees will learn how to publish reports to the Power BI Service and how to organize and secure content. The creation and use of dashboards will be considered, and the sharing of content will also be given coverage. We will look at user accessibility issues and consider how users, including mobile users, can interact with report content. Managing and refreshing datasets in the Power BI Service is also included.
Additionally, with the course structure being fully modularised, customised versions of this course can be devised and delivered to suit individual requirements – just ask for details.
Private Courses:
Private courses start from £3980 for up to 8 delegates
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.
Public Scheduled Dates:
Public scheduled prices per delegate. All prices +VAT
<
>
Private Courses:
Private courses start from £1690 for up to 8 delegates
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.
Private Courses:
Private courses start from £845 for up to 8 delegates
Overview:
This course is aimed at those new to PowerPoint, or who have limited knowledge of the package. During this course delegates will explore the PowerPoint environment and create presentations.
Delegates will format text on slides, add graphical objects to a presentation, modify objects on slides, add tables to a presentation, add charts to a presentation and prepare to deliver a presentation.
Public Scheduled Dates:
Public scheduled prices per delegate. All prices +VAT
<
>
Private Courses:
Private courses start from £645 for up to 8 delegates
Overview:
This course is aimed at those already familiar with PowerPoint. During this course delegates will go beyond using the standard layouts and designs offered by PowerPoint, to creating their own designs.
Delegates will integrate current design trends into their presentations to create modern but professional slides and learn some of the tricks and short-cut methods for doing so. You will create a presentation containing a variety of slide layouts which can used as a template for future presentations.
Public Scheduled Dates:
Public scheduled prices per delegate. All prices +VAT
Private Courses:
Private courses start from £645 for up to 8 delegates
Overview:
All of us, no matter how successful in our fields, will face adversity at some point in our careers. When the pressure is on, the difference between thriving or not is resilience.
This practical course will give you the tools and knowledge to live and work with less stress by developing your skills in dealing with frustration, anxiety and pressure in positive ways.
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.
You don't seem to have any favourites stored yet.
To add a favourite, please click on the heart next to any course in the course lists or in the right menu on a course page.
Please note if you delete your cookies, your favourites will disappear.
You don't seem to have any favourites stored yet.
To add a favourite, please click on the heart next to any course in the course lists or in the right menu on a course page.
Please note if you delete your cookies, your favourites will disappear.
"Loved the interactive group discussions/activities "
J.H. Alnwick Medical Group, Coaching and Mentoring
Which part of the course did you find particularly valuable
"Learning about the way the connections work with databases with ado etc.. "
M. William Smith, VBA Essentials using Access
"Set topics covered but also individual objectives discussed and actioned. Material in booklet useful to takeaway. "
A.A. Hill Cross Furniture, Introduction to Supervisory Management
"Clear and understandable "
S.W. Ballast Phoenix, Conflict Management
Which part of the course did you find particularly valuable
"The practical approach of trying every aspect whether I had already done it before or I was trying it for the first time. It was a safe space to make mistakes and a very encouraging environment. "
J.B. Tyne and Wear Pension Fund, PowerPoint Essentials
Which part of the course did you find particularly valuable
"The work with formulas and 'If Statements' is particularly valuable and useful as is how to protect the data, and Data Validation "
J.S. Yorwaste, Excel Level 2
"Very informative and presented well "
L.M. NHS South Tyneside, Excel Level 2
"Learned a lot from today's course that I can take into my workplace "
C.D. nissan nmuk, Excel Level 2
Which part of the course did you find particularly valuable
"It was all new skills for me, so I found the whole course valuable. "
D.W. Deepocean, Microsoft Project Essentials
Following this training what are you going to do differently
"I am going to be turning my spreadsheets into tables and naming them. I will also now be able to use the VLOOKUP function that i was previously struggling with. I am also definitely going to use the flash field function. "
B.C. , Excel Level 3
"Great course, easy to follow, would recommend "
B.M. Direct Rail Services, Excel Level 2
Any other comments or recommendations
"Enjoyable 2 days, not overbearing and very informative "
J.G. Benfield Park Medical Group, Stepping up to Management
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.
We provide Power courses in Newcastle, our Power 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 Power 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 Power in Newcastle, we can provide private, or onsite, courses for you in your location. One way or another, contact us to let us know how we can help or to book your courses.
Newcastle-Upon-Tyne, most commonly referred to as Newcastle, is the largest city in North East England and is situated in the county of Tyne-and-Wear. Newcastle is a culturally-rich city with deep roots in industry and enterprise, which leads to a diverse need for Power training. Professional Power courses are available throughout Newcastle as classroom-based and online virtual courses. Our principal training venue in Newcastle can be found in Clavering Place, which is only a few minutes' walk from Newcastle's Central Railway Station, Metro and major bus-links, as well as being within easy access of a host of on-street and public car parks.
However, with so many working remotely, we understand that a lot of people would prefer not to travel for training, therefore, we also provide tutor-led virtual Power courses. These courses can be attended from anywhere as they take place online using software such a Teams or Zoom. Don’t worry if you haven’t used these before, we walk you through the steps so that you’re ready and relaxed on the day. The choice is yours, for your Power training in Newcastle, you can choose to attend at our Newcastle venue or from the comfort of your own home, or anywhere else.
You can contact us on 0191 377 8377 to discuss your Power training in Newcastle, or use our online service to contact us.
Contact us online or call 0191 377 8377(Mon-Fri, 9am-5pm)
This site requires JavaScript - JavaScript is currently disabled on your device, please be aware that certain functionality may not work until you enable JavaScript.