Market Segmentation Charts using Conditional Formatting
Trust Peltier to come up with solutions for even the most impossible looking charts. Today he shares a marimekko chart tutorial. I couldn’t sit still after seeing his post. So here comes market segmentation charts or marimekko charts using,
“Too Many Worksheets” Driving You Nuts? Read This!
Learn how to create Table of Contents in Excel and other tricks to manage when you have too many worksheets.
Excel Colors Somehow Getting Changed ?
Reader Raja asks about “how he can reset the colors in his workbook”. Read more to find out how you can fix this problem.
Make a Dynamic Chart using Data Filters
As part of our spreadcheats series, we will learn how you can use data filters to create dynamic charts in Microsoft excel
100 Excel Tips & Resources
Hurray, PHD blog crossed 2000 RSS Subscriber base. This is a very significant milestone for me.
To celebrate this occasion we have a mega post: 100 Excel & Charting Tips, Tricks and Resources for you.
Why No One Likes Your Pie Charts (And What to Do About It)
9 charting tricks you can use to make your pie charts likable
Selecting all the cells in a series – keyboard and mouse shortcuts [spreadcheats]
Here is a very quick spreadcheat for the new year.
If you need to select all the cells in a series (either row-wise or or in columns) you can use one of these 2 shortcuts (and avoid unnecessary scrolling)
1. Select the first cell in the series
2. Press Shift + Ctrl + Down arrow
Or
1. Select the first cell in the series
2. Hold down SHIFT and Double click on the edge of cell in the direction you want to select