I have an exciting announcement to share with you. My first ever print book – Dashboards for Excel, co-authored with Jordan Goldmeier is releasing on 15th September.
Dashboards for Excel – what is it?
As the name suggests this book is a handy guide for anyone preparing dashboards, management reports and business intelligence workbooks using Excel. The key benefits are,
- Learn the visualization tools, charts, tables, and graphs important to management.
- Understand what management doesn’t want to see in a report
- Turn around dashboards faster and cheaper than ever before
- Understand the key role dashboards play in an organization
- Analyze real-world dashboards to apply important features to your own organization
- Utilize understated, but powerful, Excel formulas and VBA code
- Avoid common pitfalls in Excel development and dashboard creation
- Get started with the Excel data model, PowerPivot, and Power Query
As you can see, this is an advanced Excel book with lots of examples, case studies and practical tips.Continue »
Wow, what a month it has been. In August 2015, I announced Awesome August, an Excel festival. I published 31 articles, one for each day of August to make you awesome in your work. We had 3 podcasts, 11 videos, 17 articles and 238 comments in August. This content is consumed by more than 50,000 people from all over the world (3% of site traffic visited Awesome August pages). There were lots of emails, tweets and facebook posts telling me how you are enjoying Awesome August.
Thank you so much for taking time to learn from Chandoo.org and making Awesome August a success.
I made a short (5 mins) video to share the journey and to say thanks to you personally. Please watch it below.Continue »
Cascading drop downs enhance usability of your dashboards & interactive workbooks. A cascading drop-down is a 2 or more level selection mechanism. When you have 100s of selection choices, instead of creating one massive drop down or combo-box, you can set up multiple levels of drop downs, so that users can narrow down their selection. For example, users can select Country, State and then City using cascading drop downs.
There are many ways to setup cascading drop downs. You can use formulas coupled with either data validation or form controls. You can also use Slicers. In this video we will review these techniques.Continue »
Here is a familiar scenario: You are building a dashboard. Naturally, it has a few worksheets – data, assumptions, calculations and output. As you make changes to input data, you constantly switch to calculations (or output) page to check if the numbers are calculating as desired. This back and forth is slows you down.
Use Watch Window to reduce development time.Continue »
Funnel charts are useful to visualize sales & marketing performance. In this brief video, let’s understand how to make a quick funnel chart in Excel.
Read on to learn how to make funnel charts & to download a template for your funnel analysis needs.Continue »
Here is an awesome planner template to help you manage activities over a month. It is useful for charity drives, activity planning, school schedules, marketing initiatives, project planning etc.
Read on to download a copy of the template & learn how to use it.Continue »
In the 43rd session of Chandoo.org podcast, let’s talk about top time saving features of Excel.
What is in this session?
In this podcast,
- Quick announcement about Awesome August
- My 9 favorite time saving features of Excel
- Remove Duplicates
- Pivot Tables
- Auto fill
- Format Painter
- Find & Replace
- VBA / Macro Recorder
- Auto save
- Auto complete / Intellisence
- Recap & Conclusions