News & Tips
AllAdobe IllustratorAdobe InDesignAdobe PhotoshopAutoCADGuides & TipsManagementMicrosoft AccessMicrosoft ExcelMicrosoft OutlookMicrosoft Power AutomateMicrosoft Power BIMicrosoft PowerPointMicrosoft ProjectMicrosoft SharePointMicrosoft WordNewsResilienceSQLTime Management
Excel’s SUM Function [inc 2 Examples & Troubleshooting]
The SUM Function quickly adds up numbers in a range of cells. It’s a simple and powerful tool, taught in our intro to Excel course. SUM Function Details Available in: All versions of Microsoft Excel User Level: Beginners…
Excel’s TRIM Function [inc 2 Examples & Troubleshooting]
The TRIM Function in Excel is useful for removing extra spaces from text. It’s especially handy when cleaning data imported from other sources. TRIM Function Details Available in: All versions of Microsoft Excel User Level: Beginners Inputs: “Text”: The…
Excel’s COUNT Function [With 2 Examples & Troubleshooting!]
The COUNT Function in Excel quickly counts the number of cells in a range. It simplifies data analysis by providing a fast way to quantify numeric data in your spreadsheets. COUNT Function Details Available in: All versions of…
Excel’s SEARCH Function [inc 2 Examples & Troubleshooting]
The SEARCH function in Excel is a powerful tool that locates one text string within another. It returns the starting position of the first text. We believe is an underrated function, which is why we include it on our…
All About Timeboxing [Just 7 Simple Steps!]
Timeboxing has been used for hundreds of years. First implemented by Benjamin Franklin, it is still used by incredible people such as Bill Gates, Elon Musk and Jack Dorsey! What Is Timeboxing? Timeboxing assigns specific tasks to predefined time slots…
The Urgency Effect Is Killing Productivity! [How To Overcome It]
If something is urgent, doesn’t mean it’s important. The urgency effect makes people waste countless hours at work and at home! The Mere Urgency Effect Defined Mistaking the urgent for the important! The human brain always prioritises something with…
SQL Joins Explained In <5 Minutes [4 Step-by-Step Examples]
SQL Joins make new tables by retrieving data from other tables. The relationship between tables is expressed (or described) as a type of SQL join. This article gives you a clear, step-by-step introduction to the four different SQL join…
Introduction To Power BI Slicers [Beginners Guide: Step-By-Step]
Slicers are a great way to visually filter your data. They offer a much more appealing alternative to filters, but achieve the same goal: Digging deep into your data and making subsets based on your needs. Let’s get straight…
How To Say No Without Saying No [3 Easy Ways with Examples]
As a manager, you have to learn to say “No”. But being harsh isn’t the only way to go about it. ‘No’ is a direct and blunt word, which can kill motivation if used at the wrong time. Learning…
You Should Learn Power BI [How And Why]
Power BI stands for Power Business Intelligence. It is the leading business intelligence and data visualization tool. Microsoft Power BI’s transforms data from multiple sources into actionable insights. It is used by business analysts, business intelligence analysts and supply chain…
Managing Conflict In Your Team – 6 Quick Tips
When you run a team of talented and passionate people: You will have plenty of disagreements. Capable, assertive people will express their opinions clearly. Sometimes others will disagree with them as a consequence. This isn’t a negative, but a positive.…
Running Great Performance Reviews [7 Simple Tips]
Performance reviews can be daunting for new line managers, but they are a crucial part of management. Done well, they provide clear goals and a roadmap for success, benefiting both you and your team members. However, poorly conducted reviews can…