What makes employees happy? Lots of people are reassessing their work now that coronavirus restrictions have been lifted. To find out more, we conducted new, original research to look at what the key drivers of employee happiness & job satisfaction…
In this article, we look at creating a Key Influencer visual in Microsoft Power BI. We will see what a key influencer visual is, when it is valuable and look at its limitations. Our online Microsoft Power BI training courses…
Merriam-Webster defines delegation as ‘the act of empowering to act for another’. In business parlance, we call it assigning the authority to carry out tasks and make decisions. Some people find it hard to delegate as they don’t think anyone…
Slicers in Excel are often used together with Excel tables and Pivot tables. What are they used for? Quick filtering of data from huge, densely packed data sets. What distinguishes Slicers from ordinary data filters is their visual appeal and…
Power Automate flows are used to automate or perform a set of actions with minimum human intervention. There will always be a specific situation or condition that needs to be met before we want the flow to start its execution.…
This article explains how to use the SQL UPDATE statement for updating table rows in SQL SERVER. It looks at what the SQL UPDATE statement is, how you can use it, and some rules and best practices for using it.…
In this article, you will see how to use the SQL IF statement for the conditional execution of your SQL script. You will see what SQL IF statements are, how to use them in simple and complex situations, and what…
It’s time we introduce you to the new member of the modern function family of Excel – the XLOOKUP function. XLOOKUP is the successor to the conventional VLOOKUP, INDEX & MATCH, LOOKUP, and the HLOOKUP function. You must have heard…
Power Automate allows you to automatically send emails when certain things take place. Although not all emails can be automated, day-to-day scenarios such as reminders, notification when an event occurs, regular updates on products etc., can be automated which reduces…
We’ve all been there – working on an Excel file, only to have it disappear after a crash! Panic sets in, and you start to worry everything is gone. But you still have options. These methods are very important…
There is often a need to execute certain actions or instructions repeatedly. This can be achieved by using loops in Power Automate. A loop in Power Automate is a control that can automate actions. In this article, we look in…
In this tutorial, we will take you through the steps needed to create an Excel Dashboard. We will also review some best practices when it comes to dashboard creation and visualization. An Excel Dashboard is a powerful visualization tool that…
