Duncan's Diurnal Diatribe
My personal and my business blog
Pages
(Move to ...)
Split Columns in Power Query 2
Spider Graph
SplitColumns in Power Query
NPV Sensitivity Analysis
Better Graphic
Guru Series
Meteor Crater, Arizona
Analysis of World Cup 2022 Squads
New CheckBoxes in Excel
Edward Lear
Database Functions in Excel
Fan Chart: Python in Excel
TREND(), LINEST(), FILTER(), CHOOSECOLS(), OFFSET()
Excel365 For Beginners
Macro Based Analysis of BMW Financial Data
Outliers Book
Analysis of the Flights of Five International Airlines
Home
▼
Analysis
(Move to ...)
Deaths by Risk Factor
Reading Values from a Graph
Analysis of World Cup 2022 Squads
Group By Function in Power Query
Group By Function in Power Query Part Two
Correlation Analysis
Automatic Correlation Matrix
Automatic Correlation Matrices Part 2
Company Analysis Videos
Timing an Electric Kettle
The Rule of 72 in Investing
Data Analysis
Data Analysis: UK covid-19
Dynamic Array Functions Example
Depreciation and Dynamic Array Functions
Burnley FC: analysis of their accounts
Better Forecasting ... the REAL Way
Stats Video
Athletes Banned for Doping
Heteroskedasticity
Autocorrelation
Logit Regression
▼
Functions in Excel
(Move to ...)
Guru Series
REGEXTRACT Function in Excel
Database Functions in Excel
Fan Chart: Python in Excel
TREND(), LINEST(), FILTER(), CHOOSECOLS(), OFFSET()
My First LAMBDA()
The TREND() Function in Excel
Applying the BYCOL and BYROW Functions in Excel
VSTACK Function in Excel
Splitting a Cell in Excel
Matching Cells in a Range
Clean Data and Sort Columns Left to Right
OR Condition with SUMIFS()
Combining Text in Excel
Randomly Assign Participants in Excel
Is there a way to combine words and values in a cell in Excel?
NPV() and PV() Functions
Range Names & Intersection
Use FILTER() Instead of a Pivot Table
FILTER() With Multiple Tables
OFFSET with Dynamic Arrays
STOCKHISTORY Function
▼
Charts
(Move to ...)
Home
Spider Graph
Z Charts and COVID
Learning Curves
Jitter Charts
Dumbbell Chart in R
A Rubbish Graph
Small Multiples in Excel
Small Multiples in Power BI
Histogram in Power BI
▼
Menu
(Move to ...)
Split Columns in Power Query 2
NPV Sensitivity Analysis
Meteor Crater, Arizona
Analysis of World Cup 2022 Squads
Learning Curves
Payment Schedule: two approaches
Applying the BYCOL and BYROW Functions in Excel
Splitting a Cell in Excel
Matching Cells in a Range
Remove Data Validation from a cell in Excel
Vincent Kompany and the Burnley FC Striker Strategy
Unique Random Number Generation
Anomalies in Power BI
Three YouTube Videos
Sum of the Year's Digits
Excel File 4.7 million Rows Deep: Power Pivot Can Cope
What is this Excel Magic?
Colour Blindness
Calculate your Age in Power Query
Create a Data Type
Data Type Formulas
GRIDLETS in Excel
Pivot Table from Connection Only
UK Stamp Duty on Properties
How to use an Unpivoted Correlation Matrix: Part One
How to use an Unpivoted Correlation Matrix: Part Two
Excel to PowerPoint
Exponential
OFFSET with Dynamic Arrays
Pesky Dates
Interest Proportions and Dynamic Arrays
RANDARRAY() Function
GESTEP Function
Data From Text
Append Query Excel II
Append Query Excel
Long Equation in Excel
How does the MIRR Really Work?
Z Charts and COVID-19
Gantt Chart with Coloured Bars
Pivot Table for a Connection Only Query?
[Data.Format.Error]
Percentages Disappeared from Power Query
Sparklines with the Camera Tool
Sort Pivot Table Using Two Columns
Infinite Monkey or Porky Pie
Using Gantt Charts to Provide Information
Accessibility in Excel
Dirty Data ... Solved
XOR Function
Nested IF, IFS and CHOOSE
▼
7.5.14
Bookkeeping Book
my latest book has been published now:
‹
›
Home
View web version
