Blogs

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. So what's a worksheet...

It's still January. There's still time to share the most popular posts on the Excel blog in 2011. Thanks for reading them! Can't remember all those Excel keyboard shortcuts? Now you don't have to! There are a lot of keyword shortcuts in Excel. You can scroll through a long list of them on Office.com, or you can download Quick Reference Cards from our blog and pin them to your corkboard. There are cards for Keyboard shortcuts with theCtrl keys , Keyboard shortcuts with Function keys...

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 ) Read More...

If you need a way to create invoices in Excel, feel free to use one of the many invoice templates on Office.com. While these templates are a great starting point, they won't automatically generate unique invoice numbers for you—you need a macro for that. Fortunately, Excel MVP Bill Jelen created a short video that shows you how to create just such a macro. Enjoy! ...( read more ) Read More...

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 limit the number of times a file can be used by using simple SaveSetting and GetSetting statements. ...( read more ) Read More...

Introduction In the beginning of this year I decided to explore Real Studio (formerly Realbasic, RS) which is a full featured cross-platform software development tool. With it we can create a wide range of applications, from small tiny utilities to enterprise applications that target Mac OS X, Windows, Linux and the web. Initially I had [...] Read More...

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