Results for:
excel 2010

• 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...
• Five most popular posts on the Excel blog in 2011

  26 Jan 2012

  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...
• Beyond spreadsheets: Spiffy Excel calendars for 2012

  6 Jan 2012

  Need a plain-vanilla calendar for your business which shows the year in a glance? Or the kind that your local hardware passes out for free (marketing) at the end of the year? Or if you're a student, how about one that lets you juggle assignments as the professors keep juggling dates? Here are this year...
• Create smashing mashups with Excel

  15 Dec 2011

  Today's post is brought to you by Larry Waldman, a program manager on the Excel team. You may remember Larry from his previous posts on embedding Excel files on web sites and designing Excel solutions for the Web . Hello, web developers! Today, I want to point you to ExcelMashup.com , a new site from...
• When a macro won't cut it, try a VBA script

  22 Nov 2011

  As an Excel MVP, I know that Excel is an extraordinarily powerful tool that can be used to simplify work in countless situations. For example, fellow MVP Beth Melton recently designed a Gradebook template in Excel that makes teachers’ lives a whole lot easier. Based on Excel Tables technology which...
• Two tips for faster worksheet navigation

  18 Oct 2011

  If your workbook contains a lot of worksheets, it can be a hassle to navigate to just the right sheet. For one thing, you often can't see all the sheet names at the bottom of the workbook: Sure, you can move around by using the four navigation buttons to the left of the worksheet tabs, or by pressing...
• Your call: What would you like us to post about on the Excel blog?

  26 Jul 2011

  We know you're pressed for time, and you want what you read to be worth the effort. Our question to you is this: What kind of blog post about Excel works best for you? Do great tips help you work smarter? Maybe code examples unlock your creative side? Or do guest posts from Excel MVPs hit home? Take...
• Can’t remember all those Excel keyboard shortcuts? Now you don’t have to!

  19 Jul 2011

  Today's blog post on keyboard shortcut reference cards is brought to you by Office.com writer, Turi Henderson. Turi has been on the Office.com team for a few years, writing mainly about Accessibility features and Language Tools, and periodically plying her coworkers with fine baked goods. Keyboard shortcuts...
• Apollo 11 & Excel 2010 – Watch History Reimagined for a chance to win

  13 Jul 2011

  When you think about it, the ease with which we're able to process and visualize complex mathematics in the digital age is profound. Especially when you consider that it wasn't that long ago that much of this work was done manually. That got us thinking - what would it have been like if Excel had been...
• Excel Services content refresh is live

  30 Jun 2011

  If you're a developer, you may have been wondering..."When are they EVER going to revise the Excel Services JavaScript Object Model (JSOM) documentation for SharePoint Server 2010?" Well, I'm glad you asked! The SharePoint Server 2010 Software Development Kit (SDK) online documentation has been refreshed...
• Free training: Take the next steps in growing your Excel skills

  28 Jun 2011

  In early May, we told you about the new video series Excel Skills Builder in our post " Take the first step in growing your Excel skills ." In that post, we announced the launch of lesson 1. Well, we've finally finished the rest of the lessons, and wanted to share this great resource with you! As a reminder...
• College students learn about SkyDrive and embedding workbooks

  21 Jun 2011

  Last month, a couple of other writers and I visited the main University of Washington (UW) campus in Seattle, Washington, where we presented to a group of business students who were interested in learning more about Excel. Our main takeaways: First, college students are young! We too, were once young...
• Learn how to create your own Excel macros in this free training course

  1 Jun 2011

  Have you been wanting to record your own Excel macros, but you're not yet ready to dip your toes in the water? Maybe you want to modify macros other people have created, or you're not sure what a macro can do for you? If so, you may want to take this online training course on creating Excel macros. You...
• Avoid losing the state of the global IRibbonUI ribbon object

  19 May 2011

  In today's post, Excel MVP Ron de Bruin provides a solution for a common problem that occurs when you use RibbonX and VBA to customize the ribbon. You can find more tips and links to Excel add-ins at Ron's website: http://www.rondebruin.nl/ . There is a common problem when you are working with the ribbon...
• Visualize this: Win an Xbox 360 with our PowerPivot quiz

  10 May 2011

  What kind of PowerPivot nerd are you? A Numbers Ninja? A Data Mining Wizard? Find out by taking our Nerdtastic PowerPivot Quiz on Facebook. Besides learning if you're the nerdiest PowerPivot user of them all, you'll automatically be entered to win an Xbox 360 + Kinect just for participating. So head...
• Rockin' out with PivotTables

  6 May 2011

  We recently discovered this music video by youarentbenjamin on YouTube titled "PivotTables Make Everything Just Right." The video gives some serious love to PivotTables . Props for the creativity, and here's hoping they got an A+ for their group project! --Amy Miller
• Learn the ins and outs of dates and formulas in this free training course

  3 May 2011

  Have you ever wanted to subtract one date from another? Or find out how many workdays until vacation? Or maybe you need to figure out a project end date. You can do all of this and more by using date functions in Excel formulas. As long as you type a date in a format that Excel recognizes: 8/22/2011...
• Merging and splitting cells or data

  25 Apr 2011

  The 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 depends on what you want to merge or split. For example, you may want to create a large header cell by...
• Help the Excel team by answering these 2 questions

  22 Apr 2011

  Page Layout View is a view that allows you to see how printed Excel pages will look. You can get to it by going to the View tab and clicking Page Layout . We're trying to learn more about how (and if) Excel users use Page Layout View. If you'd like to help us, please answer this quick 2-question survey...
• You asked about VLOOKUP

  5 Apr 2011

  People are crazy for Excel's VLOOKUP function, and why not? Among other things, VLOOKUP is known for its rugged good looks and unparalleled martial arts ability. In all seriousness, VLOOKUP is one of the most widely used, versatile functions in Excel. You typically use it to quickly look up and extract...