Excel pimped with power

Excel Pimped with Power Tools

Excel is one of those tools that you just can’t live without.  It is used to store information, run calculations, carry out analysis, prepare report, visualizations and much more.  What’s just as important is the flexibility it gives to its +750 millions of users.This flexibility allows users create their own calculations and analysis, in a […]

Excel Power Trick – How to Combine a Folder of CSV Files

I previously published an article and video ‘Excel Power Trick – Save time without VBA’ which seems to have been very popular.  In this video we looked at using Power Query to get data from Excel sheets, format that data and then save the query for future use.  It’s amazing how much time you can […]

many to many relationships power pivot

Easy Excel Solutions: Power Pivot Many to Many Relationships

Learn How to Manage Many to Many Relationships in Power Pivot Power Pivot has been around since 2010, and many people still struggle with managing relationships.  Even more so most struggle with more complex relationships such as Many to Many relationships.  In fact, I have seen many people begin to set up data models in […]

Excel Power Trick – Save Time Without VBA

How often have you seen an Excel spreadsheet like the one below?  Very often, right?  I am sure many of you are even saying ‘ What’s the problem with that spreadsheet?’     But I know that some of you can spot the problems straight away.  This matrix style reporting is common in Excel. It contains simple […]