Courses

With Data Skills, you are assured of learning from highly skilled, experienced trainers who teach practical skills that make a difference in the workplace!

Excel Courses

Introduction to Excel Pivot Tables

Excel pivot tables offer users the ability to rapidly analyse large volumes of data in an easy-to-use format.

If you deal with data in Excel and don’t use Pivot Tables, you definitely need to do this course!

In this course you will learn to:

  • Prepare your data for analysis
  • Build pivot tables
  • Format pivot tables
  • Aggregate your data in different ways
  • Group your data
  • Work with dates
  • Filter your data
  • Use slicers
  • Build a basic dashboard using pivot tables

Duration: 1 day

Cost: £40 plus £200 per delegate (EX VAT) Terms apply

Advanced Excel Pivot Tables

Take your Excel Pivot Tables to the next level! This course is intended to show you advanced features of Pivot Tables and Pivot Charts. In this course, you will learn to:

  • Use tables effectively for your data sources
  • Perform advanced calculations on your data
  • Create new fields
  • Build pivot charts
  • Apply conditional formatting to your pivot tables
  • Build a sophisticated & interactive dashboard

Duration: 1 day

Cost: £40 plus £200 per delegate (EX VAT) Terms apply

Excel Power Query

Have you ever noticed the “Get Data” menu option on the Data tab in Excel? If not, you have missed out on a simply incredible load & transform tool built into Excel called Power Query! With Power Query, you can pull data from various source, split or combine columns, merge datasets, define data types and much more. In this course, you will learn to:

  • Benefits of using power query
  • How to launch Power Query and the Query Editor
  • Loading data into Power Query
  • Filtering & modifying data
  • Calculating custom fields
  • Merging data
  • Consolidating data sources with merge
  • Appending data
  • Creating custom calculations using M Code
  • Using the group function
  • Loading CSV & Online data into Power Pivot

Duration: 1 day

Cost: £40 plus £200 per delegate (EX VAT) Terms apply

Excel Power Pivot

One of Excel’s newer features is the amazing Power Pivot module. If you are working with data in Excel, Power Pivot could be the most amazing tool you’ve learned about in 10 years! In this course, you will learn to:

  • Activate Power Pivot in Excel
  • Load data into Power Pivot
  • Browse filter and sort data in Power Pivot
  • Build measures in Power Pivot
  • Create PivotTables from your new Power Pivot data source
  • Create hierarchies in Power Pivot
  • Use the incredible DAX language to build new fields
  • Build relationships between related data sets
  • Create named sets
  • Create KPIs

Duration: 1 day

Cost: £40 plus £200 per delegate (EX VAT) Terms apply

Power BI Courses

Microsoft’s amazing Power BI tool makes business intelligence a breeze! Build mind-blowing interactive dashboards, bringing together data from various sources with just a few clicks of the mouse!

Introduction to Power BI

Get a solid introduction to this fantastic product with our 2-day introductory course. This is ideal for someone with limited or no knowledge of Power BI. In this course you will learn:

  • Signing into Power BI
  • Using the Power BI Desktop
  • Creating a basic report
  • Aggregation methods
  • Tables & Cards
  • Filtering Data
  • Visualisations
  • Graph options
  • Trend Analysis
  • Using Power Query
  • Transforming Data
  • DAX
  • Measures
  • Creating a dashboard
  • Publishing a report
  • Mobile view of your report
  • Power BI with Excel

Duration: 2 days

Cost: £100 plus £350 per delegate (EX VAT) Terms apply

Add a testimonial from someone who loves your services. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin id arcu aliquet, elementum nisi quis, condimentum nibh. Donec hendrerit dui ut nisi tempor scelerisque.

— Jane Doe

Add a testimonial from someone who loves your services. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin id arcu aliquet, elementum nisi quis, condimentum nibh. Donec hendrerit dui ut nisi tempor scelerisque.

— Jane Doe