Nested IFs and Russian Dolls
Excel Online Training When they hear the term “nested IFs”, a lot of people will visualize a structure whereby you have one parent IF statement with several IF statements nested inside it; and this is not actually the case. A better way of visualising nested IFs is to think of a Russian doll arrangement, whereby…
Combining LEFT, SEARCH and VLOOKUP
Excel Online Training To complete this tutorial, you will need to download and UnZip the following file from GoogleDrive; it contains two versions of the workbook used in the tutorial: the start version and the completed version. Download the tutorial workbook(s) In the download tutorial folder, open “04 Manipulating Text”; and then open the Excel…
Connecting to Web Page Data in Power BI
As well as retrieving data from a web URL, Power BI also allows you to retrieve data from within the web page itself. In this tutorial article, we will see how easy it is to connect to online data and incorporate it into your own data models. The files used in this tutorial can be…
Getting Started with Power BI – Pt 4
Part 4 (of 4): Creating a Report in Power BI Desktop 2 Click here to download the tutorial work files Power BI online training In the previous tutorial in this series, we discussed the use of the synoptic panel custom visual to build a car damage report; and we examined the completed report. In this…
Getting Started with Power BI – Pt 3
Part 3 (of 4): Creating a Report in Power BI Desktop 1 Click here to download the tutorial work files Power BI online training So far, we have connected to a data source and we now have these two tables loaded into the data model available for building reports. On the left, we have three…
Getting Started with Power BI – Pt 2
Part 2 (of 4): Working in the Query Editor Click here to download the tutorial work files Power BI online training Let us now look in a bit more detail at the three parts of Power BI that we saw earlier: Power BI Desktop, the Power BI service and Power BI mobile apps. We will…
Getting Started with Power BI – Pt 1
Part 1 (of 4): the Power BI Product Click here to download the tutorial work files Power BI online training Microsoft Power BI consists of three parts Power BI Desktop, the Power BI service and Power BI mobile apps. Power BI Desktop is the workhorse of the three: this is where you connect with your…