2003-2007-2010

Labels: General, Ribbon

Also some Windows hints

• Word
• Word VBA
• Excel
• Excel VBA
  
  and
• Windows

Labels: General, Tips, VBA

Conditional colors

Labels: 2010, Formats, General, Tips

Find and/change storage spots

Labels: Customize, General, Templates

Another year

Labels: General, Templates

And a Functional New Year

This hilarious clock is the perfect accessory for any Excel power user. Each numeral has been replaced with a suitable Excel function that will evaluate to that numeral.

We've used one function from as many function categories as possible to really provide a broad range of functions.

=FACT(3) - The FACT() function returns the Factorial of a number. The Factorial of 10 is 10x9x8x7x6x5x4x3x2x1. This function is great for statisticians calculating combinations and permutations. In our case, the Factorial of 3 is 3x2x1 or 6

Labels: Gadgets, General

Unencrypted

"Word, Excel, and PowerPoint have been able to password protect documents for several versions by setting the 'password to open'. What we felt could be improved was the ability to enforce password strength rules, similar to what may be required when logging into your computer at work."

Labels: General, Tips

One sheet to another

Labels: General, Shortcuts

Protect your work

Microsoft Excel provides multiple layers of protection to allow you to control who can access and change your data:

• Worksheet protection: You can protect elements on a worksheet (for example, cells with formulas) from all user access, or you can grant individual users access to the ranges that you specify.
  
• Workbook-level protection: You can apply protection to workbook elements, and you can protect a workbook file from being viewed and edited. If a workbook is shared, you can protect it from being returned to exclusive use and prevent the change history from being deleted.

... articles address some of the more frequently asked questions about workbook and worksheet protection in Excel:

• How can I grant only a few users access to a range in my worksheet?
  
• Why are users not allowed to edit the ranges that I established permissions for?
  
• What new features are available in workbook protection?
  
• Why don't the permissions that I set on ranges in my worksheets carry over to Windows 98 computers?

Labels: General, Tips, Tutorials

How do I know it's real?

What is a digital certificate?

What is a digital signature?

What occurs when I use a digital signature?

What Word files can I sign?

How can I obtain a digital signature?

• Method 1: Obtain a digital certificate from a certification authority
  
• Method 2: Create your own digital certificate

Labels: Addins, General, Tips

Without Protection

Labels: Customize, General, Tips

I'd Like to Make It Clear

• squinted your eyes trying to see the numbers in a PowerPoint presentation?
  
  
• scratched your head at a charity leaflet with an indecipherable pie chart titled 'Where your donation goes' ... and set it aside?
  
  
• missed discussion at a meeting because you were busy trying to figure out the figures?
  
  
• put aside a graph or table, thinking "I'm not good with numbers."?

• what to include: when unsure what numbers are important, people frequently display them all, overpowering the reader with irrelevance.
  
  
• which format to use: the choice between text and table, table and chart, bar and pie.
  
  
• how to use the technology effectively: computer software generates graphs easily, but the results hide your point behind incomprehensible chartjunk.
  
  
• how to explain the information: selecting the right words for titles, columns and captions.

Labels: Charts, General, Tips

Folder size list

1. Copy the code and open Excel.
   
2. Press Alt+F11 and, if necessary, on the Visual Basic Editor menu, Insert>Module
   
3. Paste the code.
   
4. You could use Alt+Tab to bring the worksheet forward.
   
5. Go to Tools>Macros and run the Macro named "GetFolderListing".

Labels: General, Tips, VBA

CrossNumber puzzles

"Sudoku , sometimes spelled Su Doku, is a logic based placement puzzle, also known as Number Place in the United States. The aim of the canonical puzzle is to enter a numerical digit from 1 through 9 in each cell of a 9x9 grid made up of 3x3 subgrids (called "regions"), starting with various digits given in some cells (the "givens"). Each row, column, and region must contain only one instance of each numeral.
Completing the puzzle requires patience and logical ability. Its grid layout is reminiscent of other newspaper puzzles like crosswords and chess problems.
Although first published in 1979, Sudoku initially became popular in Japan in 1986 and attained international popularity in 2005."

1. Enter puzzle values in Starting position grid
   
2. Set Game state to 1
   
3. Press F9 to calculate
   
4. The Possible numbers grid will show the first step in the solution
   
5. The Final position will show the current result
   
6. Continue to repeat calculation by pressing F9 until the puzzle is solved or the solver stops responding

Labels: General

Statistical collection

• Charting Data
  
• Data Presentation
  
• Cumulative Frequencies
  
• Fishbone Diagram
  
• Flowcharts
  
• Frequency Distributions
  
• Gantt; PERT Charts
  
• Graphing With Excel
  
• Analyzing and Plotting Data with Excel
  
• Organizational Charts/Mapping
  
• Social Network Analysis

Labels: Charts, General, Lists

New Boundaries

The total number of available columns in Excel

Old Limit: 256 (2^8)

New Limit: 16k (2^14)

The total number of available rows in Excel

Old Limit: 64k (2^16)

New Limit: 1M (2^20)

Number of unique colors allowed a single workbook

Old Limit: 56 (indexed color)

New Limit: 4.3 billion (32-bit color)

Number of conditional format conditions on a cell

Old Limit: 3 conditions

New Limit: Limited by available memory

Number of levels of sorting on a range or table

Old Limit: 3

New Limit: 64

Number of items shown in the Auto-Filter dropdown

Old Limit: 1,000

New Limit: 10,000

The total number of characters that can display in a cell

Old Limit: 1k (when the text is formatted)

New Limit: 32k or as many as will fit in the cell (regardless of formatting)

The maximum length of formulas (in characters)

Old Limit: 1k characters

New Limit: 8k characters

The number of levels of nesting that Excel allows in formulas

Old Limit: 7

New Limit: 64

Maximum number of arguments to a function

Old Limit: 30

New Limit: 255

The number of characters that can be stored and displayed in a cell formatted as Text

Old Limit: 255

New Limit: 32k

Labels: General, Tips

Spreadsheet vagaries

The 1904 date system and the 1900 date system

"The default date system in Excel 2004 for Mac is the 1904 date system. The default date system in Excel 2003 is the 1900 date system. Typically, the use of different date systems does not cause a problem.

However, if you transfer a workbook from Excel to Excel for Mac, or vice versa, and then copy a date from one workbook to the other, the date may increase or decrease by four years and one day. This issue occurs if the two workbooks use different date systems.

For example, if you copy the date 1/1/1998 from a workbook that uses the 1900 date system and then paste the date into a workbook that uses the 1904 date system, the date appears as 1/2/2002. Alternatively, if you copy the date 1/1/1998 from a workbook that uses the 1904 date system and then paste the date into a workbook that uses the 1900 date system, the date appears as 12/31/1993.

As long as you know about the date systems that your workbooks use, the different date systems should not cause a problem.

Labels: General, Tips, Troubleshooting

Order tabs

• Sorting Worksheets In Alphabetical Order
  
• Sorting In Custom Order
  
• Grouping Sheets By Color

Here's the code to sort by tab color:

Sub GroupSheetsByColor()
Dim Ndx As Long
Dim Ndx2 As Long
For Ndx = 1 To Worksheets.Count - 1
For Ndx2 = Ndx To Worksheets.Count
If Worksheets(Ndx2).Tab.ColorIndex = _
Worksheets(Ndx).Tab.ColorIndex Then
Worksheets(Ndx2).Move after:=Worksheets(Ndx)
End If
Next Ndx2
Next Ndx
End Sub

Sorting Worksheets In A Workbook

(The colorindex variable chooses one of the 56 colors in Excel's basic palette.
Here are all the colors and numbers as compiled by F. David McRitchie:
Excel Colors )



See all Topics
excel

Labels: General, Tips, VBA

Excel!

"Another feature that illustrates 1-2-3's human-engineering design is its jargon-free prompts, explanatory messages, and fail-safe mechanisms.

Suppose I want to delete a spreadsheet file. When I type "/F", I get a menu of possible file actions, the first of which is in inverse video. I can execute any action by either moving the inverse video cursor to that action name and hitting the Return key or hitting the key that is the first letter of the action name.

If I hit the right-arrow key until the action name "Delete" is in inverse video, I get an explanatory note immediately below the command line that says, "Delete a worksheet, print, or graph file" ("worksheet" is Lotus's name for a spreadsheet).

That's what I want to do, so I conveniently hit Return. The inverse video cursor is already positioned on the option I want, "Worksheet", so I hit Return again. 1-2-3 now reads the current disk and gives me a menu of all the spreadsheet files by name.
I then move the inverse video cursor to the spreadsheet I want to delete and hit Return again (there's no need to type the file name - just point to it). 1-2-3 displays two options, "No" and "Yes", with the cursor on the "No" option and an explanatory note, "Do not delete the file". By moving the cursor onto the word "Yes" (which includes the note "Delete the file") and pressing Return, I can delete the spreadsheet file.

Wouldn't you like a piece of software that does all that for you?"

First Lotus 1-2-3 Review

Lotus was another application that missed the Windows train.

"Excel now dominates the spreadsheet world, but once upon a time there was actual competition among spreadsheet products. This program looks at Quattro 1.0, Allways 1.0, Lotus 1-2-3 3.0, Ashton-Tate's Full Impact, and Excel 2.1. Guests include Gary Kildall, Jan Lewis, and Jared Taylor of PC Magazine. Originally broadcast in 1988."

Spreadsheet Wars

Wikipedia.com:

"The rise of Microsoft Windows in the personal computer market was accompanied by the rise in Microsoft's competing spreadsheet, Excel, and it gradually usurped the position of 1-2-3. Being loyal to OS/2, Lotus was slow to embrace Windows. Additionally, several versions of 1-2-3 were available concurrently, each with different set of functionality and slightly different interface."

Labels: General

Scenario suggestions

"I wonder how our net profit would be affected if we could reduce our variable cost per unit by just a few cents. How much could we save if we found a lower interest rate? Wouldn't it be nice to be able to play around with some scenarios, do some "what-ifs" — without messing up your current data? It's easy with Microsoft Office Excel . You can set up "scenarios" to experiment with the data and compare the possibilities. Who knows? It could be a road map to better solutions for your business."

" To find out how to use what-if functions, follow along as this tutorial takes you step-by-step through several problems. Excel 2000 is used here to illustrate these concepts, but the process is similar in all spreadsheet programs."

Using a spreadsheet to do "what-if" analyses



See all Topics
excel

Labels: General, Tips, Tutorials

Excel Mock-up

"This article explains how to use Microsoft Excel to create prototypes of your Access databases and how to make sure your data adheres to a set of rules called normal forms. Normal forms aren't hard to understand, and they're critical to designing useful databases."

Design Access databases with normal forms and Excel

Also see:

Database normalization Webcast

An Introduction to Database Normalization

Database normalization basics

Database Normalization Basics for Developers

Also see:

Tushar-Mehta.com:
Building and using a relational database in Excel



See all Topics
excel

Labels: General, Tips

Still good after all these years

These detail the benefits and outline the steps of many Excel features. They are worth the download.

They are a great resource for learning advanced features, training, and tips on a great consistent presentation that you can use to format your workbooks.

While they were written for Microsoft Excel versions 5.0 and 7.0, they are still viable in Excel 200x.

These Experiences were developed for Microsoft Corporation by Baarns Publishing.

Here are the titles of the illustrated workbooks that are free to download:

• Subtotals Experience
  
• Group and Outline Experience
  
• Range Name Experience
  
• Functions Experience
  
• PivotTable Experience
  
• Auto Filter Experience
  
• Auto Format Experience
  
• Power Chart Experience
  
• Scenario Experience
  
• Solver Experience

Labels: General, Templates, Tips, Tutorials

Built in service

1. On the Tools menu, click AutoCorrect options.
   (Use the Office button and Excel Options in 2007)
   
2. Click the Smart Tags tab and place a check beside Label data with smart tags.
   
3. Click OK.
   
4. Type in a Stock symbol (such as MSFT) in a cell.
   (The symbol must be in all caps)
   
5. Click outside of the cell.
   
6. Place your mouse cursor over the purple triangle in the lower-right corner of the cell.
   Click the arrow.
   
7. Click Insert refreshable stock price.
   
8. Select whether to insert the stock price on a new worksheet or in a specific area on your current worksheet.

You can refresh a stock quote price at any time by right clicking anywhere within your worksheet and selecting Data Range Properties. Enter a value for how often the stock quote price should be refreshed.

Labels: Customize, General

Use local Help

1. Bring up the Help Task Pane (The F1 key will do this.)
   
   
2. At the bottom of the "See also" box there is a hyperlink: "Office Online Settings"
   
   
3. Click this link; you will get the Service Options dialog box
   
   
4. Uncheck the option: "Search online content when connected"

Office will now use the help files on the local hard drive. It is much faster!
(Editing will affect all Office applications)

In office 2007, left click on the "Connected to Office Online" and choose local



If you need to disable its use through a Group Policy, or in the Registry, see:

Microsoft Support:
How to disable Microsoft Office Online featured links in Office

Be aware that if you do turn it off, you might miss some of the Office online feature, like tutorials and downloads.

Office Online: Get More Out of the Microsoft Office System



See all Topics
excel

Labels: General

More data

An introduction to the benefits of online analytical processing (OLAP)

"Every day we create reams of data in customer relationship management applications, order entry applications, and warehouse management systems. We're drowning in a sea of data. However, even with all that data we don't have a large amount of information. We have the ones and zeros of the transactions, but we don't have the answers we need to simple questions like:

• "Why was March better than February?"
  
• "Where is the sales force having the most success?"
  
• "In what conditions does the sales team struggle with making sales?"

• Oracle 9i makes data warehousing easy to implement
  
• Seven highly effective steps to a smooth data warehouse implementation
  
• Business intelligence is just a few steps away for SAP R/3 users
  
• Resources for designing, planning, and implementing a data warehouse strategy
  
• Making the operational case for data warehousing
  
• TechRepublic Tutorial: Data warehousing defined

Also see:
OLAP Cube

Data Warehousing and OLAP
A Research-Oriented Bibliography

FAQ Excel 2007 – OLAP

Microsoft:

OLAP



See all Topics
excel

Labels: General, Lists, Tips

Double click the handle

F. David McRitchie:
Fill Handle

Microsoft Office Online:
Fill data in worksheet cells

If you don't see the Fill handle:
Click Options on the Tools menu and click the Edit tab.

(Use the Office button in the upper left corner in 2007)
Select or clear the Allow cell drag and drop check box.



See all Topics
excel

Labels: General, Shortcuts, Tutorials

Group sheets

Also:

John Walkenbach:
Making an exact copy of a range of formulas

Microsoft KB:
Run a macro on multiple sheets in Group mode



See all Topics
excel

Labels: General, Tips, Tutorials, VBA

Stick it in Word

Arrange the windows so that both applications can be seen.
(Right-click an empty area of the Task bar and choose "Tile Windows Vertically."

Type your introductory text in the Word document.

Switch to PowerPoint and open the PowerPoint file.

In Slide Sorter View, hold down the Ctrl key and select the slides you want to include.

Drag the selected group of slides onto the Word document.

You will only see the first slide in the document, but if you double-click on the image, the PowerPoint show will run.

It will also work in Excel.

(This, of course assumes that the target machine has PowerPoint or PowerPoint Viewer installed)



See all Topics
excel

Labels: General, Link, Tips

Formatting slip

The formula is filled down the column as long as there is data in an adjacent column.

But wait! I don't see the value. I see the formulas!
In addition, the formulas are still in lower case and the relative references have not been updated.

Easy to fix, I hear you say. Just reformat the column as General.

Nothing happens.

To fix the problem, make sure the column is formatted as General.

Select the first cell. Click in the formula bar and hit the Enter key.

Now double click the Fill handle.

(You could also use Edit>Replace to replace = with =. However, Relative references will be incorrect and unless you have reformatted the whole column as General, any new formulas will still display as text.)

The reverse also causes a problem. In a column formatted as General, enter some formulas.

Now reformat the column as Text. The formulas still work, but if you edit one of them, it reverts to a text display.

Microsoft KB:
Cell Linked to Text-Formatted Cell Shows Formula Not Value

Formulas can, of course, be toggled using CTRL+~ (Tilde)
(Though it really should be called CTRL+` (Grave Accent), since the Shift key is not used.)



See all Topics
excel

Labels: Formulas, General, Troubleshooting

Choose your own location

Word

you can change the default location by going to Tools>Options. On the "File Locations" tab you can modify the storage location.

Excel

Tools>Options. On the "General" tab change the default location.

PowerPoint

uses Tools>Options and the "Save" tab.

Access

Tools>Options and the "General" tab for Databases and Projects

Publisher

Tools>Options "General".

Outlook

will make you take an underground tour into the Registry to change the location to save e-mail attachments.

FrontPage/Expression Web

appears to require the same sort of spelunking.

Labels: Customize, General

Free money (tracker)

Your income

Just your take-home pay, which is what you control and spend.

Cash reserve

A reserve equal to 3-6 months of take-home pay.

Savings

A portion of your income set aside to fund your retirement.

Fixed expenses

Expenses that you must pay over the course of a year.

Replacements

You also must pay to replace things that eventually wear out.

Weekly allowance

Partly discretionary, partly not; paid by cash from your pocket.

Periodic purchases

Discretionary purchases paid by check periodically.

Future purchases

Big-ticket discretionary purchases that you must save for.

Summary

A summary of your income and where it goes—and where you are.

QuickForm

You can switch to this format once you're familiar with the method.

Tips

Ideas to help pare your expenses.

Labels: General

Smile!

1. Edit>Copy the Cell or Range
   
2. Choose the target cell
   
3. Hold down the Shift key and choose Edit>Paste Picture Link

If you're going to do this frequently, go to Tools>Customize. Choose the Commands tab and locate Camera in the Tools category. Drag to place the Camera button on your toolbar.

If the Camera tool is on your toolbar:

1. Select the Cell/Range
   
2. Click the Camera tool
   
3. Move the cursor to the target position and click to insert the linked picture

To create a static picture from cells, or a chart to use in another part of your workbook, or another program:

1. Clear cell gridlines if you do not want them displayed in your picture.
   (Click Options on the Tools menu, click the View tab, and then clear the Gridlines check box")
   
   
2. On the worksheet or chart sheet, select the cells or click the chart you want to copy as a picture
   
3. Hold down SHIFT and click Copy Picture on the Edit menu
   (For the best picture quality, make sure As shown on screen and Picture are selected)
   
4. Click OK
   
5. Select the worksheet or other document where you want to paste the picture
   
6. Edit>Paste.

You can use the Picture toolbar to change the image.
(to display the toolbar, right-click any toolbar and choose Picture)

To paste information you've copied from another program as a picture in Microsoft Excel, hold down SHIFT and click Paste Picture or Paste Picture Link on the Edit menu.


You can, also, create a dynamic linked text box by using the tool on the Drawing toolbar to place the object on the worksheet.

Now click to the Formula box. Type = and the click on the cell you wish to link.

Also see: Copy - Paste Methodology
by Jon Peltier

The process is a little different in 2007. Either add the Camera tool to the Quick access toolbar, or just select the range and drop down the Paste options.

Choose copy as Picture.

Next pick a location and choose Paste as picture.






See all Topics
excel

Labels: General, Link, Tips

More dimensions than Star trek

When a company accumulates a great deal of information, it becomes un-wieldy to work with just basic Excel or Access databases.

There is a database concept called on OLAP cube (On-Line Analytical Processing).

This multidimensional collection of data can be thought of as a 3-D pivot table viewed from flat land.

MSDN:
Just What Are Cubes Anyway?
(A Painless Introduction to OLAP Technology)

OLAPReort.com:
What is OLAP


Wikipedia:
OLAP

Wang.se (Wang Sweden) a Swedish software company:

Create an OLAP Cube



See all Topics
excel

Labels: General, Tutorials

Split the sheets (?)

Recently a large group of friends and I went on a multi-city tour of Europe that lasted a couple weeks. There was a lot of planning that went into this trip and responsibilities for booking different legs of the trip were spread out across the group. How do you efficiently handle paying back multiple people while getting reimbursed for your costs at the same time?

Split Costs

You can download the spreadsheet here:Split_Costs.zip




See all Topics
excel

Labels: General, Templates, Tips, Tutorials

Game with Excel

• Excel fun
  
  
• 3D Viewer
  
  
• Battleship
  
  
• Blackjack
  
  
• Breakout
  
  
• Golf Stats
  
  
• Mastermind
  
  
• Maze
  
  
• Minesweeper
  
  
• Reversi
  
  
• Rubix
  
  
• Slots
  
  
• Sudoku Solver
  
  
• Tetris
  
  
• Video Poker

Labels: General

Design suggestions

European Spreadsheet Risks Interest Group:
Spreadsheet mistakes - news stories

John F. Raffensperger:
(oldies but . . .)
Spreadsheet Style

Microsoft Assistance:
Worksheet design strategy

Raymond R. Panko, PhD University of Hawaii
What We Know About Spreadsheet Errors




See all Topics
excel

Labels: General, Tips

Numbers from the ether

"The Excel 2007 Web Data Add-In makes it easy to use a Web page as a data source in Excel.

The add-in plugs into Excel 2007 seamlessly, its entry point located on the Data Tab under the From Web option. The system extracts data by learning from a user’s selection of data they wish to capture into Excel. The more selections, the more the system is trained."

Labels: Addins, General

Don't hide

• Stock quote from MSN MoneyCentral
  
  
• Company report from MSN MoneyCentral
  
  
• Recent news on MSN MoneyCentral
  
  
• Insert a refreshable stock price
  
  
• Remove the Smart Tag
  
  
• Smart Tag options (This brings up the Smart Tags tab on the AutoCorrect menu.)

Complete tasks quickly with Smart Tags




How to turn on smart tags.

Smart tag functionality is turned off by default. Before you can use smart tag functionality, you must turn on smart tag recognition. To do this, follow these steps, as appropriate for the version of Excel that you are running.

Microsoft Office Excel 2007

1. Click the Microsoft Office Button, and then click Excel Options.
   
   
2. Click Proofing.
   
   
3. Click AutoCorrect Options.
   
   
4. In the AutoCorrect dialog box, click the Smart Tags tab.
   
   
5. Click to select the Label data with smart tags check box.
   
   
6. In the Recognizers box, click to select the check boxes next to the specific smart tag recognizers that you want to turn on, and then click OK.
   
   
7. Click OK to close the Excel Options dialog box.

Microsoft Office Excel 2003 and earlier versions of Excel

1. On the Tools menu, click AutoCorrect Options.
   
   
2. In the AutoCorrect dialog box, click the Smart Tags tab.
   
   
3. Click to select the Label data with smart tags check box.
   
   
4. In the Recognizers box, click to select the check boxes next to the specific smart tag recognizers that you want to turn on, and then click OK.
   

Labels: General, Shortcuts, Tips

All(most) all you need to know

• Add numbers
  
• Subtract numbers
  
• Multiply numbers
  
• Divide numbers

Labels: Formulas, General, Tutorials

Spokes of the web

• Excel Add-ins
  
  
• Excel Help
  
  
• Excel Password Recovery
  
  
• Excel Templates
  
  
• Excel Tips & Tricks
  
  
• Excel Tutorials
  
  
• Excel VBA
  
  
• Free Excel Add Ins
  
  
• Spreadsheet Research

Labels: General, Link, Lists

Geek fame

"You probably have a document you use over and over again, something you created to solve a particular problem. You may even find yourself occasionally sending the document to others in e-mail because it's so useful. Now you can share your clever solution with everyone who uses the 2007 Microsoft Office system!

People like you all over the world are allowing others to download and use their document templates on Office Online. Some of these templates have tens of thousands of downloads. They were submitted by people who either wanted to help others or show their great solutions. You can, too.

Labels: General, Templates

2007 choices

Office 2007 uses OfficeArt to format text boxes, graphics and pictures.

It's available in Word, Excel , and PowerPoint, but it is most active in PowerPoint and Excel.

Here's a description:

Office PPT Art

Also:
Reflections



See all Topics
excel

Labels: General

Excel reading

Labels: General, Tips

More flexibility

Lots of limits have been changed with 2007. The size of a worksheet is now 1,048,576 rows by 16,384 columns. The number of undo levels has gone up to 100.

Here are some more changes:

• Worksheet and workbook specifications and limits
  
  
• Calculation specifications and limits
  
  
• Charting specifications and limits
  
  
• PivotTable and PivotChart report specifications and limits
  
  
• Shared workbook specifications and limits

Labels: General

Level talk

1. Close any programs that are running.
   
   
2. Click Start, click Run, type regedit in the Open box, and then click OK.
   
   
3. In Registry Editor, expand one of the following registry subkeys, as appropriate for the version of Excel that you are running:
   
   Microsoft Office Excel 2007
   

   HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options

   
   Microsoft Office Excel 2003 uses Office\11.0\
   Microsoft Excel 2002 uses Office\10.0\
   Microsoft Excel 2000 uses Office\9.0\
   
   
4. On the Edit menu, point to New, and then click DWORD Value. Select New Value #1, type UndoHistory, and then press ENTER.
   
   
5. On the Edit menu, click Modify.
   
   
6. In the Edit DWORD Value dialog box, click Decimal under Base. Type a value between 0 and 100 in the Value box, click OK, and then exit Registry Editor.
   
   
7. Start Excel. Excel stores an undo history for the number of actions that you specified in step 6.

Sub ClearUndo()
    Range("A1").Copy Range("A1")
End Sub

Labels: Customize, General, Macros, Tips

Eavesdrop on the experts

Labels: General, Tips

No add-ins needed

• Raw text, HTML, XHTML, Microsoft Word, RTF, PDF, PS, Open Office, Star Writer, Pocket Word, Word Perfect
  
  
• CSV, dBase, Microsoft Excel, Pocket Excel, Lotus 123, Quattro Pro, Star Calc, Open Office spreadsheet
  
  
• MathML, Star Math, Open Office math
  
  
• Microsoft Powerpoint, Star Impress, Open Office presentation

Convert files into universal formats like Adobe PDF, PS (PostScript) or CSV to print, fax or simply read them on any computer, without special software.

Learn morse code with the text to morse converter ;-)

Labels: General, Tips

More than you wanted to know

1. Click the Microsoft Office Button, and then
   
   
2. Cick Access Options, Excel Options, PowerPoint Options, or Word Options.
   
   
3. Click Resources
   
   
4. About Program Name, click About.
   Note Program Name is the name of the program you are in, for example, About Microsoft Office Word 2007.
   
   
5. To see information about your computer, in the About Program Name dialog box, click System Info.

Labels: General

When to use one or the other

Use Access when you:

• Require a relational database (multiple tables) to store your data.
  
  
• Might need to add more tables, in the future, to an originally flat or nonrelational data set.
  
  
• Keep a very large amount of data (thousands of entries).
  
  
• Keep data that is mostly text.
  
  
• Rely on multiple external databases to derive and analyze the data that you need.
  
  
• Need to maintain constant connectivity to a large external database, such as one built by using Microsoft SQL Server.
  
  
• Want to run complex queries.
  
  
• Need many people working in the database and you want robust options that expose that data for updating.

Use Excel when you:

• Require a flat or nonrelational view of your data (that is, you do not need a relational database with multiple tables).
  
  
• This is especially true if that data is mostly numeric - for example, if you want to maintain a financial budget for a given year.
  
  
• Want to run primarily calculations and statistical comparisons on your data - for example, if you want to show a cost/benefit analysis in your company's budget.
  
  
• Know that your dataset is manageable in size (no more than 15,000 rows).

Labels: General