Show hide list boxes using VBA
Rama, one of our readers emailed this:
I Have Many List boxes In That I need to Hide Few Of them Using Check box
Show Hide list boxes by using a check box
We can use check box and a bit of VBA to do this easily. Something like above demo.
Read on to learn how to do this using Excel & VBA.
Macros for Automatically Implementing Modeling Best Practices
In the first part on our Modeling Best Practices series, we learned 5 best practices to follow. This article shows how to automatically implement the best practices using macros.
Project Portfolio Dashboard in Excel [Part 2 of 2]
In this 2 part tutorial, we will learn how to design a project portfolio dashboard. Part 1 discussed user needs & design. Part 2 will show you Excel implementation.
Click here to get your copy.
Final Implementation – Project Portfolio Dashboard
First lets take a look at the finalized dashboard implementation. Continue reading to learn more & download this dashboard.
Happy Diwali [Animated Chart inside]
My heartiest Diwali wishes to all our readers.
The spirit of Diwali is to encourage people to spread joy, celebrate good things and throw away darkness (evil). These ideas are universal. So let me wish you a very happy Diwali.
Diwali, festival of lights, is celebrated in the month of October / November. It is one of my favorite festivals since childhood. A time when all family members get together, celebrate all the good in their life, laugh and light a few fire crackers (fire works).
This year, our kids (Nishanth & Nakshatra) too are excited about the festival. They are eager to light diyas (small lamps), watch the fire works and enjoy. Naturally I do not feel like opening Excel.
But then…,
Sometime during my morning coffee, I thought “hey, why not create a small Diwali greeting using Excel?”
So here we go.
Journey of Hurricane Sandy – Animated Excel Chart
Hurricane Sandy has taken front seat in all major news channels, papers, websites even in far off places like India. I hope & pray that our readers in US East coast are safe.
Today, lets understand the journey of Hurricane Sandy in this animated chart, prepared by Chris from Excel365.
Even faster ways to Extract file name from path [quick tip]
The best thing about Excel is that you can do the same thing in several ways. Our yesterdays problem – Extracting file name from full path is no different. There are many different ways to do it, apart from writing a formula. Learn these techniques to be a data extraction ninja.
1. Using find replace
2. Using text to columns
3. Using UDFs
Using pivot tables to find out non performing customers
Moosa, one of our readers emailed this interesting question:
I have huge list of customers (around 1500).
Table includes following information
Customer # , Customer Name, Sales 2002, sales 2003, … sales 2012My requirements are
1. list of customer who did not have sales during all these years
2. List of customer who have not business from 2003
3. List of customer who have not business from 2004
Today, lets learn how to identify all the non-performing customers.