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

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

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…