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...

It's still January. There's still time to share the most popular posts on the Excel blog in 2011. Thanks for reading them! The first one is--you guessed it--about keyword shortcuts.  From the...

continue reading...

15 Spreadsheet Formatting Tips For the last couple years I’ve been meaning to pull together some of the tips that I’ve learned working on the Excel team about how to make nice looking...

continue reading...

You've finished your business plan and polished the pitch for investors. As an entrepreneur you know what comes next: number-crunching. To clinch funding, you need a financial projection that shows...

continue reading...

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...

continue reading...

Need a plain-vanilla calendar for your business which shows the year in a glance? Or the kind that your local hardware passes out for free (marketing) at the end of the year? Free 2012 Excel...

continue reading...

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...

continue reading...

One of our Excel MVPs—Jan Karel Pieterse—emailed us this week suggesting we take a look at the online tutorial he created about Excel Mashups. We did, and now we want to share it with...

continue reading...

At this point in the holiday season if you’re like me, you’re over budget. Yesterday I started worrying about that cashmere sweater I bought for one sister-in-law and the sweatshirt I...

continue reading...

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...

continue reading...

This week, the Excel team here at Microsoft received the tragic news that Excel MVP Nathan Oliver passed away unexpectedly last weekend. Nate was a vital member of the MVP community who loved sharing...

continue reading...

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,...

continue reading...

This post written by Daniel Ferry, an Excel MVP, chronicles how he and Beth Melton, a fellow MVP, designed a Gradebook template in Excel that makes teachers’ lives a whole lot...

continue reading...

There's lots of data out there: LOTS. The digital universe is about eight hundred thousand petabytes (that's eight hundred million gigabytes). Your business is no doubt contriubting to that number...

continue reading...

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...

continue reading...

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...

continue reading...

What should I wear to the party next week? Which hair style suits me best? Your Facebook friends no doubt have strong opinions about these weighty matters, so why not create a quick poll...

continue reading...

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...

continue reading...