Recent Posts

Excel

You asked about VLOOKUP

People are crazy for Excel’s VLOOKUP function, and why not? Among other things, VLOOKUP is known for its rugged good looks and unparalleled martial arts ability. In all seriousness, VLOOKUP is one of the most widely used, versatile functions in Excel. You typically use it to quickly look up and extract specific bits of information from a big list of data. In the following example, I’ve instructed VLOOKUP to search…

Excel

Generate invoice numbers in Excel

If you need a way to create invoices in Excel, you can use one of the many invoice templates on Office.com. While these templates are a great starting point, they don’t automatically generate unique invoice numbers—you need a macro for that. In this video, Excel MVP Bill Jelen shows you how to create a couple of macros to generate invoice numbers. The first macro automatically increments the number and then…

Excel

VBA tip: Limit the number of times a file can be opened

Suppose you want to send someone a demo workbook, but you don’t want that workbook to be used more than a certain number of times, perhaps because you want to be paid for your work. In today’s VBA tip, Excel MVP Bob Umlas shows you how to use SaveSetting and GetSetting statements to set a limit on the number of times a file can be opened.

Excel

Create smashing mashups with Excel

If you’re a web developer (or even if you’re not), you’ve doubtless heard of mashups—apps or web pages that combine existing functionality from different sources to create something entirely new. It’s now possible to create cool spreadsheet-based mashups by combining features from Excel Web App—specifically, the embedded workbook feature—with existing JavaScript APIs. Read on to see a couple of demo mashups, and learn about our new site for web developers,…

Excel

Tracking small projects in Excel

It goes without saying that Microsoft Project is THE program to use if you need to manage large projects. But what if you manage smaller projects? Can you do that in Excel? Sure, but life will be easier if you start with a template that is specifically designed to facilitate project management. With that in mind, PowerPoint expert Glenna Shaw created a free project plan template for tracking projects in Excel. You can use this template to…

Excel

The Excel part of mail merge

Hey, the holidays are fast approaching, which means you’ve got to get your cards signed, sealed, and delivered! This post goes out to those of you who keep your address list in Excel and need to figure out how to use it to create mailing labels in Word.  Creating labels can be intimidating, mainly because there are a number of steps and you’re typically working across different programs—in this case,…

Excel

Now where on the network did I save my workbook?

If you commonly share workbooks that are saved on your network, consider adding the Document Location box to your Quick Access Toolbar. This box shows you exactly where your workbook is located. If you can see the path, you can easily paste it into an email message and send it to people. This is way better than sending around big file attachments!

Excel

Two tips for faster worksheet navigation

If your workbook contains a ton of worksheets, it can be a hassle to navigate to just the right sheet. For one thing, you often can’t see all the sheet names at the bottom of the workbook. Sure, you can move around by using the four navigation buttons to the left of the worksheet tabs, or by pressing Ctrl + Page Up or Ctrl + Page Down, but there are faster ways to jump from…

Excel

Apollo 11 & Excel – How did we do that?

A couple of weeks ago, as part of our History Reimagined video series, we posted a video to show you how Excel might’ve helped the team at NASA work through some of the tensest moments in American history. After that post, some of you asked us how we achieved certain effects. Today, Sam Radakovitz from the Office team points you to the source workbook and data used in the video and…

Excel

Hyperlinks in Excel: Hot or not? (videos)

Have you ever: Inadvertently activated a hyperlink when you only meant to select the cell? Imported a bunch of URLs that aren’t hot – but need to be? Imported a bunch of URLs that are hot – but don’t need to be? Pasted in links with “friendly” display text, but wanted to show URLs instead? Wanted to stitch together URLs from bits of text in various columns? If you answered…