Results for:
excel 2010

• Our eight best tutorials on Excel charts

  30 May 2012

  Excel spreadsheets are all about numbers. But tons of numbers are often not the most effective way to communicate. That's where charts come in handy. Charts can display numeric data in a graphical format, making it easy to understand large quantities of data and the relationships among data. If you want...
• What's the dif? Gridlines vs borders in spreadsheets

  23 May 2012

  A lot of you want to know the difference between gridlines and borders. Gridlines help you work in a spreadsheet, and borders help you highlight important information in one for your audience. Gridlines appear automatically so you can see how your data is organized into rows and columns; borders need...
• Split and merge data in URLs

  16 May 2012

  (Who could be better than a Business Intelligence analyst at teaching us a thing or two about Excel? We asked our own number-crunching wizard Stacey Armstrong to share some Excel tricks she's learned along the way. Check out her first trick Resizing column widths in pivot tables . ) Issue: Inefficient...
• Quick Trick: Resizing column widths in pivot tables

  14 May 2012

  (Who could be better than a Business Intelligence analyst at teaching us a thing or two about Excel? We asked our own number-crunching wizard Stacey Armstrong to share some Excel tricks she's learned along the way.) Issue: Excel automatically makes column widths too wide I often work with pivot tables...
• Using multiple criteria in Excel Lookup formulas

  26 Apr 2012

  (This post is written by JP Pinto, the winner of the Great White Shark Award given for the best article written about VLOOLUP during VLOOKUP Week . We asked JP to share more of his Excel wisdom with you. JP Pinto blogs at Excel-User.com , where he writes Excel articles for common users to help improve...
• Merging and splitting cells or data

  12 Apr 2012

  (First published in April 2011, this post remains very popular with customers.We thought others would like to know about it, too, so today we're moving it back to the top slot on the Excel blog home page.) The title of this post sounds simple. Should be easy to do, right? But customers tell us that it...
• And the winner of the VLOOKUP Great White Shark Award is...

  11 Apr 2012

  JP Pinto! Congratulations! His post was one of seven chosen by Bill Jelen as the most innovative ones published during VLOOKUP Week . He won a copy Bill Jelens book Microsoft Excel 2010 In Depth . You can find links to all seven posts and see the voting results in our wrap-up post of VLOOKUP Week . JP...
• Excel: Not just for geeks

  6 Apr 2012

  Guest writer Divya Bahl is a blogger for Her Campus , a popular site which offers a guide to life for college women. 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...
• VLOOKUP Week wraps up: Vote for your favorite post

  4 Apr 2012

  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 and innovative applications of VLOOKUP in seven days...
• VLOOKUP Tutorial: Updating prices in a master price list

  28 Mar 2012

  MVP Bill Jelen has created this 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 the VLOOKUP function and its benefits, but that you don't really know how or when you might use it. Bill uses the example...
• Today's giveaway: Odes to VLOOKUP (It ain't over until the formulas stop singing)

  27 Mar 2012

  Bill Jelen found it. Erica Rhein started it. She posted a comment on Facebook declaring her complete dependence on VLOOKUP. "I use Pivot Tables and VLOOKUP every day. I would be screwed at my job without it" To Bill's formula-possessed mind this statement equals a love poem. He decided today's VLOOKUP...
• You asked about VLOOKUP

  23 Mar 2012

  (Note: In honor of VLOOKUP Week, March 25-31, we're re-publishing this round-up of VLOOKUP resources on Office.com and other places. Thought some of you might want to brush up on your skills before you write that post.) People are crazy for Excel's VLOOKUP function, and why not? Among other things, VLOOKUP...
• Ride the Shark! It's VLOOKUP Week March 25-31, 2012

  22 Mar 2012

  What strikes terror into the hearts of Excel beginners? VLOOKUP! Excel power users, though, can't live without it. Excel MVP Bill Jelen has declared March 25 - 31, 2012 to be VLOOKUP week . He's invited his fellow Excel experts to publish VLOOKUP posts on their sites during the week. At MrExcel.com ...
• What's your favorite thing about Excel PivotTables?

  20 Mar 2012

  Do you belong to LinkedIn ? Did you know that LinkedIn has lots of Excel user groups where Excel trainers, developers, financial modelers, and even Excel blackbelts compete to out geek each other--or just share information. (The Excel Blackbelt group is for data visualization experts.) We loved this...
• Freeze Panes made simple (Video)

  14 Mar 2012

  Ever wanted to see just a part of your Excel worksheet that's way over on the right? You scroll over and find the information you're looking for, but your row or column headings-sometimes both-have disappeared. Or maybe you want to see data in one row that's at the bottom of your worksheet (which might...
• Samples for learning conditional formatting: icons, formulas, cell values, and more

  12 Mar 2012

  When we released Excel 2010, we published a workbook for you to download , which contains samples of conditional formatting rules. The samples are really helpful for learning how to track trends, check status, spot data, and find top values. But the samples don't just abstractly explain conditional formatting...
• Tip: Add a watermark to an Excel worksheet

  8 Mar 2012

  If you're a manager building a budget in Excel, you'll likely need to solicit input from your staff. Sometimes that collaboration takes several iterations, so it's useful to add a DRAFT watermark to a worksheet. Or sometimes a sensitive document needs to be kept secret, making it important to add a CONFIDENTIAL...
• Circular Reference? Excel's most popular (!#?%) error message explained

  17 Feb 2012

  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 its own tail. Because so many of you search on "circular reference...
• Simplifying data entry with a list box and VBA code

  14 Feb 2012

  To plan which topics to write during the next three months, our Office documentation team needed an easy way to enter values in an Excel worksheet limited only to values in a list. However, we couldn't use Excel's data validation feature because it only lets you select one item per cell. The solution...
• Excel: The Basics (Video)

  1 Feb 2012

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