The Excel Club (@theexcelclub) — Hive

theexcelclub (67)in #excel • 4 years ago
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…
$4.80
Past Payouts $4.80
- Author $2.58
- Curators & beneficiaries $2.22
> steempress: $0.36
122 2
theexcelclub (67)in #excel • 4 years ago
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…
$46.83
Past Payouts $46.83
- Author $23.74
- Curators & beneficiaries $23.09
> steempress: $3.51
225 20
theexcelclub (67)in #excelhash • 4 years ago
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…
$0.69
Past Payouts $0.69
- Author $0.39
- Curators & beneficiaries $0.30
> steempress: $0.05
82 1
theexcelclub (67)in #exceltimetounixtime • 4 years ago
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…
$0.81
Past Payouts $0.81
- Author $0.43
- Curators & beneficiaries $0.37
> steempress: $0.06
96 1
theexcelclub (67)in #excelblogs • 4 years ago
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…
$7.57
Past Payouts $7.57
- Author $3.86
- Curators & beneficiaries $3.70
> steempress: $0.57
97 1
theexcelclub (67)in #excel • 4 years ago
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…
$0.66
Past Payouts $0.66
- Author $0.36
- Curators & beneficiaries $0.30
> steempress: $0.05
88 1
theexcelclub (67)in #filterinexcel • 4 years ago
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…
$0.55
Past Payouts $0.55
- Author $0.31
- Curators & beneficiaries $0.24
> steempress: $0.04
90 1
theexcelclub (67)in #excel • 4 years ago
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…
$0.79
Past Payouts $0.79
- Author $0.40
- Curators & beneficiaries $0.39
> steempress: $0.06
35 0
theexcelclub (67)in #excel • 4 years ago
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…
$0.05
Past Payouts $0.05
- Author $0.03
- Curators & beneficiaries $0.03
> steempress: $0.00
13 0
theexcelclub (67)in #excel • 4 years ago
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…
$1.56
Past Payouts $1.56
- Author $0.84
- Curators & beneficiaries $0.72
> steempress: $0.12
141 5
theexcelclub (67)in #excel • 4 years ago
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…
$4.33
Past Payouts $4.33
- Author $2.26
- Curators & beneficiaries $2.08
> steempress: $0.33
182 0
theexcelclub (67)in #excel • 4 years ago
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…
$4.40
Past Payouts $4.40
- Author $2.31
- Curators & beneficiaries $2.09
> steempress: $0.33
183 3
theexcelclub (67)in #excel • 4 years ago
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…
$9.19
Past Payouts $9.19
- Author $4.75
- Curators & beneficiaries $4.45
> steempress: $0.69
116 0
theexcelclub (67)in #excel • 4 years ago
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…
$1.07
Past Payouts $1.07
- Author $0.60
- Curators & beneficiaries $0.47
> steempress: $0.08
104 0
theexcelclub (67)in #excel • 5 years ago
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…
$2.46
Past Payouts $2.46
- Author $1.32
- Curators & beneficiaries $1.15
> steempress: $0.18
132 3
theexcelclub (67)in #excel • 5 years ago
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.…
$12.98
Past Payouts $12.98
- Author $6.67
- Curators & beneficiaries $6.31
> steempress: $0.97
136 4
theexcelclub (67)in #excel • 5 years ago
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…
$4.24
Past Payouts $4.24
- Author $2.24
- Curators & beneficiaries $1.99
> steempress: $0.32
148 9
theexcelclub (67)in #excel • 5 years ago
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…
$2.14
Past Payouts $2.14
- Author $1.16
- Curators & beneficiaries $0.98
> steempress: $0.16
124 2
theexcelclub (67)in #excel • 5 years ago
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…
$4.64
Past Payouts $4.64
- Author $2.48
- Curators & beneficiaries $2.16
> steempress: $0.35
153 2
theexcelclub (67)in #excel • 5 years ago
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…
$5.78
Past Payouts $5.78
- Author $3.07
- Curators & beneficiaries $2.71
> steempress: $0.43
182 0