Excel Bloghttp://blogs.office.com/b/microsoft-excel/default.aspxen-USTelligent Community 1.5.134.15456 (Build: 5.5.134.15456)What's the dif? Gridlines vs borders in spreadsheetshttp://blogs.office.com/b/microsoft-excel/archive/2012/05/23/the-difference-between-gridlines-and-borders-in-excel.aspxWed, 23 May 2012 16:58:00 GMT53587256-c606-4c9b-bad4-97c86b12ce62:31316Dail Bridges0http://blogs.office.com/b/microsoft-excel/rsscomments.aspx?WeblogPostID=31316http://blogs.office.com/b/microsoft-excel/commentapi.aspx?WeblogPostID=31316http://blogs.office.com/b/microsoft-excel/archive/2012/05/23/the-difference-between-gridlines-and-borders-in-excel.aspx#commentsExcel 2010gridlinesbordersA 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....<br/> <br/> continue reading...Split and merge data in URLs http://blogs.office.com/b/microsoft-excel/archive/2012/05/16/splitting-and-recombining-data-in-urls-.aspxWed, 16 May 2012 21:43:00 GMT53587256-c606-4c9b-bad4-97c86b12ce62:31270Stacey Armstrong3http://blogs.office.com/b/microsoft-excel/rsscomments.aspx?WeblogPostID=31270http://blogs.office.com/b/microsoft-excel/commentapi.aspx?WeblogPostID=31270http://blogs.office.com/b/microsoft-excel/archive/2012/05/16/splitting-and-recombining-data-in-urls-.aspx#commentsExcel 2010split and merge dataIssue: I have a list of URLs with their corresponding page views. The URLs include a section of the site and the date when the page was published. I'd like to calculate the total number of page views...<br/> <br/> continue reading...Quick Trick: Resizing column widths in pivot tableshttp://blogs.office.com/b/microsoft-excel/archive/2012/05/14/changing-column-widths-in-pivot-tables.aspxMon, 14 May 2012 16:39:00 GMT53587256-c606-4c9b-bad4-97c86b12ce62:31214Stacey Armstrong3http://blogs.office.com/b/microsoft-excel/rsscomments.aspx?WeblogPostID=31214http://blogs.office.com/b/microsoft-excel/commentapi.aspx?WeblogPostID=31214http://blogs.office.com/b/microsoft-excel/archive/2012/05/14/changing-column-widths-in-pivot-tables.aspx#commentsExcel 2010Pivot TablesWho 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...<br/> <br/> continue reading...Count values that meet a condition with the COUNTIF functionhttp://blogs.office.com/b/microsoft-excel/archive/2012/05/04/count-values-that-meet-a-condition-with-the-countif-function.aspxFri, 04 May 2012 16:39:00 GMT53587256-c606-4c9b-bad4-97c86b12ce62:24548Gary Willoughby2http://blogs.office.com/b/microsoft-excel/rsscomments.aspx?WeblogPostID=24548http://blogs.office.com/b/microsoft-excel/commentapi.aspx?WeblogPostID=24548http://blogs.office.com/b/microsoft-excel/archive/2012/05/04/count-values-that-meet-a-condition-with-the-countif-function.aspx#commentsfunctionsembedUpdate: See near the bottom of this post for the latest Office how-tos on embedding Excel and PowerPoint files on web pages. You probably know how to use the COUNT function to count cells that...<br/> <br/> continue reading...Using multiple criteria in Excel Lookup formulas http://blogs.office.com/b/microsoft-excel/archive/2012/04/26/using-multiple-criteria-in-excel-lookup-formulas.aspxFri, 27 Apr 2012 01:01:00 GMT53587256-c606-4c9b-bad4-97c86b12ce62:31140Emily Warn3http://blogs.office.com/b/microsoft-excel/rsscomments.aspx?WeblogPostID=31140http://blogs.office.com/b/microsoft-excel/commentapi.aspx?WeblogPostID=31140http://blogs.office.com/b/microsoft-excel/archive/2012/04/26/using-multiple-criteria-in-excel-lookup-formulas.aspx#commentsExcel 2010lookupIf you want to look up a value in a table using one criteria, it's simple. You can use a plain VLOOKUP formula. But if you want to use more than one criteria, what can you do? There are lots of ways...<br/> <br/> continue reading...Merging and splitting cells or datahttp://blogs.office.com/b/microsoft-excel/archive/2012/04/12/merging-and-splitting-cells-or-data.aspxThu, 12 Apr 2012 17:30:00 GMT53587256-c606-4c9b-bad4-97c86b12ce62:25467Frederique10http://blogs.office.com/b/microsoft-excel/rsscomments.aspx?WeblogPostID=25467http://blogs.office.com/b/microsoft-excel/commentapi.aspx?WeblogPostID=25467http://blogs.office.com/b/microsoft-excel/archive/2012/04/12/merging-and-splitting-cells-or-data.aspx#commentsExcelExcel 2010The title of this post sounds simple. Should be easy to do, right? But customers tell us that it's very confusing and not at all clear where to find the features to get the results they want. It all...<br/> <br/> continue reading...And the winner of the VLOOKUP Great White Shark Award is...http://blogs.office.com/b/microsoft-excel/archive/2012/04/11/great-white-shark-award.aspxWed, 11 Apr 2012 21:13:00 GMT53587256-c606-4c9b-bad4-97c86b12ce62:31043Guest1http://blogs.office.com/b/microsoft-excel/rsscomments.aspx?WeblogPostID=31043http://blogs.office.com/b/microsoft-excel/commentapi.aspx?WeblogPostID=31043http://blogs.office.com/b/microsoft-excel/archive/2012/04/11/great-white-shark-award.aspx#commentsExcel 2010VLOOKUPJP 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...<br/> <br/> continue reading...Excel: Not just for geekshttp://blogs.office.com/b/microsoft-excel/archive/2012/04/06/excel-not-just-for-geeks.aspxFri, 06 Apr 2012 16:46:00 GMT53587256-c606-4c9b-bad4-97c86b12ce62:31006Emily Warn3http://blogs.office.com/b/microsoft-excel/rsscomments.aspx?WeblogPostID=31006http://blogs.office.com/b/microsoft-excel/commentapi.aspx?WeblogPostID=31006http://blogs.office.com/b/microsoft-excel/archive/2012/04/06/excel-not-just-for-geeks.aspx#commentsExcel 2010Excel 2010 StudentsUgh. 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...<br/> <br/> continue reading...VLOOKUP Week wraps up: Vote for your favorite posthttp://blogs.office.com/b/microsoft-excel/archive/2012/04/04/vlookup-week-wrap-up-choose-the-winner-of-the-best-post.aspxWed, 04 Apr 2012 19:56:00 GMT53587256-c606-4c9b-bad4-97c86b12ce62:31016Emily Warn1http://blogs.office.com/b/microsoft-excel/rsscomments.aspx?WeblogPostID=31016http://blogs.office.com/b/microsoft-excel/commentapi.aspx?WeblogPostID=31016http://blogs.office.com/b/microsoft-excel/archive/2012/04/04/vlookup-week-wrap-up-choose-the-winner-of-the-best-post.aspx#commentsExcel 2010VLOOKUPVLOOKUP 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...<br/> <br/> continue reading...VLOOKUP Tutorial: Updating prices in a master price listhttp://blogs.office.com/b/microsoft-excel/archive/2012/03/28/-vlookup-tutorial-from-bill-jelen.aspxWed, 28 Mar 2012 20:39:00 GMT53587256-c606-4c9b-bad4-97c86b12ce62:30965Emily Warn3http://blogs.office.com/b/microsoft-excel/rsscomments.aspx?WeblogPostID=30965http://blogs.office.com/b/microsoft-excel/commentapi.aspx?WeblogPostID=30965http://blogs.office.com/b/microsoft-excel/archive/2012/03/28/-vlookup-tutorial-from-bill-jelen.aspx#commentsExcel 2010VLOOKUPIn 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...<br/> <br/> continue reading...