Custom Views in Excel – Save filter and header settings for quick reference
PHD reader and commenter Vishy contributed this post through e-mail. Thank you so much Vishy for this very useful tip. The Problem: You have created a specific view of your data in Excel (say by filtering, zooming out, changing column width, hiding specific rows, customizing window settings, print settings etc.). This is your reference point […]
2009 Calendar Template in Excel – Now with week starting on Monday
Stružák, one of the commenters on the 2009 Excel Calendar Template post asked me if I can rearrange the cells in the calendar so that the week could start on Monday. Since I didn’t have access to internet for a while, I have asked him to make the necessary changes and mail it to me […]
Formula Debugging in Excel – Tip [spreadcheats]
Can you imagine building a complex worksheet without formulas? I can’t. While no one can dispute the usability of formulas, we all know how painful it is when an excel formula returns a mysterious error and we don’t know what is causing the error.
Excel Links of the Week [Dec 15]
Finally I have got internet connection at home. The folks at Airtel Broadband are very fast and professional. They set up the connection in very few days. So I will be able to blog regularly from now on.
Moving to this week’s excel links you should browse;
Interview with Charley Kyd on Everyday Excel
As mentioned earlier, I have conducted a small interview with Charley Kyd – an Excel MVP, author of four books and 50+ articles for various national media, owner of exceluser.com and creator of popular products like plug-n-play excel dashboard kit. He sent me the answers almost a week back, but I could push the interview only today due to my travel and settling down stuff. As expected the interview is very entertaining and useful. I hope you like this.
Brick Charts in Excel – an Alternative to Gridlines
Grid lines provide great help in understanding values in a chart. Here is a handy trick you can use in the next bar chart to spice it up. Here is how you can get this type of chart (we will call it a brick chart) First we will make a regular bar chart Now, let […]
Free Excel Calendar Template for year 2009 (and all years up to 9999)
Free excel calendar template for year 2009 (well, it works for any year all the way up to 9999)
Go ahead and download it, change the year number in the first sheet to 1981 or something and see the magic.