Create a Macros menu to make your most common macros immediately available.

Read this WordTip: Making Macros Readily Available
Microsoft Word Tips - Learn Word Faster!

When working with dates, you may need to figure out all the dates on which weeks end in a given year. There are several formulaic ways to accomplish this task, as described in this tip.

Read this ExcelTip: Calculating Week-Ending Dates
Microsoft Excel Tips - Learn Excel Faster!

So the boy has been taking guitar lessons for about 2 months now. He's getting pretty good. Pretty soon, I'll send him out to play on the streets for money (like a monkey).   Now, I've always wanted to play the Bass guitar. I love the brooding rumble of the bass…I like the walking bass lines…I like [...]

Thanks to Dan Battagin for writing this blog post.  OK, so I'm sure everyone knows about the Freeze Panes feature in Excel - it's been around forever, and it's pretty useful in certain circumstances where you want to keep a row (or more) of data at the top of the sheet, or...

This week, learn how to protect a PowerPoint presentation and share your knowledge on Excel. by Susan Harkins

When working with a table, Word allows you to merge adjacent cells together to form a single unit. This tip explains how to take previously merged cells and split them apart again.

Read this WordTip: Splitting Table Cells
Microsoft Word Tips - Learn Word Faster!

One of the important configuration files for Excel is known as the XLB file. You should periodically make backups of this file, in order to protect the customizations you’ve performed on Excel’s toolbars.

Read this ExcelTip: Disappearing Toolbar Buttons for Macros
Microsoft Excel Tips - Learn Excel Faster!

In October 2008, I have started an ambitious series of posts on this blog called - Spreadcheats. These are little tricks, nuggets, tutorials on using Excel that would make anyone a spreadsheet...

more at http://chandoo.org/wp

Hi there! Many times it is a newsgroup post which triggers me to do a writeup on a specific subject. This time, a user asked how he could import a csv file every month, without having to go through...

If you've ever tried to open a text file, you have probably used the Text import wizard. If you have ever opened a CSV file, you have probably noted you can't set up how it gets imported. The text import wizard does not start for these file types. What if you have the situation where you get files with similar structure, which need the same text import settings over and over? How do you import the data from those files into the same worksheet each time, without having to re-define the import settings over and over again? I'll tell you.

Given the problem I have with images and blog posts, I’m trying something new. I uploaded the content of the post to my website and am using an iframe to post it here. Yes, the UI experience...

How to specify the distance between an equation's baseline and any prime symbols in the equation.

Read this WordTip: Setting Prime Height Spacing in the Equation Editor
Microsoft Word Tips - Learn Word Faster!

Amazon says it's official. My new book will be out on April 5th. This book is written for all you Excel users who know that expanding your skill-set to include Access can make you more productive. I guide you through analytical and reporting benefits of Access, and show you how you can integrate Excel and Access [...]

La curva temporal de tipos de interés relaciona el rendimiento homogéneo (en términos TAE, para plazos inferior al año), de los bonos y obligaciones, con el plazo de tiempo hasta su vencimiento. En...

más en http://economia-excel.blogspot.com

Tired of erasing holes in your graph paper or perhaps, even starting over from scratch? Use Excel instead of graph paper! by Susan Harkins

We were trying to figure out the odds on keno the other day. There’s something about statistics that doesn’t create appropriately strong synapses in my brain. I got an A in stats in...

Justin James gathers the information you need to make the right decision on applying Microsoft's March 2010 patches in your organization. by Justin James

You can update fields and links automatically when you print your document, but what if you want them updated when you open or close the document? That is not as easy of a proposition, but there are ways to fulfill the request, as shown in this tip.

Read this WordTip: Automatically Updating Fields and Links
Microsoft Word Tips - Learn Word Faster!

When you print out a filtered worksheet, you may want some sort of printed record as to what filtering was applied to the worksheet. Here’s a couple of ways you can get that printed record.

Read this ExcelTip: Showing Filter Criteria on a Printout
Microsoft Excel Tips - Learn Excel Faster!

Visual Importer ActiveX loads data into any database. It works directly with Excel, Access, DBF, Text files, Oracle, MS SQL Server plus full support for ODBC. Thousands of records per second. Source data filtering, date formats and calculations, full support for unicode. Very easy to use. VImpX is capable of...