Boss wants a quick report? NOW? Well, I got you covered.
Use this simple but effective Excel trick to make a clickable report in just 4 minutes.
We are going to use the subtotal & outline function of Excel to do this. And then we will put a cherry on top with conditional formatting 🍒
📗 Sample file:
=============
Get the sample file from chandoo.org/wp... and practice this idea.
⏲ Got more time? Learn these tricks:
===============================
Need something more? Check out below Excel tricks:
Make 8 Pivot Tables in 10 minutes - • How to use Pivot Table...
5 Amazing conditional formatting tricks - • 5 Conditional Formatti...
Top 5 chart with Excel - • Create a Top 5 Dynamic...
#excel
Негізгі бет Make a clickable report in Excel with this *CRAZY* trick in just 4 minutes!
Пікірлер: 102