Category Archives: From the Official Excel Team

In honor of VLOOKUP Week, MVP Bill Jelen has created a VLOOKUP tutorial for those of you who have a basic working knowledge of Excel but want to improve your skills. This tutorial assumes you’ve heard about VLOOKUP and its … Continue reading →

VLOOKUP Week has ended. The brainchild of Excel MVP Bill Jelen, the idea inspired all things VLOOKUP, including VLOOKUP odes, haikus, vampires, and a way to track shark attacks. Setting all fun aside–Excel experts created a crazy number of useful … Continue reading →

Ugh. Excel. It’s not as intuitive as a Word doc, and not as aesthetically pleasing as a PowerPoint presentation. If you’re more creative than analytical, you might feel as though it’s dry and boring and filled with numbers you’d rather … Continue reading →

Millions of people using Excel don’t get why they see the “circular reference” error message right after they’ve entered a formula. The message means that your formula is trying to calculate its own cell–kind of like when a dog chases … Continue reading →

Excel comes with lots of predefined chart types, including column, line, pie, and so on. However, many of you ask how to make other kinds of charts, such as floating column charts, Gantt charts, combination charts, org charts, flow charts, hierarchy charts, … Continue reading →

We show you how we used an ActiveX list box control and some VBA code to allow our users to enter multiple choices in cells. …(read more)

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 … 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! Can’t remember all those Excel keyboard shortcuts? Now you don’t have to! There are a lot of keyword … 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 spreadsheets. Well, last week, Rob Collie (a … 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 investors the path to profitability. We worked with @Guy Kawasaki … Continue reading →