Excel Blog

Excel: The Basics (Video)

Emily Warn — Wed, 01 Feb 2012 17:38:00 GMT

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 formatting (a cool way to visually display data). Then one day your boss asks you to create a report--with numbers. Gulp.

In this video, the Office 911 emergency responders show a beginning Excel user how to add a table to a worksheet so she can better organize and view her data.

...(read more)

Five most popular posts on the Excel blog in 2011

Emily Warn — Thu, 26 Jan 2012 19:03:00 GMT

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 post, you can download Quick Reference Cards to pin to your corkboard.

...(read more)

Yes, it is possible to create nice looking spreadsheets

Diego M. Oppenheimer — Thu, 19 Jan 2012 21:23:00 GMT

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 spreadsheets. Well, last week, Rob Collie (a previous Excel Program Manager, and now CTO at Pivotstream and author of PowerPivotPro.com) beat me to it with his post “In the Browser, Aesthetics Yield a Greater Return.”

...(read more)

Guy Kawasaki's guide to creating a financial forecast in Excel

Emily Warn — Wed, 18 Jan 2012 00:46:00 GMT

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 investors the path to profitability. We worked with @Guy Kawasaki to guide you through creating a financial forecast that will wow funders.

...(read more)

Generate invoice numbers in Excel

Anneliese Wirth — Thu, 12 Jan 2012 18:50:00 GMT

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 clears cells on the worksheet so you can start fresh on the next invoice. The second macro lets you save a copy of the invoice with a unique file name.

...(read more)

Beyond spreadsheets: Spiffy Excel calendars for 2012

Emily Warn — Fri, 06 Jan 2012 20:56:00 GMT

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 calendars are now available.

...(read more)

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

Anneliese Wirth — Wed, 04 Jan 2012 19:51:00 GMT

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.

...(read more)

Excel mashup tutorial

Emily Warn — Thu, 22 Dec 2011 20:12:00 GMT

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

...(read more)

Last-minute budget tips for those last-minute gifts

Roxanne Kenison — Tue, 20 Dec 2011 18:56:00 GMT

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 bought for the other. It’s back to shoping this evening to try to even it out.

This time when I’m wandering the aisles, I’ll check my Excel holiday budget on my phone. I saved it on SkyDrive—Microsoft's free cloud service—so that I can take a look to remind me what I bought for whom and for how much. My budget is a customized version of the holiday budget template we made available in early November.

Read more to learn how to create yours and access it on your phone.

...(read more)

Create smashing mashups with Excel

Anneliese Wirth — Thu, 15 Dec 2011 19:00:00 GMT

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

...(read more)