Archive for the ‘Customizing’ Category
Monday, October 27th, 2008
This project starts with the file made in Create a Quick & Easy Pie Chart and continues with Change Color and Explode a Pie Chart.
This practice is about Legends and Data Labels, which are both chart features that help identify the "slices" in the pie chart. In a default Excel ...
Posted in Charts, Customizing, Excel 2007 | No Comments »
Tuesday, September 2nd, 2008
Here's the premise: you want to create a class attendance worksheet in Excel. The class meets Tuesdays and Thursdays from August 26 to October 14, 2008. The worksheet should have vertical headings with a Tuesday / Thursday date series, where the month and day displays (like 26-Aug, 28-Aug, or 8/26, ...
Posted in Customizing, Date Formats, Excel 2007 | 2 Comments »
Thursday, August 14th, 2008
If you frequently have to type in a list of names, cities, locations, anything really, you can save that list and use the fill option to quickly generate the list. You do have to type in one of the names in the list to start the fill action.
Click the ...
Posted in Copy, Cut, Paste, Customizing, Excel 2007 | 2 Comments »
Thursday, July 31st, 2008
When working with a large worksheet in Excel, it’s often necessary to keep the row or column headings onscreen while working so you can see what you’re working with as you scroll down-screen. You can do this by Freezing Panes in Excel.
The only catch is in knowing how to ...
Posted in Customizing, Excel 2007, Views & Screen Parts | 6 Comments »
