<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=931099456970389&amp;ev=PageView&amp;noscript=1">

Category: Excel At Excel

7 Results

Exploring Excel 2013 for BI: Adding Calculated Measures

Posted Dec 07, 2015 by Steve Hughes

It's been a little while, but Steve Hughes is back for his latest blog in the Excel at Excel series. In this blog, he will discuss adding calculated measures when working with SSAS in Excel.

Exploring Excel 2013 for BI: Retaining PivotTable Size After Data Refreshes

Posted Oct 22, 2015 by Steve Hughes

We're back for another informative blog in our series, Excel at Excel with Steve Hughes! In this post, he will cover how to retain the size of your PivotTable after refreshing your data.

Exploring Excel 2013 for BI: Cleaning-Up Slicers

Posted Sep 16, 2015 by Steve Hughes

Thank you again for reading our blog series Excel at Excel with Steve Hughes! In his previous tip, Steve showed you how to add slicers. In this post, he will discuss cleaning up slicers once they have been added to your spreadsheet.

Exploring Excel 2013 for BI: Adding a Slicer

Posted Aug 14, 2015 by Steve Hughes

Welcome back to our blog series Excel at Excel with Steve Hughes! In his previous posts, he's discussed using the Quick Explore, Show Details and Flash Fill features. In this entry, Steve will show you how to add a Slicer feature in Excel.

Exploring Excel 2013 for BI: Flash Fill

Posted Jul 30, 2015 by Steve Hughes

Welcome back to our series, Excel at Excel, by Steve Hughes! In his last post, Steve discussed using the Show Details feature. In this edition, he'll show you how to use the Flash Fill function by walking you through how to manipulate data and fill a column base using the Flash Fill function.

Exploring Excel 2013 for BI: Show Explore

Posted Jul 16, 2015 by Steve Hughes

Welcome back to our informative series on Excel by Steve Hughes! In his first post, he conquered the Quick Explore feature. In this post, Steve will delve into the Show Explore feature. Join Steve as he shows you how you can drill into details using the Show Explore feature once you've connected your SSAS cube to Excel.

Exploring Excel 2013 for BI: Quick Explore

Posted Jul 02, 2015 by Steve Hughes

Excel is a powerful tool that is used by almost everyone is the business world. Because of its numerous capabilities, Excel has many functions that can often be confusing to users. In this new blog series Our resident expert, Steve Hughes, will cover a wide variety of Excel topics ranging from easy to complex. Steve will provide you tips and tricks he has discovered in his journey through Excel.

Quick Explore

So, you have connected Excel to your SSAS cube. You really wish you could cross drill easily in the product. If you have used PerformancePoint Services you know the process. Right click on the bar or cell and then choose the dimension to drill to using the information you clicked on as a starting point. You can now do this in Excel 2013 using Quick Explore. Here’s how to do it:

Subscribe to Blog Updates