Unofficial Excel Stuff

Book

Suggestions

Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal

Thursday, October 18, 2007 – Permalink –
Links to Excel
Spokes of the web

There's a lot of information out there. The problem is how to find it.
Here is a site that contains links to Excel information arranged in topics:

Excel Add-ins

Excel Help

Excel Password Recovery

Excel Templates

Excel Tips & Tricks

Excel Tutorials

Excel VBA

Free Excel Add Ins

Spreadsheet Research

Excel Links

See all Topics
excel
Labels: General, Link, Lists

<Doug Klippert@ 8:03 AM

Comments: Post a Comment

Sunday, September 30, 2007 – Permalink –
Data Tables
Up one side; down another

Data tables are a neat Excel feature that has not been emphasized.

If you are looking at, for instance, a home loan with a number of interest rates and different loan periods, a Data table can lay out the results with a minimum of fluff and formulas.

Dick Kusleika, Microsoft MVP, has a description on his excellent Daily Dose of Excel blog.
Data Table Basics

J K Pieterse:
Excel 2007 tables

Microsoft:
How to Use Microsoft Excel Data Tables to Analyze Information in a Database
How to Create and Use One-Input Data Tables in Microsoft Excel
How to Create and Use Two-Input Data Tables in Microsoft Excel

Overview of Data Tables - 2003 and 2007

TechRepublic.com:
Teach two-variable Excel data tables with real-life examples

See all Topics
excel
Labels: Lists, Tips

<Doug Klippert@ 7:44 AM

Comments: Post a Comment

Saturday, May 12, 2007 – Permalink –
Drop Down Menu
Validation

You can create a dropdown list that gets its choices from entries located in another part of the spreadsheet.

Type the entries in one column or row.

You can name the list by selecting the entries and then clicking in the Name box on the Formula bar and entering a name, and then press Enter.

Next, select the cell where you want the dropdown list.

On the Menu bar, go to the Data menu, click Validation, and then click the Settings tab.
In the Allow box, click List.

Enter the name of the list or its location.

Make sure the reference or name is preceded with an equal sign (=).

Make sure the In-cell dropdown check box is selected.

If your list is short, you can type the entries directly in the Source box, separated by commas.

Debra Dalgleish, Excel MVP has a complete discussion on her Contextures.com site. She covers resizing the dropdown box. The site also includes other information about data validation:

Excel — Data Validation —Tips

See all Topics
excel
Labels: Lists

<Doug Klippert@ 8:22 AM

Comments: Post a Comment

Sunday, January 07, 2007 – Permalink –
Custom Lists
Your Way

At times, you will want to enter the same information repeatedly in a spreadsheet.
It could be employee names, products or State names.

Here is a way to produce the information when needed.

Make a list of the items.
Enter the data in, say, A1, B1, C1 etc.
Be sure to enter in the right order; maybe Supervisor and then team members in alphabetic order.

Select all of the cells.
Go to Tools>Options and choose the Custom lists tab.
ClickImport.
OKyour way out.

Now you can delete the entries on the spreadsheet.

Choose any cell and type one of the items that is on your Custom List.
Click and drag on the fill handle; the tiny square at the bottom right corner of the selected cell.
As you pull, Excel will duplicate your list.

(In Excel 2007, go to the Office Logo. Choose Excel Options. Edit Custom Lists will be on the Popular page.)

Also see:

The First Shall Be Last by Dick Kusleika

Sorting by Color by Chip Pearson

See all Topics
Labels: Lists

<Doug Klippert@ 5:11 AM

Comments: Post a Comment