Get file from Folder Get File From Folder is what Microsoft has named the ...

In this blog post, we’ll talk about how to create a relative file path. ...

An Excel Joke to Start Off… Did you hear about the database developer that ...

Let’s say Hi to Szilvia! This week Szilvia shows us some awesome Power Query ...

Isn’t it just frustrating to receive a copy-paste summary table that requires analysis? Yes, ...

Updating spreadsheets can be a pain, especially when you have to change all the ...

Surprisingly, tables are the most misunderstood and, hence, underused feature of Excel. While some ...

Microsoft launched PowerPivot as a separate add-in for Excel 2010. And since then it ...

This week’s special guest is Ken Puls. He’s a Certified Management Accountant who also ...

Excel Tables arranges data in a structured way in rows and columns. When you ...

Wait Wait Don’t Excel Me!  It’s trivia time.  I’m going to give you some ...

People who work with PowerPivot a lot know the importance of dates to analytics. ...

Let’s say we just got handed a report in Excel and have been asked ...

  Done with your analysis and now you want to move your data somewhere ...

First off let’s chat about the previous episode’s challenge.  Jordan asked What function sounds ...

So here is the problem.  You, your Momma and your sister all made separate ...