You already know that you can add breaks to your document, to force some sort of change to the text. If your document is quite long, finding these breaks can be a chore unless you know how to use Find and Replace to locate these special characters.

Read this WordTip: Searching for Breaks
Microsoft Word Tips - Learn Word Faster!

If you need to add tomorrowÂ’s date to a worksheet, you can do it using simple math. The formulas provided in this tip are both illuminating and helpful.

Read this ExcelTip: Inserting Tomorrow's Date
Microsoft Excel Tips - Learn Excel Faster!

It's summer time and blog readership will be down. So I'm saving my good Excel and Access tricks for later. Right now, I'm continuing my 'Road of the Excel Bastards' series. Today's Excel Bastard is Chandoo!   The only good picture I could find was very small, so I zoomed in.   Chandoo (aka Purna Chandra) came out of nowhere [...]

From Wikipedia: Runways are given a number between 01 and 36. This indicates the runway’s heading: A runway with the number 36 points to the north (360°), runway 09 points east (90°), runway 18...

Use implicit And and Or operators with Excel's Advanced Filter feature to create complex, but powerful, filtering combos. by Susan Harkins

New and Improved Announcing the new and improved Peltier Tech Chart Add-Ins for Microsoft Excel. They were pretty good to begin with, but there have been some changes. I’ve updated all of the...

When you need to test an object’s property, there are times when you must also test that the object exits. E.g. If Not rControl Is Nothing Then     If IsEmpty(rControl.Offset(0,...

If you routinely need to print more than one copy of a document, you’ll love the ideas presented in this tip. There’s even a way that you can make individual documents “remember” how many copies should be printed.

Read this WordTip: Remembering Copies to Print
Microsoft Word Tips - Learn Word Faster!

Sometimes, when importing data created by other programs, you may find that there is too much for Excel to handle. Here’s how you can still accomplish the task.

Read this ExcelTip: Importing Huge Data Files
Microsoft Excel Tips - Learn Excel Faster!

It's summer time and blog readership will be down. So I'm saving my good Excel and Access tricks for later. Right now, I m continuing a series called 'Road of the Excel Bastards'. This is my take on a series called Road of the Excel Masters started a long time ago by Excel MVP, Colo. In [...]

In this and next 5 posts, we are going to learn how to build a financial model to do project evaluation using Excel. The 6 parts of this tutorial are, Introduction to Financial Modeling Building a...

more at http://chandoo.org/wp

I’ve been saying for years that I was going to get rid of Personal.xls and put all that code into add-ins. Well, I finally did it. Last week, Code for Excel and Outlook posted Which Macro...

Word allows you to add formulas (using fields) to table cells. It is easy for these formulas to get quite long, and then they may not be visible within the cells, but instead appear cut off. This tip explains how you can make these formulas more visible.

Read this WordTip: Viewing Formulas in Table Cells
Microsoft Word Tips - Learn Word Faster!

Excel provides a couple of different ways that you can quickly duplicate drawing objects in a worksheet. Committing these shortcuts to memory will help make your work with drawing objects easier than ever.

Read this ExcelTip: Quickly Duplicating Drawing Objects
Microsoft Excel Tips - Learn Excel Faster!

Process Manager is and what you can do with it:You can easily see whats happening behind the desktop, Which processes are running on your computer, You can see all modules which are loaded, or only those used by a particular process, You are the master: Process Manager lets you close...

Batch XLSX to XLS Converter is an ultra fast Excel XLS to XLSX, XLSX to XLS batch converter. It supports powerful search for a lot of files and Drag and Explorer Context. Simple interface allows you to stop or pause and continue converting in any time and you can save...

Batch XLS TO PDF Converter is a Excel to PDF, XLS/XLSX to PDF Batch Converter that can convert Excel XLS/XLSX to PDF Portable Document Format easily. Batch XLS TO PDF Converter supports powerful search for a lot of files. A PDF publisher for Excel. Batch XLS TO PDF Converter supports...

Financial Link is an Excel add-in that loads various financial information into Excel. You can load trading quotes (price, high, low, close), financial reports (balance sheet, income statement, cash flow), analysts estimates, ratios(p/e, price to book, enterprise value). Financial Link can load price histories into your Excel. The add-in uses...

We want to thank all of you who submitted entries for our Excel challenge. We had great entries that were well designed using Excel 2010 features, VBA and the user interface. Many of you are as passionate about Excel as we are and we thank you for your feedback. We extend our congratulations to...

If you refer to the same value in an Excel sheet often, treat it as a constant. by Susan Harkins