![](/wp-content/uploads/2022/09/course-header.jpg.webp)
News & Tips
Introduction to Slicers in Excel
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…
Master The XLOOKUP Function In Excel!
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…
Recover Unsaved Files in Excel 2024
We all have been through the unfortunate instances of power disruption and system crashes that do away with all our unsaved work. Even if you take measures to plot against any unexpected power outage or system crash, sometimes Excel would…
Using Do Until Loops in 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!
Lets say you are signing up for a loan – it is crucial to know the real interest rate! Interest computations are not always as simple as an equation of two plus two. In fact, compound interest calculations can get…
The PMT Function – Master Excels Financial Tools!
Only a basic sense of the financial functions of Excel will help you get through most of your daily-life financial calculations. Excel offers multiple financial functions including PMT, IPMT, and PPMT, all of which are designed to cater to the…
Collections In VBA – The Ultimate Guide
In this tutorial, we will provide a comprehensive overview of Excel VBA Collections. You will frequently need to work with Collections in your VBA code. If you would like to learn more about VBA, then please consider joining our top-rated…