Learn Advanced Excel – 3 Month Roadmap with Resources
Advanced Excel Skills are highly sought after. Use this FREE Excel roadmap to learn and grow you Excel skills in 3 months.
Filter one table if the value is in another table (Formula Trick)
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.
Which Excel Formulas should you learn first?
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.
How to write complex Excel formulas (hint: it’s a lot like LEGO)
Writing advanced formulas is a lot like LEGO. Use what you already have and combine them in creative ways. Let me demo with 5 examples.
10 Advanced IF formula tricks you must know
IF is the most used Excel function out there. Here are 10 advanced IF tricks to take your formulas to next-level ?
Excel formula to convert calendar format to table
Got some data in a calendar format and just wished you can get it in tabular format?
You can use Excel formulas or Power Query to do this. In this article, let’s review formula based approach with two excellent choices.
How to make stream graphs in Excel?
A stream graph or stream plot is an area chart that looks like a stream. In this post, let me show you how to create an interactive stream graph using Excel area charts. The original design for this graph is inspired from Cedric Scherer.