วีดีโอ

In this second video in my two part series about Group By in Power Query, this video illustrates some of the ways in which you can work with the results of your Group By work. Group By is so simple to use but it provides some real insights into your data at the expense of little effort!

There is a GROUPBY() function in Excel ... not for everyone yet but you may have seen the videos announcing it. Here's some good news for those of us who haven't got access to GROUPBY(), yet: Power Query has it and this video introduces you to it. This video is part one of a two part series and it is aimed at showing you how to use Group By in Power Query. In part two you will explore some of t...

Apology: there is a pause at 0:38 and again at 7:18. Just press play again to continue. In this video I open by reminding you of an earlier video I did about the BYCOL() and BYROW() functions and I introduce the CHOOSECOLS() function. Having done that, I mention that this combination of functions failed when I was analysing the OWID COVID data file from One World in Data. The rest of this short...

You might have been using the tREND() function for years without realising that not only will it create Ordinary Least Squares results and predictions but we can use it to create multiple regression analyses, too. This video takes you through the process of creating OLS results as well as multiple regression results. You will also how to use TREND() in the context of training and testing of you...

Creating volatile correlation matrices in Excel using Excel Tables and Range Names. I would say the formula driven matrices are good but the Excel Table driven matrices are better. The range name version is a less complex to look at than the formula based version but I would say they are eually good! Download my new Excel file from here: docs.google.com/spreadsheets/d/1KgPUqJNJvEm69v2OLxYyZ9Cg6...

This video shows you how to automatically create a correlation matrix in Excel

The Data Analysis ToolPak will create a correlation matrix very easily but it has one major flaw: it is static and that means, if ever you update your input data, you've got to run the correlation matrix utility in the ToolPak again. Not any more! Just watch how simple it is to create a formul that will feed your correlation matrix: no matter what size, no matter how many variables

The finale of the New Year's Eve fireworks display as seen from the beach at Hua Hin, Thailand

I am demonstrating two approaches to the creation of a payment schedule: Both approaches give the same, correct, answer and if we update any of the data, they will both continue to generate the right answer. However, consider the effort involved in the original, complex, single cell solution formula and the time it would probably take most of us to generate. Consider also, the likelihood of mak...

Of all of the latest functions that have been released by Excel over the last two years or so, BYCOL and ByROW are turning out to be among the easiest and best to apply. In this video, I show you how to use the BYCOL function to create a table of Descriptive Statistics that is significantly better then the equivalent table that is produced by the Data Analysis ToolPak: it is not messy it is dyn...

Accountants are more than used to the matrix style of the presentation of data and that is how I have spent my career … working with data matrices The purpose of this demonstration is to combine the notion of data layout with that of ease of creation of formulas to work with the data You can download my Excel file to see how I did what I did. drive.google.com/drive/folders/1V-IZ8eQwif38ESrXM7ej...

If you flatten a learning curve it means you forget, your get slower and slower. In this video I show what really happens to a learning curve when your learning rate increases ... it gets steeper!

This is video 2 in a 2 video series in which I review and analyse the European Fortune 500 2023 dataset. This video is essentially in two parts and in part one, I show you how to use the FILTER() function, among other functions, to analyse the financial ratios that I have extracted from the data. Average, Maximum, Minimum and Standard Deviation. In part two of this video, starting at 8 minutes ...

This is the first video in a two part series in which I use the FILTER() function for multiple regression analysis based on a variable that contains a different number of rows of data according to your selection Video two is here: th-cam.com/video/oiIgOwRlWGc/w-d-xo.html

Filtering a Pivot Table but Keeping % of Column Totals the Same

Anomaly Detection in Excel and in Power BI

New Excel Add IN: BusinessAssist Forecasting

VSTACK Function Video 2

Ratio Analysis Using Excel's VSTACK Function

Duncan works on the Collatz conjecture in excel

How to Create a Football Field Chart ... Properly

Cleaning and Reorganising a Vertical List Downloaded from the Web

The Rule of 72 in Investing

Clean Data and Sort Column Headers from Left To Right in Power Query and in Excel

Timing of an Electric Kettle 2/2

Timing of an Electric Kettle 1/2

Solving a Date Problem in Power BI

Company Analysis Part 2

Company Analysis Part 1