Calculate 50 & 100-Day Moving Average with DAX

Following on from last weeks post, Connecting Excel to Coinmarketcap data for live ticker information and historic pricing, I thought I would share with you some basic indicators that you can add to your Excel Cryptocurrency Dashboard.  This week we are going to look at calculating 50 and 100-day moving averages using DAX In the […]

Encrypt and Decrypt Caeser Cipher in Excel using Power Query

Over the last few months, I have found myself interested in cryptography. Cryptography is the art of writing and solving clues. Often solving clues involves decrypting some sort of hidden message. Encrypting and decrypting messages is a lot of fun. A cipher is a series of steps taken to encrypt or decrypt a message that […]

PowerPivot – Inserting and working with Pivot tables

PowerPivot allows you to pivot columns of data from different tables and sources against each other. You may recall when creating pivot tables in standard Excel, one would often use Vlookups to pull all the data into one table and then create a pivot table.  This is no longer needed with PowerPivot because all the […]

Finding Your Way around Power Pivot – An Orientation

When you see Power Pivot for the first time it can be confusing.  It’s a new interface, with new ribbons and views.  Before you start working with tables of data and complex models, you need to get comfortable with the user interface.  In this article, we will take a look around Power Pivots user interface […]

How to Reconcile Accounts using Power Query

How to Reconcile Accounts using Power Query! What? Did I hear you right? Reconciling accounts is a common task carried out by accountants on a regular and reoccurring basis.  Creditor statements and bank accounts are examples of accounts that need regular reconciliation. But what if you could create a model, within minutes, that you could […]

Excel Power Tools – The Future of Excel

For years now Accountants and bookkeepers around the globe have used Excel as their Spreadsheet  tool of choice.  It offers massive flexibility, speed and is as accurate and reliable as the users. But to this day, some Excel users never go beyond the basic totting and cross totting of rows and columns. Excel has come […]

DAX SUM and SUMX functions

DAX SUM and SUMX Functions

BEST SELLING COURSE The role of both DAX SUM and SUMX functions is to add numerical data together. Yet both these functions are rather different. Let’s talk about the SUM function first. The SUM function is simple. It takes a column of data and adds the values to give a total. It works like the […]

How to Parse Custom JSON Data using Excel

How to Parse Custom JSON Data using Excel

To Parse Custom JSON data is to split out its name/value pairs into a more readable useable format. Excel is a powerful tool that allows you to connect to JSON data and read it.  However sometimes this data might require a little manipulation to be fully understood and analysed in Excel.  In this article you […]

Decoding M – Exploring the YouTube Data API with Power BI

For some time now I have wanted to explore connecting Power BI with API’s, however the lack of knowledge of M, and time has held me back. But this week I got a chance to dig a little deeper with my idea. I decided to look at Google’s YouTube Data API.  First I just want […]

Excel pimped with power

Excel Pimped with Power Tools

Excel is one of those tools that you just can’t live without.  It is used to store information, run calculations, carry out analysis, prepare report, visualizations and much more.  What’s just as important is the flexibility it gives to its +750 millions of users. This flexibility allows users create their own calculations and analysis, in […]