Power BI Content Packs

Power BI Content Packs – Analyse Mailchimp and Google Analytics

Big data and the data trend is everywhere. But I know many small businesses believe all of this is out of their reach. the belief is that it costs too much and they don’t have the skill set. Let me introduce you to Microsoft Power BI services and their Content Packs – best of all, […]

Wonderfully Weird function in Excel

Wonderfully Weird function in Excel

Excel is full of wonderful and weird features and functions.  With so many functions available, a lot of the time there is more than one way you can solve a problem in Excel.  Sometimes I look at functions and I wonder to myself….what problem could this solve? (that’s a bit sad to be admitting really) […]

learn Excel Pivot tables

Learn Excel Pivot Tables in less than 20 Minutes

Excel Pivot tables are a really powerful tool.  They allow you create interactive reports on large data sets.  You can summaries, organised and explore the information contained within the data, with just a few clicks of the mouse. To be honest a Pivot Table can be created very quickly.  Excel even offers a set of […]

Publish Reports from Power BI Desktop to Power BI Services

Publish Reports from Power BI Desktop to Power BI Services

When you create a report in Power BI Desktop there are a number of reasons you might want to publish it to Power BI services. Maybe you  want to share your report with others with in your organisation You might want to embed the report on a website You need to add reports to an App […]

hyperlink feature and function in excel

Hyperlink Feature and Function in Excel

Both the Hyperlink feature and function in Excel will allow you to link directly to Webpages Places within the Excel Workbook Other documents on your computer Email addresses In the video below we will look at both the Hyperlink feature and function in Excel.  You will also learn how to use the Hyperlink function to create […]

manage measures in PowerBI

How to Manage Measures in PowerBI

So you have connected all of your data into PowerBI and you have transformed and shaped it.  Now all you need to do is create some calculations, know as measures, so you can begin to make some visualizations. Off you go and do the normal SUM, Count and Average DAX functions across a number of the tables […]

Introduction to Tables and Filters in Excel

Table and Filters in Excel are incredibly useful tools 5 Reasons to use Tables and filters in Excel Quick totals – it is easy to turn both on and off the totals feature of tables. But if you need to get totals quickly, convert you data into a table and the totals will be calculated […]

Excel’s odd but useful – Indirect Function

The Indirect function in Excel is an odd but useful function.  On the Microsoft website the description given is “Returns the reference specified by a text string. References are immediately evaluated to display their contents. Use INDIRECT when you want to change the reference to a cell within a formula without changing the formula itself.” […]

excel tricks

6 Excel Tricks to Make Life Easier

Mastering Excel is not something that you can achieve overnight. Taking on bite sized chunks of learning, will help you get there.  And that’s what you are going to get today. In this article I am going to focus on 6 Excel tricks, each just a bite sized chunk, that will make your life easier. […]

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 […]