Pivot Tables are a core tool in Excel used to quickly analyze large, or small, sets of data. Yet many Excel users have a fear of Pivot Tables as they are often viewed as a more advanced tool. I would argue

In the video above you will learn how to create this Excel Cryptocurrency Portfolio tracker.  This tracker is ideal for holders and hodlers and it will allow you to track all of your coin holdings in one

Last week I had the pleasure of entering an Interactive Excel Dashboard to the Excel Hash 2021 challenge set by Oz de Soleil.  It was massive fun and it was awesome to pitch myself up against some of the

Unix Timestamp conversions in Excel and in Power query are becoming more and more common.  With the ability to connect to a vast variety of data sources, the likelihood of you coming across a Unix timestamp

Why you need more Excel Superstars!! For a long time now, I have been helping you become an awesome Excel user. Here at The Excel Club we produce educational articles and videos and the sole aim has been

Copying worksheets in Excel is a common task.  It provides massive time savings by allowing you to use the content of the worksheet over and over without the need to regenerate the formulas or the formatting.

Do you fancy a bit of an Excel Data Challenge?  Something to get you thinking creatively with your Excel Skills?  Well, I have this problem that requires a multiple column match in Excel to look up and

Do you fancy a bit of an Excel Data Challenge?  Something to get you thinking creatively with your Excel Skills?  Well, I have this problem that requires a multiple column match in Excel to look up and

Do you fancy a bit of an Excel Data Challenge?  Something to get you thinking creatively with your Excel Skills?  Well, I have this problem that requires a multiple column match in Excel to look up and

Do you fancy a bit of an Excel Data Challenge?  Something to get you thinking creatively with your Excel Skills?  Well, I have this problem that requires a multiple column match in Excel to look up and

Learn how to fix totals and subtotals in DAX for PowerBI and Power Pivot The problem of incorrect totals and subtotals in DAX is a common problem for both Power BI and Power Pivot users. But these incorrect

Often there are times when a spreadsheet developer has the need to set the screen scroll lock area in Excel restricting where the user can scroll and has visibility. A perfect example would be Excel

Why Document an Entire Excel Workbook You already know the story.... or do you…..? So the internal accountant produces a monthly pack for management, which contains financial information. These reports

Finding hard-coded values within Excel Formulas is something Excel users have struggled with for a long time. While I was researching this article, I am surprised that the solution I am about to offer

Hidden and Very Hidden Sheets in Excel - Skip to Video As most of us know, Excel, being such an amazing tool, gives us the ability to Hide sheets from view.  However, what many are not aware of is that

Transposing Data and Converting Text to Columns can be done quickly in Excel. Having the ability to do so, will save you time when you have these types of tasks to complete. When you are starting out in

Using the Coinmarketcap API, you can quickly get live ticker information into your Excel spreadsheet for your favorite cryptocurrency. With the free API that is available, in this article we will look

If there is one piece of advice, I could give to DAX users, it would be to keep the structure of the model simple.  That includes flattening or converting from a snowflake to a star. Take a look at this. Its

Hay Paula, can you compare lists in Excel? or What is the best way to compare two sets of data in Excel? Very often there is a requirement in Excel to compare two lists, or two data sets to find missing

If you are familiar with the MATCH function in Excel then you are going to love XMATCH.  Just like the MATCH function XMATCH returns a relative position in a list. Now you are familiar XLOOKUP, which replaces