How to Change Shapes in Microsoft Office 2007
Ever since we made a switch to Microsoft Office 2007 at work, this has been bothering me.”How to change one shape to another?”
This is very useful feature, especially when you are using PowerPoint.
“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.
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
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
Excel 2007 Review – 10 things that WOWed me
After a really long wait finally I have used … Excel 2007 (drum roll) and contrary to what many people think, I have found Excel 2007 to be a very well designed piece of software. Of course there are various issues with it and I am sure folks at MS are working on them so that next versions of MS Office are much more pleasant and simpler to use.
I wanted to share 10 wow factors in Excel 2007 that may convince you to try it.
Creating Excel Art from Images [spreadsheet fun]
Amit at Digital Inspiration features a lengthy way of creating beautiful excel cell art from an image. I guess we all can use a method that is little simpler and smarter.