2020 is coming close to an end and it has probably been a year most of us are happy to say goodbye to.  However, even with all the ongoings, I still feel like I have a lot to celebrate. The Excel Club blog has grown from strength to strength and thanks to you, I have seen a 92% increase in traffic to my blog this year. Thank YOU. Woot………it’s a massive achievement.
![Paula_MVP.png](https://images.hive.blog/DQmZGeD4CGsgFExwhwVPUSYT15gpDLVLj6c9CBw41YNi3UH/Paula_MVP.png)

This year I published 25 Excel and Excel Related articles. From these 25 articles the most popular, based on your total views are (in reverse order)

### Top Excel Blog posts published in 2020.

10. [Women in Excel you need to be following.](https://theexcelclub.com/women-in-excel-you-need-to-be-following/)
9. [Data Profiling views in Power Query (Excel and Power BI)](https://theexcelclub.com/data-profiling-views-in-power-query-excel-and-power-bi/)
8. [DAX LOOKUPVALUE – Power BI and Excel Power Pivot](https://theexcelclub.com/dax-lookupvalue-power-bi-and-excel-power-pivot/)
7. [9 Tips for Power BI users](https://theexcelclub.com/9-tips-for-powerbi-users/)
6. [Learn how to fix totals and subtotals in DAX](https://theexcelclub.com/learn-how-to-fix-totals-and-subtotals-in-dax-powerbi-and-power-pivot/)
5. [How to connect Excel to Coinmarketcap API](https://theexcelclub.com/how-to-connect-excel-to-coinmarketcap-api/)
4. [6 DAX tips for Excel and Power BI users](https://theexcelclub.com/6-dax-tips-for-excel-and-power-bi-users/)
3.  [Why and how to keep dimensions and facts tables separate – DAX modeling.](https://theexcelclub.com/dax-modeling-why-and-how-keep-dimensions-and-facts-tables-separate/)
2. [DAX AND OR IN or syntax (&& ||) – Which one?](https://theexcelclub.com/dax-and-or-in-or-syntax-which-one/)
1. [The Ultimate Guide – Compare two lists or datasets in Excel.](https://theexcelclub.com/ultimate-guide-compare-two-lists-or-datasets-in-excel/)

Because I love data, and obviously Excel and Excel Power Tools, with a little more analysis I am also sharing with you my overall top Excel Blog posts of 2020.  Most of these blog posts have been around for over a year.  In fact, there are only 2 posts that make both lists.  It's awesome to see so much of my content valued and viewed by all of you.

### Top Excel Blog Posts of All time

10. [How to connect Excel to Coinmarketcap API](https://theexcelclub.com/how-to-connect-excel-to-coinmarketcap-api/)
9. [Tips for Analyzing Categorical Data in Excel](https://theexcelclub.com/tips-for-analyzing-categorical-data-in-excel/)
8. [Ultimate Guide – Compare two lists or datasets in Excel](https://theexcelclub.com/ultimate-guide-compare-two-lists-or-datasets-in-excel/)
7. [Looking up and Combining text using TEXTJOIN and Array IF Statements.](https://theexcelclub.com/looking-up-and-combining-text-using-textjoin-and-array-if-statements/)
6. [How to carry out a VLOOKUP within Text in Excel](https://theexcelclub.com/how-to-carry-out-a-vlookup-within-text-in-excel/)
5. [Learn how to Group Data in Excel and use Subtotals](https://theexcelclub.com/group-data-in-excel/)
4. [Easy Excel Solutions: Power Pivot Many to Many Relationships](https://theexcelclub.com/power-pivot-many-to-many-relationships/)
3. [DAX SUM and SUMX Functions](https://theexcelclub.com/dax-sum-and-sumx-functions/)
2. [DAX COUNT and COUNTX – Impact of Using Measures V’s Calculated Columns](https://theexcelclub.com/dax-count-and-countx-impact-of-using-measures-and-columns/)
1. [How to Parse Custom JSON Data using Excel](https://theexcelclub.com/how-to-parse-custom-json-data-using-excel/)

So which article is your favorite?  Did it make the list? Comment below and let me know and I hope you will also consider sharing this article as it has been your shares and your likes and comments that helped me achieve the growth I had in 2020.

Roll on 2021.

Much love
x
Paula Guilfoyle CPA MVP


Posted Using [LeoFinance <sup>Beta</sup>](https://leofinance.io/@paulag/my-top-excel-blog-posts-of-2020)