3 Excel Hacks You need to know

There are so many Excel Hacks, picking 3 for this article was hard. Over the last 5 years, Excel has been developing at a rapid pace. New releases have seen some lovely goodies for everyone. Microsoft has added new features and functions. While they have also improved on some others. If you are a beginner […]

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 […]

Excel and Coinmarketcap – live cryptocurrency dashboard

Considering The Excel Club is the first Excel blog in the world to reward you with cryptocurrency when you take part in our learn and earn activities, I thought it was time I did an Excel post that touches on the very subject of Cryptocurrency. Excel has been used to track and chart data before […]

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 […]

beginner excel lessons

Excel 101 – Getting Started with Excel 365

Everyone must start somewhere and getting started with Excel 365 will be made easy with this massive article.  Grab your coffee and get ready to learn Excel in a practical way. If you have every wondered how to use an Excel Spreadsheet and how you can learn to use Excel quickly then you have come […]

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 […]

The Secret Power of SUMPRODUCT in Excel

SUMPRODUCT in Excel works by multiplying value pairs together and then adding the results together.  However, SUMPRODUCT is a function that accepts arrays, making it a very powerful function beyond its basic use. In this video, you will learn the secret power of SUMPRODUCT as we work through 5 different examples Basic traditional use SUMPRODUCT […]