News & Tips
AllAdobe IllustratorAdobe InDesignAdobe PhotoshopAutoCADGuides & TipsManagementMicrosoft AccessMicrosoft ExcelMicrosoft Power AutomateMicrosoft Power BIMicrosoft PowerPointMicrosoft ProjectMicrosoft SharePointMicrosoft WordNewsResilienceSQLTime Management
Using The Key Influencer Visual [Power BI Visuals!]
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…
Slicers In Excel – Why Are They So Useful?
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…
All About Power Automate Triggers
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.…
[Detailed Guide] SQL Update Statement
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.…
Mastering The SQL IF Statement
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…
Learn To Use XLOOKUP [2 Full Examples!]
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…
The Ultimate Guide To Using Send Email In Power Automate
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…
3 Quick Ways To Recover Unsaved Files [Excel 2024]
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…
How Do Until Loops Can Help You – Power Automate
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…
Create And Personalise Your Excel Dashboard!
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…
The EFFECT Function – Master Excels Financial Tools!
Interest computations are not always as simple as an equation of two plus two. In fact, compound interest calculations can get super challenging. However you are all covered as long as you can use the EFFECT function in Excel.…
The PMT Function – Master Excels Financial Tools!
Excel’s financial functions are here to help you with your daily finances. The PMT function is all about calculating payments for a loan. People on our Excel courses always want to know how their skills can apply to real…