• Need to combine two chart types? Create a combo chart and add a second axis

    Have you ever had two different types of data that you wanted to show in one chart? Learn how Excel 2013 makes it easier to create combo charts with a second axis.

    ...
  • Choose your own PivotTable

    This post is brought to you by Allie Rutherford, a Program Manager on the Analytics and Presentation team.

    Excel will try to read your mind and tell you what PivotTable you’re looking for (more or less). Create PivotTables with nearly no effort and virtually no expertise, we’ll recommend some to you!

    ...
  • Your top 10 favorite Excel posts of 2012

    Excel Best of 2012

    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 of posts about the new Excel reflects the enthusiasms of Excel professionals and geeks. They want to know how the new version will make their lives and jobs easier, especially those features that you let you work from anywhere.

    Check out the year in review with the top posts for the new and current Excel.

    ...
  • You always want to know another shortcut (video)

    Shortcuts are like jokes in a comedy club: they’re great when you hear them, but can’t remember them the next day. So, let’s try to refresh your memory—or give you some new memories—of 3 nifty shortcuts to move around and find your stuff in the Excel.

    I did this, and a few more videos, for the Small Business Group. You can find more videos, plus many more helpful tidbits at the Microsoft Business Hub.

    ...
  • Drilling around in your Excel PivotTables and PivotCharts

     In the new Excel, we published a feature that allows Excel to continue its emergence as your go-to BI tool, whether it's for analytics or for  exploration. That feature is called "Quick Explore," and with it you can drill up, drill down, and drill across your PivotTables and PivotCharts in ways never before possible in either Excel desktop or Excel in the browser.

    ...
  • Introduction to PowerPivot in Excel 2013
    This blog post was brought to you by Diego Oppenheimer a Program Manager on the Excel team. Some weeks ago I introduced an important, new part of the Excel 2013 Data Model and how you could create relationships between different data sources right in your Excel workbook ( http://blogs.office.com/b/microsoft-excel/archive/2012/08/23/introduction-to-the-data-model-and-relationships.aspx ). In today’s post I am going to show you how you can expand on this Data Model and add all sorts of analysis...
  • Interacting with Your Website’s Data Using Web Excel Mashups

    Interested in taking your website’s data to the next level? Excel Mashups make it easy to both extend Excel capabilities on the web and bring your data into Excel.

    ...
  • A Primer on Apps for Office in Excel

    In Office 2013, we introduced a new cloud-based application model called Apps for Office. This post describes how you can find and insert them into your workbooks using Excel 2013 and share those workbooks through the Excel Web App.

    ...
  • Field List and Field Well in the Excel Web App

    Excel for the browser has adopted a number of features that, previous to the 2013 release, only existed in the client application. In this blog I want to introduce you to one of those features: the field list and field well. This is one of the features that allows you to use the Excel web app as a first class analytic tool.

    ...
  • Excel Surveys

    Use Excel surveys on SkyDrive to easily create and publish surveys about any topic that you want. Then collect and analyze the results directly in the workbook.

    ...

   1 2 3 4 5