Login
Discover
Waves
Decks
Plus
Login
Signup
The Excel Club
@theexcelclub
67
Learn Microsoft Excel and Power BI
Followers
402
Following
3
Resource Credits
Available
Used
Website
https://theexcelclub.com/
Created
June 2, 2018
RSS Feed
Subscribe
Posts
Blog
Posts
Comments
Communities
Wallet
theexcelclub
excel
2021-03-23 05:30
Master Pivot Tables with these 8 How-to Tricks
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
$ 4.804
122
2
theexcelclub
excel
2021-03-05 02:00
Create an Excel Crypto Portfolio Tracker
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
$ 46.830
225
20
theexcelclub
excelhash
2021-02-10 10:00
How to recreate this interactive Excel dashboard
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
$ 0.690
82
1
theexcelclub
exceltimetounixtime
2020-12-06 08:50
How to - Unix Timestamp conversions in Excel and Power Query
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
$ 0.808
96
1
theexcelclub
excelblogs
2020-12-01 11:09
Excel Superstars you need to be following in 2021
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
$ 7.567
97
1
theexcelclub
excel
2020-11-18 13:55
Overcome Problems when Copying and Duplicating Excel Worksheets
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.
$ 0.664
88
1
theexcelclub
filterinexcel
2020-10-20 09:30
Find the corresponding value from Multiple column match in Excel
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
$ 0.547
90
1
theexcelclub
excel
2020-10-19 10:05
Find the corresponding value from Multiple column match in Excel
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
$ 0.787
35
theexcelclub
excel
2020-10-19 09:55
Find the corresponding value from Multiple column match in Excel
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
$ 0.054
13
theexcelclub
excel
2020-10-19 09:48
Find the corresponding value from Multiple column match in Excel
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
$ 1.565
141
5
theexcelclub
excel
2020-10-13 17:55
Learn How to Fix Totals and Subtotals in DAX
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
$ 4.335
182
theexcelclub
excel
2020-10-06 14:45
3 Ways to Set Screen Scroll Lock Area in Excel
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
$ 4.404
183
3
theexcelclub
excel
2020-10-05 10:03
Document Entire Excel Workbook with the Click of a Button
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
$ 9.193
116
theexcelclub
excel
2020-09-29 13:10
Find Hard-coded values in Excel Formulas
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
$ 1.072
104
theexcelclub
excel
2020-09-22 17:30
Excel Hidden and Very Hidden Sheets - What's the difference?
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
$ 2.465
132
3
theexcelclub
excel
2020-09-08 16:19
Easy Excel Lessons - Transposing Data and Converting Text to Columns
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
$ 12.977
136
4
theexcelclub
excel
2020-09-04 01:35
How to connect Excel to Coinmarketcap API
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
$ 4.238
148
9
theexcelclub
excel
2020-08-21 18:10
Easy steps to Convert Snowflake to a Star- DAX Modeling
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
$ 2.136
124
2
theexcelclub
excel
2020-08-18 01:10
Ultimate Guide - Compare two lists or datasets in Excel
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
$ 4.641
153
2
theexcelclub
excel
2020-08-10 13:45
How to use XMATCH in Excel
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
$ 5.775
182