Computer Tutoring Logo

Cost Calculator

Training delivery
Number of students?
Laptop hire?
Offsite training?

Course price: £ *
Price per head:
£ .

Duration:
1 Days

* Price is exclusive of VAT.

Tell Me More






First NumberPlusSecond Number  = 

Please enter the answer to prove that you are human and not a machine.

Excel training testimonials from Kensington

Private

"Very efficient Very clear and easy to understand Simon was very accommodating in showing us functions outside the day course Easy to follow instructions Lovely lunch and snacks. Simon and Cindy are really pleasant and lovely people, I left with the feeling that I had learnt a lot Mission accomplished!"

Microsoft Excel Power BI Training Course - Beginners Training in Kensington

Kensington Beginners Microsoft Excel Power BI Course Overview

Microsoft Excel Power BI Training Course Beginners training in Kensington

Kensington is a strong location for businesses and individuals looking for high-quality, instructor-led Microsoft Excel Power BI Training Course training in a well-connected part of London.

The venue provides a focused setting for reporting and analytics training, giving delegates time to work through dashboards, calculations and data models in a structured way.

We can often deliver the course at your premises, and where needed we can provide laptops, course materials and other equipment to support the session. This is particularly helpful for teams building reporting skills or working with larger datasets.

Beyond this course, you can also browse our computer training courses in Kensington.

Kensington is well known for its museums, business activity and central location.


Microsoft Excel Power BI training for Kensington teams

We can deliver Microsoft Excel Power BI Beginners training for organisations in Kensington and nearby areas such as Chelsea, Westminster, Hammersmith, Fulham, Notting Hill and central London. Sessions can be run live online, at your premises, or at a local training venue where that suits your team better.

Access and venue details

Kensington is useful for central and West London organisations that need a well-connected training location, with the option to train at your premises where that is more convenient.

Local training use cases

Microsoft Excel Power BI training in Kensington is useful for teams who want skills they can apply quickly in real work. The venue provides a focused setting for reporting and analytics training, giving delegates time to work through dashboards, calculations and data models in a structured way. This is particularly helpful for teams building reporting skills or working with larger datasets. It suits users who need practical experience with business reporting and data analysis.

If you need Power BI training in Kensington at beginners level, this page gives you a location-specific overview of the course. This is particularly helpful for teams building reporting skills or working with larger datasets. It suits users who need practical experience with business reporting and data analysis.

A Power BI training course is essential to understand how to use this powerful self service data analysis tool effectively. Being able to handle the onslaught of data we receive in todays world can make or break your business. In fact, getting any specific, meaningful answers from the data is difficult. Presenting that data in a manner simple to understand for various people is nearly impossible.

On completion of the course the delegates will be able to:

  • Use Excel to produce interactive Charts and Visualisations that can be easily shared
  • Organise and Analyse vast amounts of data with ease
  • Create Interactive Dashboards
  • Learn how to use the Power BI Web Service to share these reports with others

There is an update to this Power BI beginners training course.

The details for the course are below:

Microsoft Power BI Beginners Training Course is an update to this course.

Course Duration: 1 Days

Complete Course Outline

Introduction to Excel Power BI

  • Business Analysis
  • Installing Power BI
  • Check your version of Office

Getting Data

  • Excel

Creating Calculated Columns

  • Concatenation
  • Date Formulas

Visualisations with Power BI

  • Formatting Visualisations
  • Adding a Slicer
  • Sorting the Month Order Problem
  • Multiple Labels on Axis
  • Drilling Down
  • Creating Hierarchies - Multiple Labels on the same Axis
  • When to use a Tree Map

Filters

  • Adding Arrows and Comments

Edit Interactions

Calendar Table

Relationships and Keys

  • Showing Rows with no Data
  • Using Excel Tables

Laying out a Page

DAX

  • YTD - Year to Date
  • Previous Year
  • HASONEVALUE
  • The Process of RANKING

Importing Visualisations

  • Importing Custom Visual from the Web
  • Timeline Slicer Visualisation

Publishing

  • Signing in

Navigating Online Power BI

  • Pinning Dashboards
  • Asking Questions of your Data
  • Custom Q&A Questions
  • Removing a Visualisation from the Dashboard

Insights

  • Importing Custom Visuals

Power Query

  • Removing Errors
  • Applied Steps
  • Removing the Rows Entirely
  • Custom Columns and Try
  • Adding an Index Column

This course is suitable for those using Microsoft Office 365 (O365).

Microsoft Excel Power BI training is also available for online training via Zoom or Teams.

All you need to know about our Live Online Training.

Live Online Training

Comprehensive coverage of DAX is covered in our Power BI DAX Training Course where we cover more of the functions in Detail, including the Calculate function and multiple time analysis functions.


One other course you might be interested in taking in conjunction with this would be the SQL Server Fundamentals course. By taking this course you will be able to either:

  1. Prepare your data before loading into Power BI
  2. Type SQL directly into Power BI.

Microsoft SharePoint 365 Training Course Beginners

Microsoft Excel 2016 Training Course Advanced

Microsoft Excel 2016 Training Course Intermediate

Microsoft Excel Pivot Tables Training Course Beginners

Keep yourself updated with our Free Power BI Training

Location FAQs for Kensington

Where can this training take place in Kensington?

We can deliver this Power BI training at your premises in or around Kensington, live online, or at a suitable local training venue if you would prefer an external location.

Can you come to our office in Kensington?

Yes. We regularly deliver on-site training for teams in Kensington and can usually tailor the session to your team, your documents and the way you work.

Excel training centres near Kensington

If Kensington is not the most convenient option, we can also arrange instructor-led Excel training at nearby Computer Tutoring training centres.