Do you know these Double-click Tricks in Excel?
Most of us think of mastering formulas, learning macros and being supergood with charts when we think of being productive with spreadsheets. But often learning simple stuff like keyboard shortcuts, using mouse and working with menus and ribbons can be a huge productivity booster for us. So as part of this installment of spreadcheats we […]
How to Hide a Cell’s Contents in Excel? [Quick Tip]
Here is a very quick tip if you ever want to hide a cell’s contents in excel
Just use the custom cell formatting (more here) code ;;;
Converting Excel to PDF – Everything you need to know
Ok, so you have that neat little excel report ready and now you want to share it with your boss or client in a PDF format. So how would you do that? Your best option is …
Create a Dynamic Chart in Excel in 2 Minutes [spreadcheats]
Here is a really fun and simple way to create dynamic charts in Excel. It uses data filters in an innovative way and creates the dynamic effect. To create the dynamic charts, just follow these 5 steps:
(1) Prepare your charts: Make as many charts as you want. Lets say 3.
(2) Set up the area where dynamic charts will be loaded: Just take 3 cells in a row and adjust the row height and column width such that the charts can be fit inside snugly. Also, type the chart names (1 for each cell) in the cell. Let us say, the charts you have are for Costs, Sales and Profits, just type these names in the cells.
Read more…
Tweetboards – Alternative to traditional management dashboards
Here is a fun, simple and different alternative to traditional dashboards. Introducing….
Budget vs. Actual Charts – 14 Charting Ideas You can Use
Do you want to make a budget vs. actual performance chart but not sure what option to use? Check out these 14 excel charting alternatives and find the one that tells your story.
Visualization Challenge – Budget vs. Actual Performance
Here is your chance to win a copy of The Visual Display of Quantitative Information by Edward Tufte, all you need to do is visualize budget vs. actual performance of the given data. Go!