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 […]
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 […]
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 […]
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 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 […]
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 […]
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! 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 […]
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 […]
There is value in learning. Earn tokens while you learn Excel, PowerBI and DAX today. Only here with The Excel Club