Archive for the ‘Excel 2007’ Category
Wednesday, October 29th, 2008
This lesson continues from Excel 2007 Practice: Create a Quick & Easy Pie Chart and Excel 2007 Practice: Adding Data Labels to a Pie Chart.
There are two ways to change the color in a chart: by changing the theme in Excel or changing the color of the individual slices of ...
Posted in Charts, Excel 2007 | 4 Comments »
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 »
Thursday, October 23rd, 2008
There will be other how-to articles that start with the chart made in these directions, so you might want to save this project to use with those articles. Like this article on Legends & Data Labels and Change Color and Explode a Pie Chart.
A chart is a visual representation of ...
Posted in Charts, Excel 2007 | 3 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 »
Monday, August 18th, 2008
This only works on formulas to be copied down rows of cells, not across columns of cells.
Type in and enter the formula to be copied.
Move the cell pointer to the cell that holds the original formula.
Double-click the fill handle to copy the formula down. It should copy down ...
Posted in Copy, Cut, Paste, Excel 2007 | No 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 »
Wednesday, August 13th, 2008
Not just months, but days (like Monday, Tuesday), dates, or a series of numbers. And it copies formulas, too. The fill handle is the thin plus you get onscreen when you hover your mouse over the little square in the corner of the cell pointer.
To create a series of months ...
Posted in Copy, Cut, Paste, Excel 2007 | 1 Comment »
Tuesday, August 12th, 2008
If you're new to Excel, here's a guide to the different mouse shapes you'll see, and what they are used for.
General Select
Description: Thick plus shape.
How to get one: Appears when the mouse is anywhere over the worksheet grid.
Used for: Selecting a range of cells by clicking and dragging ...
Posted in Excel 2007, Views & Screen Parts | 2 Comments »
Monday, August 11th, 2008
This is for those Word, Excel or PowerPoint users who find that they repeatedly make the same formatting changes to the Shapes (Insert tab, Illustrations group, Shapes) or the Text Boxes (Insert tab, Text group, Text Box) they use. These are the steps to change the default format for either ...
Posted in Clipart & Graphics, Customize, Excel 2007, Text Boxes & Shapes, Text boxes, Word 2007 | 2 Comments »
