Recent Posts

Excel

Profit and loss data modeling and analysis with Microsoft Excel

Accounting and Finance Professionals have a new learning resource. The Profit and Loss Data Modeling and Analysis with Microsoft PowerPivot in Excel article, Excel workbook samples, and sample Access database provide scenario-based data modeling and analysis help for self-service BI with PowerPivot and Power View.

Excel

Calculated Member and Measures in Excel 2013

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 we will shed some light on one of these features. The feature that I want to talk about here is the OLAP based Calculated Members and Measures. Definition and Caveat OLAP is an acronym for online analytical processing. Although there are technically…

Excel

Intro to Power View for Excel 2013

Have you ever looked at a dashboard someone made and went, “man, I like that, but there’s too many steps for me to remember”? Or maybe wanted to have a way to play around with your data in a safe space so you don’t mess it up? Power View is a new add-in for Excel 2013 that consumes the Data Model. For those who are avid readers of our blog,…

Excel

Inserting Charts in Excel 2013

As Scott mentioned in his Charting Overview post, users have always struggled with picking the right chart type to represent their data. Unless you have a good understanding of the different chart types available and the types of data they work for, many users have trouble choosing the right chart type to properly represent their data, and often fallback to choosing something familiar. Even worse, sometimes users ended up choosing…

Excel

Introducing spreadsheet controls in the new Office

We have 5 brand new Excel, Web Excel and SharePoint features to introduce to you in Office 2013, all designed to help you manage the use of spreadsheets and Access databases. I’ll tell you about each of them in more detail, but the names really speak for themselves: · Audit and Control Management Server · Discovery and Risk Assessment · Spreadsheet Inquire · Spreadsheet Compare · Database Compare

Excel

Charting Overview for the new Microsoft Office

With the Office 2013 release, the Office DataViz team is proud to deliver a rich set of charting capabilities across Excel, Word, PowerPoint, and Project. In fact, because there are so many features, this article will only be an overview. Subsequent articles will go into the specific use cases and steps for each of them. I’ve been working on Excel charting since the Office 2007 release, when we replaced the…

Excel

Introduction to the Data Model and Relationships in Excel 2013

This post is brought to you by Diego Oppenheimer a Program Manager on the Excel team. I am very happy to be writing this blog post today. Not just because I will be showing you another way Excel can make your data analysis easier but also because I will be introducing the new Data Model and Relationships features that will hopefully change the way you use Excel for data analysis…

Excel

Flash Fill

This post is brought to you by Chad Rothschiller a Program Manager on the Excel team. Today I’m proud to be writing about a new feature in Excel 2013 called Flash Fill that makes all of those tasks very simple for even the most novice user. Several years ago, I wrote a blog post demonstrating how to do string manipulations like the above examples. The problem is that the solutions…

Excel

Office Business Intelligence – The way people experience data

This post is brought to you by Steve Tullis Group Program Manager of the Office Business Intelligence team. This is the third introductory post from the Excel family – Office BI. If you have not read Jane’s post about the Excel client, or Dan’s post about the browser-based versions of Excel, I encourage you to do so, as they are great overviews and provide foundational information about how we decided…

Excel

Introducing Excel 2013

  This blog post is brought to you by Jane Liles Group Program Manager for the Excel team. With this post she kicks off a brand new blog series introducing all the features we have added across Excel for the release of Office 2013. Greetings from the Excel team hallway… By now you’ve hopefully tuned into our Office Next blog, which provides all-up view of our latest release for Office, and…