Results for:
Excel 2010

• Webinar: 5 things you need to know about Freezing Panes in Excel

  11 Mar 2013

  Need to navigate that huge spreadsheet quickly? Freeze panes can help by allowing you to view your column and row headings continuously while you scroll your document. In this webinar, we'll demonstrate how to freeze panes in an Excel workbook, plus we'll give you 5 tips of this feature, just in case...
• Your top 10 favorite Excel posts of 2012

  7 Jan 2013

  There's an Excel community out there that continually wants to learn new tricks, and there are lots of people just discovering Excel's capabilities who want to join in. The most popular posts of 2012 that were about the current version of Excel reflect that mixed audience. But the popularity ranking...
• Chart Elements: Customizing your Chart

  31 Oct 2012

  This post is brought to you by Chris Doan, a Program Manager on the Graphics team. What’s the first thing you do with a chart after you’ve inserted it? For many users, it’s modifying the chart to make it look exactly the way you want it to look. Sometimes that means fiddling around...
• Calculated Member and Measures in Excel 2013

  15 Oct 2012

  Today blog post is brought to you by Alex McMains a Software Development Engineer in Test from the Office Business Intelligence team. Besides many new, exciting features, Excel 2013 also offers enhancements to older features even those that may be a little more obscure to the everyday Excel user. Today...
• Introducing spreadsheet controls in the new Office

  13 Sep 2012

  This blog post is brought to you by Steve Kraynak, Program Manager on the Excel Services team. We have 5 brand new Excel, Web Excel and SharePoint features to introduce to you in the new Office, all designed to help you manage the use of spreadsheets and Access databases. I'll tell you about each of...
• Plug into your data: Connecting Excel to an Access database

  14 Aug 2012

  Northwind Trading Company, a small wholesale food business, is doing quite well since they moved online. Retail merchants across the country buy everything from salmon to granola and have it shipped quickly to their stores. Their customer information is stored in an Access database, and now, the marketing...
• The good kind of circular reference

  17 Jul 2012

  ( Excel MVP Jan Karel Pieterse, our guest blogger, runs JKP Application Development Services , specializing in developing business solutions using Microsoft Excel/VBA and Access/VBA. ) There have been ample articles about troubleshooting unintentional circular references in Excel workbooks. This post...
• Too much data to view? Use Auto Outline to group it

  9 Jul 2012

  Puget Sound Pets can't keep enough dog chews on the shelves for all the Corgies they sell (or rodents for the pet Pythons). And they can't keep up with the sales data they generate from their booming business. To better understand their revenue stream, they need to view it on a month-to-month and store...
• Score! Merge data from multiple worksheets

  5 Jul 2012

  The Decatur Golden Gators soccer team is hitting the pitch (that's a field for you uninitiated folks) to perfect their skills and beat their better-funded rivals. The coach is excited and fiscally worried. Lining up mini-vans, buying snacks, and replacing torn jerseys is not cheap! Rolling these expenses...
• Combining Chart Types, Adding a Second Axis

  21 Jun 2012

  (This post was originally written and published by Katherine Fifer, an intern on the Excel 2007 team. We've updated it for Excel 2010 and added a sample worksheet to help you learn.) Often it is useful to create charts that compare different types of data. For example, you might want to compare a stock...
• Learn advanced filtering in Excel by tracking flying fish

  20 Jun 2012

  The fish-throwers at Pike Place Market are one of Seattle’s most popular tourist destinations. These guys can toss virtually any marine animal—salmon, crab, cod—and certainly they can catch! Flying fish might wow visitors, but if you own the fish shop, one of your main concerns is likely...
• Impress your teacher: Use conditional formatting to highlight data (video)

  13 Jun 2012

  He's no slouch! Melvin Corpuscle shows his accounting teacher a thing or two by walking him through how he used conditional formatting to make low and high sales numbers stand out. Learn more about conditional formatting: Conditional Formatting Rules Simplified Quick start: Apply conditional formatting...
• 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 while you're working in a spreadsheet; while borders help you highlight important information for people to see. Gridlines appear automatically showing you how the data is organized into rows and columns; while...
• 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...