What our Students say

“This course is excellent. The skills I have developed have given me the confidence to tackle advanced problems in an Investment Banking environment. Unlike other courses, the tutorials are practical, to the point and are relevant to professionals. I would highly recommend this course.”

Revin Melanis

Investment Banking PMO, London

“The VBA course has been a game changer as the ability to automate was something I longed for in order to be more efficient and more effective as a professional. This course is the complete package, I would recommend this course 100%”

Mike Doubek

InProject Manager, United Stated

“I applied many of the skills I learnt through your Excel course to automate many aspects of my work and it has been a huge help. My next step is to improve my VBA skills!”

Kiran Arian

Senior Financial Adviser, Canada

Frequently Asked Questions

ARE YOUR COURSES ACCREDITED?

Yes, for all of our technical skills courses, upon completion you will receive a downloadable certificate which has been accredited by the CPD (Continuing Professional Development), which is one of the UK's top accreditors for professional education. What makes the CPD so great is that the training you undertake with us counts towards any other professional qualifications you are doing such as Accountancy. The certificates can be added to your LinkedIn profile and listed on your CV/Resume.

HOW DO YOU DELIVER YOUR COURSES?

Once you have signed up then we will send you an email with a link to access our training dashboard, you can access all of our courses from this dashboard. All courses consist of video lessons that can be viewed on your device of choice and also to truly enhance your learning you will access to lots of exercise files relevant to the lessons.

THERE ARE MANY OPTIONS THESE DAYS TO LEARN, WHY GO WITH YOUR COURSES?

Great question, well frankly we make the best courses because all of our trainers have spent 10+ years using these skills in the real world! True knowledge is passed on from people who have been in the trenches, putting in long hours, solving real problems creatively. Our mission is to empower you with the very best of what works and more importantly, leave out what is unnecessary and thus a waste of your precious time.

HOW LONG WILL IT TAKE TO LEARN THESE SKILLS?

It depends on your level of commitment. Our students have seen incredible results from as little as 30 mins a day. But remember the magic is in applying the skills as much as learning them. Our courses are designed with this in mind. On the very practical end we have students who squeeze in a few mins here and there on their commute and some do dedicated 2-3 hour weekend sessions. Don't feel like you need to be in a hurry, you have lifetime access!

CAN MY EMPLOYER PAY FOR MY TRAINING?

Yes, we do, we will dust it off if you need it because it rarely happens! You have 30 days to let us know that the training isn’t right for you and we will happily refund.

DO YOU HAVE A REFUND POLICY?

Yes, this is quite common since we focus on helping actual corporate employees. Note that for teams we offer bulk discounts. However, this needs to be done with a corporate credit/debit card. We don’t accept transfer/remittances. Get in touch if you have any specific questions.

Pivot Tables

Some of the Companies Our Students Work At

We are accredited by the CPD Standards Office

Microsoft Data Analytics Tools can propel your career... Are you ready to master them?

Get Lifetime Access to 9 Data Courses
Accredited Certifications from the CPD
Our 100,000+ Students swear by our courses!

Get Lifetime Access Today

For Just $277

$138.50

There’s 35+ Hours of Video Training Split Over 250 + Lessons Just Waiting For You To Take Your Skills And Productivity To The Next Level!

Get Lifetime Access Today

For Just $277

$138.50

Power Query Course

Power Pivot Course

Google Analytics Course

Power BI Course

Power BI: Advanced Course

Access Course

SQL Server Course

Marketing Analytics with Google Data Studio Course

You will get access to the following suite of Data courses

Vasilis, UK

Kiran, Canada

Watch and listen to student testimonials

The 18 Year Trend for 'Data Analytics' shows the rise of this skillset

A Job Search for key Microsoft Data Skills shows huge career potential

Marcel, Australia

Paul, Nigeria

Power Pivot Course

PowerPivot helps you to deal with large volumes of data without resorting to the use of a Database. Ross Hughes shows you how to use PowerPivot to manage large volumes of data (Up to 1 million+ rows) with ease. You will learn about Data Modelling, DAX formulas, Measures and KPIs.

MODULE 6: DEEPER INTO DAX

6.1 DAX Syntax and Operators

6.2 Some Useful DAX Functions part 1

6.3 Some Useful DAX Functions part 2

6.4 Some Useful DAX Functions part 3

6.5 Introduction to Iterator Functions

6.6 Expressions in Iterator Functions

6.7 Table functions in Iterator Functions (RELATEDTABLE)

6.8 Table functions in Iterator Functions (TOPN)

6.9 Other Iterator Functions

6.10 Introduction to Context

6.11 Examples of Context

6.12 Filter Context in Pivot Tables

6.13 Introduction to Filter Functions

6.14 Example of a Filter Function

6.15 Using Filters in a Filter Function

6.16 Using the ALL Filter Function

6.17 Using the ALLSELECTED Filter Function

6.18 Introduction to Parent-Child Functions

6.19 Using Parent-Child Functions

6.20 Using Parent-Child Functions for a Hierarchy

6.21 Time Intelligence Functions Part 1

6.22 Time Intelligence Functions Part 2

6.23 Time Intelligence Functions Part 3

6.24 Time Intelligence Functions Part 4

Course Curriculum

MODULE 1: GETTING STARTED WITH POWER PIVOT

1.1 Introduction to Power Pivot

1.2 Data Model Familiarisation

1.3 Data Modelling Concepts

1.4 Introduction to Data Types

MODULE 2: LOADING DATA

2.1 Loading data with PowerQuery

2.2 Loading Data from Excel tables

2.3 Introduction to using with Pivot Tables

2.4 Other data load options

2.5 Loading Data from an external database

MODULE 3: PIVOT TABLES AND REFRESH

3.1 More on Pivot Tables

3.2 Pivot Tables and Relationships

3.3 Introduction to Refreshing Data

3.4 Refreshing Data via Connections

3.5 Refreshing Data from an external database

MODULE 4: INTRODUCTION TO MEASURES

4.1 Calculated Columns

4.2 Introduction to measures

4.3 Adding explicit measures with Autosum

4.4 Adding implicit measures

4.5 Adding explicit measures in Power Pivot menu

MODULE 5: HIERARCHIES AND RELATED COLUMNS

5.1 Introduction

5.2 Adding a hierarchy

5.3 Using hierarchies in a Pivot Table

5.4 Drill paths

5.5 Introduction to Related Columns

5.6 Related Columns in a hierarchy

5.7 Best practices with hierarchies

5.8 Editing hierarchies

Power BI Course

Power BI is Microsoft’s play into the growing Business Intelligence reporting space, and they have created an incredible tool worthy of your attention. If your reporting requirements are more serious, that is you work with larger volumes of data, your data updates frequently, you create external facing reports/dashboards and need to share/publish your data online or via company intranets then Power BI may be your best option for building robust MI. We asked highly experienced BI Consultant, Andrew Ward to create this course and to bring you to an intermediate level of expertise. Andrew will guide you step by step and help you to create high value dashboards and reports by the end of this course

MODULE 1: INTRODUCTION TO POWER BI

1.1 The Power BI Interface

1.2 The Three main views in Power BI

1.3 Getting Familiar with Power BI

MODULE 2: WORKING WITH DATA IN POWER BI

2.1 Connecting to Excel Data

2.2 Getting familiar with Power Query

2.3 Building & Cleaning a Date Table

MODULE 3: DATA ANALYSIS WITH POWER BI

3.1 Understanding relationships

3.2 Introduction to calculations

3.3 Working with measures

3.4 Measure for total profit

3.5 Measure for previous year profit

3.6 Using a slicer to filter dates

MODULE 4: POWER BI DASHBOARDS

4.1 Sales Summary: Dashboard set up

4.2 Sales Summary: Line Chart

4.3 Sales Summary: Donut Chart

4.4 Sales Summary: Optional-More Donut Charts

4.5 Profit Summary: Tweaking an Existing Dashboard

4.6 Geography Summary: Introduction

4.7 Geography Summary: Stacked Bar Chart

4.8 Geography Summary: Maps

4.9 Product Summary: Introduction

4.1 Product Summary: Scatter Plot

4.11 Product Summary: Tree Diagram

4.12 Employee Summary: Introduction

4.13 Employee Summary: Stacked Column Chart

4.14 Employee Summary: Combination Chart

4.15 Employee Summary: Waterfall Chart

4.16 Employee Summary: OPTIONAL- Donut Chart

Course Curriculum

MODULE 5: SHARING AND PUBLISHING POWER BI

5.1 Introduction to Sharing & Publishing Dashboards

5.2 Building Dashboards in Myworkspace

5.3 Refreshing Data sources

5.4 The benefits of reports

5.5 Pinning a Dashboard

5.6 Sharing your Dashboard

5.7 The Power BI Community

5.8 Outro and next steps

Microsoft Access Course

Access has been around for over two decades and it’s not going anywhere due to it’s ability to be ‘up and running’ very quickly! Sure, big companies like big databases that serve the company needs on an enterprise level but the value of access is about what can be done at a local level, in small teams and on smaller or temporary projects.

For example if you are working in a small company and you want to be able to manage your data whether that be some kind of sales data, expenses, marketing information or project focus data and you need to get up and running quickly with a database to handle it, well Access is definitely the tool for you. You can be up and running in an afternoon with no need to get IT permissions or ask for a big budget! That’s why Access is known as a self-serving or end-user tool.

Given that is how Access is now used we have built a course with exactly that in mind, to teach you how to use Access for it to be a great end-user tool that you can get up and running quickly but also give your Database more advanced capability if you wish to.

In order to build the right course for you, we worked with Guy Vaccaro, who has been building Databases, including Access Databases for over two decades. Rather than build an unnecessarily long training, Guy has condensed his two decades of mastery in under 6.5 very focused hours, not learning unnecessary functionality so you can get up and running and maintaining your database in a very quick time frame!

MODULE 1: CREATING TABLES

1.1 Creating and saving a table in design mode in Access including best practice with regard to naming conventions for Access objects and fields within tables and the correct choice of datatype.

1.2 The Primary Key: the why and the How

1.3 Some important field properties: Default values, masks, caption, Required and validation rules

MODULE 2: CREATING QUERIES

2.1 The Select query- mechanics, reasons and saving

2.2 Filtering and sorting records in a Select Query using Numeric and Date fields

2.3 Filtering and sorting records in a Select Query using Text fields and wildcards

2.4 Adding a Calculated field to a Query

MODULE 3: ACTION QUERIES

3.1 Adding pop up parameters to queries

MODULE 4: LINKING TABLES

4.1 Two reasons for a Relational Database

4.2 Creating links between tables

4.3 Multiple table Queries

MODULE 5: CREATING FORMS

5.1 Creating a Form using the Wizard

5.2 Creating and editing a Form WITHOUT the Wizard

5.3 The Clever ComboBox record finder

MODULE 6: CREATING SUBFORMS

6.1 Forms within forms in a Relational Database

6.2 Subforms based on Query Data

MODULE 7: CREATING SPLITFORMS

7.1 Use of the Split Form features

MODULE 8: CREATING REPORTS

8.1 Create a Report with the Wizard

8.2 Create a Report from Scratch and add Special Fields

8.3 Grouping with Reports

MODULE 9: EXPORTING DATA

9.1 Export data into Excel

9.2 Export a Report to Word or PDF

MODULE 10: IMPORTING DATA

10.1 Import from Excel – or Link to an Excel Sheet

10.2 Use of Paste Append

10.3 Import an Access table from another Database

10.4 Create a Mail Merge in Word using data from Access

10.5 Mail merging in Word using data from Excel

MODULE 11: BUILDING VBA/MACROS

11.1 Introduction to Access Macros

11.2 Introduction to Events in Access using VBA

11.3 Create a Form with Buttons to open/close other objects

11.4 Refresh the data in one combo box when another combo box is changed

11.5 Decide on a course of action based on user input

11.6 Using VBA to connect Access to a SQL Server backend database

11.7 The special AUTOEXEC macro

Course Curriculum

Ultimate Pivot Tables Course

For some people that work with Excel, Pivot Tables present a great opportunity to seamlessly deal with Data analysis and reporting. The training has been created by our founder in conjunction with highly experienced corporate analysts who use Pivot Tables on a daily basis in a corporate environment and at just over two hours you will be using this training immediately.

MODULE 1: INTRODUCTION & DATA PREPARATION

1.1.Pivot Intro

1.2.Pivot Cache

1.3. Altering the Data Source

1.4. Unpivot data to a long boring list

1.5. Moving row and column

1.6. Expand and Collapse field

MODULE 2: LAYOUT AND FORMATS

2.1 Format Error and Empty cells

2.2 Change Layout of Pivot Table

2.3 Place Pivot Table

2.4 Pivot Table Styles

2.5 Format Content in Pivot

MODULE 3: CORE PIVOT TABLE ANALYSIS

3.1 Summarise Value by

3.2 Multiple Subtotal

3.3 Percentage of column total

3.4 Difference From value as percentage

3.5 Double click for detail

3.6 Running Total

3.7 Grouping Year Month Quarter

3.8 Sorting

MODULE 4: FILTERS AND SLICERS

4.1 Filtering – Part 1

4.2 Filtering – Part 2

4.3 Slicer – Insert Style Property

4.4 One Slicer connected to Multiple Pivots

4.5 Timeline Slicer

MODULE 5: ADVANCED ANALYSIS

5.1 Calculated Field

5.2 Link Multiple Table into One Pivot – Part 1

5.3 Link Multiple Table into One Pivot – Part 2

5.4 Calculated Field with IF statement

MODULE 6: VISUALS AND REPORTS

6.1 Conditional Formatting in Pivot – Part 1

6.2 Conditional Formatting in Pivot – Part 2

6.3 PivotCharts Part 1

6.4 PivotCharts Part 2 – Linking and Slicers

6.5 PivotCharts Part 3 – Formatting

6.6 Dashboard 1 – What we will build

6.7 Dashboard 2 – Our Dataset

6.8 Dashboard 3 – Pie Chart

6.9 Dashboard 4 – Line Chart

6.10 Dashboard 5 – Bar Chart

6.11 Dashboard 6 – Map Chart

6.12 Dashboard 7 – Putting it all together

6.13 Outro

Course Curriculum