Tags » Excel

How to Filter Data in Excel

In previous posts, I showed you the basics of Excel, and how to sort data in Excel. In this post, I will show you how to filter data in Excel. 435 more words

Tips And Tricks

Extend the Data Model using calculated columns

Recall from my previous post Add a relationship using Diagram View in Power Pivot

Which I have left with below note. I will be continuing from where I left my previous post. 626 more words

Development Tips

Game Change - Part 3 of the Power BI and Office 365 Powerful Productivity Series

What happened this week may go down as one of, if not the most, important weeks in the history of Microsoft Business Intelligence.  Melodramatic nonsense from a… 1,801 more words


Add a relationship using Diagram View in Power Pivot

Open the Workbook which we prepared in the last exercise in our previous post.

Add Excel Sheet/Table to the PowerPivot Data Model

Development Tips

Quick Hits: Adding a Hyperlink to Excel Spreadsheet

I had a need a while back to add a few hyperlinks to a couple different excel cells that could be clicked on to take the user either to another portion of the excel spreadsheet or to open up a link to another website. 634 more words