Menu
Archive for November, 2022
{ 8 Comments }
How to connect to a SINGLE file on SharePoint from Power Query (Fix Unable to Connect Error)
Published on Nov 25, 2022 in Learn Excel, Power Query
Want to connect SharePoint files to Power Query but keep getting “unable to connect” error? Here is a simple fix to the problem.
Continue »{ 7 Comments }
FIFA 2022 World Cup Schedule & Results – Excel [FREE Download]
Published on Nov 19, 2022 in Learn Excel, Templates
![FIFA 2022 World Cup Schedule & Results – Excel [FREE Download]](https://chandoo.org/wp/wp-content/uploads/2022/11/SNAG-0051.jpg)
It is the Soccer WORLD CUP time. Let’s celebrate the season with an AWESOME Excel File to track game schedules, results & scores.
Continue »{ 3 Comments }
Filter one table if the value is in another table (Formula Trick)
Published on Nov 17, 2022 in Learn Excel
I have an orders table and want to see only orders from a given list of products. We can use Excel’s FILTER function to do this.
Continue »{ 0 Comments }
Which Excel Formulas should you learn first?
Published on Nov 14, 2022 in Learn Excel
Let’s face it. You already know how to use SUMs, COUNTs and IFs and want to level up. But there are 100s of functions in Excel and you are not sure which ones to focus on.
In this article, let me reveal the top 10 important functions in Excel for data analysis work.
Continue »
