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.
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.
- Women in Excel you need to be following.
- Data Profiling views in Power Query (Excel and Power BI)
- DAX LOOKUPVALUE – Power BI and Excel Power Pivot
- 9 Tips for Power BI users
- Learn how to fix totals and subtotals in DAX
- How to connect Excel to Coinmarketcap API
- 6 DAX tips for Excel and Power BI users
- Why and how to keep dimensions and facts tables separate – DAX modeling.
- DAX AND OR IN or syntax (&& ||) – Which one?
- The 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
- How to connect Excel to Coinmarketcap API
- Tips for Analyzing Categorical Data in Excel
- Ultimate Guide – Compare two lists or datasets in Excel
- Looking up and Combining text using TEXTJOIN and Array IF Statements.
- How to carry out a VLOOKUP within Text in Excel
- Learn how to Group Data in Excel and use Subtotals
- Easy Excel Solutions: Power Pivot Many to Many Relationships
- DAX SUM and SUMX Functions
- DAX COUNT and COUNTX – Impact of Using Measures V’s Calculated Columns
- 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