Home » Archive for January, 2008

How to Individually Highlight One Slice from a Pie Chart
0
We can automate a lot of things with excel sometimes though we need to have visual appeal. Using charts to impact our audience instead of plain boring numbers makes sense. Pie charts are one of Excel’s most options used to display number and percentage...

Continue Reading »

How to Insert and Modify Cell Comments in a Spreadsheet
0
The 3-D cells we made were cool, but what else can we do with cells? We all use the handy dandy post it notes. They are a life saver to quickly remind us of important points that we might forget with all the chaos that goes on at work. Well you can...

Continue Reading »

How to Create a 3-D Illusion in Cells

How to Create a 3-D Illusion in Cells

Posted by on January 28, 2008
0
Working with spreadsheets and formulas can become dull, but there are some fun ways that you can easily energize a spreadsheet like for example creating a 3-D effect on a specific cell. In this lesson, I’ll show how to do this in three easy steps....

Continue Reading »

How to Create a Table of Content of all Spreadsheets Within a Workbook
1
You probably have one workbook that contains most of the spreadsheets that you use on a daily basis, and scrolling from left to right, and right to left to find the specific spreadsheet that you need wastes time. We know how to input the same data into...

Continue Reading »

How to Input the Same Data into Individual Worksheets at the Same Time
1
Sometimes you may need to change the same data in a several of worksheets, so instead of going through each of them separately, Excel let’s you group them and enter the new information once and make it appear in all the other worksheets that you specify. 1....

Continue Reading »