Background images for a worksheet are automatically repeated over and over (tiled) by Excel. This tip describes a workaround you can use to minimize the distracting effect of tiling.

Read this ExcelTip: Non-Tiled Background Pictures
Microsoft Excel Tips - Learn Excel Faster!

There are a few programs whose output I can identify immediately. One is Quickbooks. When I get an invoice or a quote from someone using Quickbooks, I know it right away. Today, I was admitted to the...

continue reading...

El coche es un bien de consumo duradero de nuestro tiempo. Hoy en día no podemos imaginarnos la vida sin coches. Todos, de alguna forma, lo utilizamos habitualmente como medio de transporte. ...

sigue leyendo...

Need to edit the data within a cell? There are any number of ways you can perform the edit; this tip documents them all.

Read this ExcelTip: Editing Individual Cells
Microsoft Excel Tips - Learn Excel Faster!

Remember when you needed to create outlines for your writing when you were in school? Word includes outlining capabilities that can make it easy for you to organize your thoughts and improve your writing.

Read this WordTip: Understanding Outlining in Word
Microsoft Word Tips - Learn Word Faster!

You can use conditional formatting to add shading to various cells in your worksheet. This tip shows how you can shade cells based on whether a value is odd or even.

Read this ExcelTip: Shading Based on Odds and Evens
Microsoft Excel Tips - Learn Excel Faster!

Finding the built in functionality in Word 2002 & 2003 for saving your document as a MS-DOS format.

Read this WordTip: MS-DOS with Line Breaks Format in Word 2002 and Word 2003
Microsoft Word Tips - Learn Word Faster!

According to Do You Know What Planned Parenthood Actually Does?, “the Susan G. Komen Foundation has announced they will stop funding Planned Parenthood for breast cancer exams and other...

continue reading...

For those of us who crunch words instead of numbers, Excel can be intimidating. We don't know the difference between a workbook and a worksheet, and for sure don't know to ask about conditional...

continue reading...

Put a page break at the beginning of a shaded paragraph and you may be surprised at what you get on your printout. This tip examines the problem of extra shaded lines at the bottom of a printed page and what you can do to get rid of them.

Read this WordTip: Extra Shaded Lines
Microsoft Word Tips - Learn Word Faster!

Need to get rid of extraneous spaces before or after the text in a string? VBA provides three different functions you can use to make the removal quick and easy.

Read this ExcelTip: Trimming Spaces from Strings
Microsoft Excel Tips - Learn Excel Faster!

Count How Many Times a List of Values Occurs in a Range (or How Can I Simplify My Formula) Today in Formula Forensics we look at how to count how many times a range of values occurs within a Range...

continue reading...

When creating a macro, you may need to figure out how many fonts are available to Word. You can do this using the FontNames collection.

Read this WordTip: Determining the Number of Fonts Available
Microsoft Word Tips - Learn Word Faster!

Excel can, once in a while, try to be a "multimedia program." Here's how you can add short sound files to your worksheet that can act as annotations.

Read this ExcelTip: Inserting a Voice Annotation in Your Worksheet
Microsoft Excel Tips - Learn Excel Faster!

In the past here at Chandoo.org and at many many other sites, people have asked the question "How can I display a number multiplied or divided by 10, 100, 1000, 1000000 etc, but still have the cell...

continue reading...

I currently have Excel 2003 and Excel 2007 installed. I’m pretty happy with this arrangement from an Excel standpoint, but Word and Access are always trying to install themselves. Happy or not,...

continue reading...

Microsoft Excel now is becoming the most popular spreadsheet in the world, and is already 22 years since being introduced in 1985, where the first version of Excel was released for the Mac in 1985,...

continue reading...

[enlarge] This is a World Cup 2010 Schedule and Scoresheet written in Excel. You can use this spreadsheet as your FIFA tournament schedule reference. It is developed by the author based on FIFA world...

continue reading...

[enlarge] You can use this weekly class planner spreadsheet to plan your class weekly activities. There is automatic formula inside the spreadsheet so you can type your plan once, and the formula...

continue reading...

The Open dialog box is one that few of us think about, but you can control how it behaves with a little bit of macro coding. This tip provides a few examples you can use right away.

Read this WordTip: Modifying Behavior of the Open Dialog Box
Microsoft Word Tips - Learn Word Faster!