News & Tips
AllAdobe IllustratorAdobe InDesignAdobe PhotoshopAutoCADGuides & TipsManagementMicrosoft AccessMicrosoft ExcelMicrosoft Power AutomateMicrosoft Power BIMicrosoft PowerPointMicrosoft ProjectMicrosoft SharePointMicrosoft WordNewsResilienceSQLTime Management
The Seinfeld Strategy: Become Consistent At Anything
Consistency is the key to success. Being consistent is incredibly difficult, as you will know if you’ve tried to form a new habit! What Is The Seinfeld Strategy? The Seinfeld Strategy, also called “don’t break the chain” is a method…
How The Eisenhower Matrix Can Help You
The Eisenhower Matrix is a great tool to keep you focused on your most impactful tasks. What Is The Eisenhower Matrix? The Eisenhower Matrix is a tool to prioritize tasks based on urgency and importance. Doing this helps you focus…
The Q&A Visual In Power BI
The Q&A visual in Power BI uses Power BI’s natural language processing engine. It can interpret your question and get an answer from your data. Half of Power BI is learning the best way to present your data using…
Global Excel Summit 2025 Announced!
The Global Excel Summit for 2025 has finally been announced! It will take place from the 3rd to the 7th of February 2025, in London. You can register your interest early on through the Excel Summit website. We strongly recommend…
[Introduction] Get Started With Charts In Excel
Charts are how you visualise data in Excel. These visualisations are fantastic for presenting data for others, as well as summarising it for yourself. Delegates on our Excel courses always want to learn how to make great charts! What…
Excel For Web: A Comprehensive Guide
Excel for Web is a cloud-based tool that aligns with the needs of modern businesses. Spreadsheet management has is a vital part of operational tasks. With it, data analysis, decision-making, and reporting is all possible on the go. Why…
How Are People Using AI In The UK? 2024 Stats
AI is nothing new. But what is new is the rate at which adoption is increasing in 2023. The past few months have seen millions of people trying their hand at using platforms like ChatGPT. They use it to increase…
Keep Yourself Safe With Row-Level Security in Power BI
In this article, we will look at static row-level security in Power BI. We look at what it is, how to implement it and areas to take care when using it. We find delegates on our Power BI Courses always…
Moving Average Forecast – EXCEL GUIDE
This post explores how to set up a moving average forecast in Excel. To calculate a moving average, you take the mean of several values and then track how that average changes over time. This gives you a great…
Sort And Clean Your Data With SORT and SORTBY [Complete Guide]
Sorting and cleaning your Excel data is difficult. Doing it using formulas, you’d have to put together an insane combination of functions. However, the dynamic array functions SORT and SORTBY, make it super-easy for users to sort data. This…
Excel: Audit Formulas To Ensure They’re Correct
Formula Auditing lets you evaluate and fix your errors, smoothly and seamlessly. It shows you your formula’s dependencies and gives insights into what is causing errors. The Formula Auditing Group This is the Formula Auditing Group, it belongs in…
Create A Flowchart In Excel Easily!
Flowcharts are very effective forms of visual communication. We are going to cover two different ways of creating flowcharts in Excel. What Is A Flowchart? A flowchart is a diagram that depicts the steps in a process, or workflow in…