Let’s have some INDEX() and MATCH() fun in our Lookup function series. by David Goodmanson On their own, the INDEX() and MATCH() functions are fairly straightforward but when they are combined they create a very powerful Lookup tool. Both functions have 3 parts to their arguments. INDEX(range, row_number, column_number) and
Cross-referencing is an imposing name for something we’re all familiar with in books, especially reference books. Microsoft Word makes it much easier to do. A cross-reference is simply a mention or link in the text to another part of the same document. In olden days (thirty years ago ) you
How to print a document when the paper sizes are different. On our new Twitter account we saw this question: “When I send an Excel file to someone, should I have to set it up so they can print? I don’t know the printer/size they use.” Part of that answer
Using Vlookup in Excel to work out tax, fees or commission from a table by David Goodmanson In part 1 we covered the basics of VLookup, let’s use it to calculate tax for a list of employees and their salaries. We’ve chosen this practical example because it contains a fixed
How to format a Word or Excel document to print on someone else’s computer. On our new Twitter account we saw this question: ” When I send an Excel file to someone, should I have to set it up so they can print it? I don’t know the printer/size paper
A new wave of fake job applications and responses isn’t caught by Outlook. Spammers aren’t completely stupid, they release a new type of infected email that isn’t caught by the Outlook Junk Email filter even when it’s set to ‘High’ ( Actions | Junk E-mail | Junk E-mail Options |
How to configure the list of recently used documents in Office and the glaring omission. The Most Recently Used (MRU) list is the list of documents you’ve recently opened in Word, Excel or PowerPoint. It is a handy way to reopen documents you’re currently working on but could be better.
Office Watch explains what can happen with Show Formulas in Excel and the simple fix. A slip of the fingers can make all your numbers disappear! An Office Watch reader wrote in a panic, her vital worksheet had gone crazy showing only formulas instead of numbers! She was the victim
Sections are in every Word document – here’s how to use them to make Word do what you need. In the last issue I described how to omit the page number on the last page of a document by using a section break and “de-linking” the header/footer between the sections.
Vlookup scares too many Excel users but it should not. David Goodmanson shows how easy and incredibly useful it can be. How can your grab a value from a separate Excel list and insert it into your current calculation? Vlookup or Hlookup is the main answer in Excel. We’ll
From: Rose Vines How do you omit the page number on the final page of a Microsoft Word document? How do you omit the page number on the final page of a Word document? I was asked this recently by someone who is using Lulu.com’s self-publishing service. Lulu had asked
It’s a simple question about ordering monthly data in Word – there’s many answers which give a glimpse into what you can do with Office. ” I want to have a monthly log of items, each month separated by a page or section break, but be able to “toggle” the
There are plenty of ways to make an Adobe Acrobat PDF files from Microsoft Office programs. Here’s a quick guide to some of the options including free downloads. There are plenty of ways to make an Adobe Acrobat PDF files from Microsoft Office programs. PDF files retain most of the
How can you toggle between costly color printing and cheaper Black & White or Grayscale quickly without delving into the print properties each time you want to switch? Over at Citibank they are on an economy drive, part of which is cutting back on color printing. That’s no surprise because
A current example of what to watch for and what to do when Outlook doesn’t detect a new type of spam message. In the last day or so we’ve started seeing some obvious spam messages in our Inbox. ‘Obvious’ to us but not to Outlook 2007’s Junk e-mail filter on
The Office 2007 can disappear to make more screen room available for your document – not only that but it does so intelligently. The Office 2007 can disappear to make more screen room available for your document – not only that but it does so intelligently. The ribbon can be
The Quick Access Toolbar (QAT) in Office 2007 programs have their own shortcut keys using the number keys. The Quick Access Toolbar (QAT) in Office 2007 programs have their own shortcut keys using the number keys. Alt + 1 for the first icon on the QAT, Alt + 2 for
Here’s some more tips for using Office 2007 without the mouse. Here’s some more tips for using Office 2007 without the mouse. As we’ve mentioned before, much of the same shortcuts that applied for earlier versions of Office will also apply with Office 2007. Plus there’s new features that make
If you frequently find yourself wanting to edit the same document you were using in your last Word session, you can create a shortcut which does just this. If you frequently find yourself wanting to edit the same document you were using in your last Word session, you can create
Here’s how to delete the Microsoft Word document you’re currently editing. Here’s a rather more complex macro you might find useful. This one lets you delete the document you’re currently editing. Word normally won’t let you do this: you must first close the document, then delete it. That’s a sensible
How to copy revision information from one Word document to another. The Word’s Spike feature will cut and paste revisions in a document plus standard paste will work if you know the trick. We love feedback from readers, especially when it uncovers some peculiarity in Microsoft Office. Anne C. read
Word’s Spike lets you quickly reorganize snippets of text and graphics. You grab the snippets from different locations in your document, place them one by one on the spike, then use the Insert From Spike command to paste them as a block into your document. Microsoft has long produced software
Excel’s options for shading alternate rows are limited and sometimes ugly. Here’s how to take full control and design the way you like I sometimes wonder whether Microsoft spends so much on its programming budget it has little left over to spend on designers. This thought often crosses my mind
An explanation of the logic behind alternate shading rows or columns in Excel. If you’re content with this result and don’t need to know the nuts and bolts, class dismissed. If, on the other hand, you’d like to understand how we end up with a checkerboard pattern from this expression,
