Microsoft Excel
Our Excel articles below show clearly and simply how to use specific aspects of Microsoft Excel. We also cover these in our Excel training courses.
AllAdobe InDesignAdobe PhotoshopManagementMicrosoft ExcelMicrosoft Power AutomateMicrosoft Power BIMicrosoft PowerPointMicrosoft ProjectMicrosoft SharePointMicrosoft WordPublic SpeakingSQLTime Management
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…
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…
Linking Data in MS Excel – 2 Methods
What if all your data could be linked across from one sheet to another? You would never need multiple copies of the same data. You’d also minimize the risk of incorrect data due to forgetting to update the information…
Master Excel’s FIND Function In Under 3 Minutes – [2 Clear Examples]
The FIND Function in Excel is useful for locating specific text within a cell. It tells you where the text starts. FIND can tell you where the word “apple” begins in the sentence “I like apple pie.” FIND Function Details…
AVERAGE Function Excel – Quick Guide!
The AVERAGE function in Excel calculates the mean value of a group of numbers, balancing out the extremes. It’s like finding the middle ground in a set of data points. Excel Function Details: Available in: All versions of Microsoft…
How To Use A Checkbox In Excel
Checkboxes are one of the clearest visual indicators of all time. You can insert multiple checkboxes, to make your spreadsheets more interactive. An Excel form control tick box is easier, in some instances, to use than ActiveX controls. The…
Inserting A Check Mark (Tick ✓) Symbol in Excel
Have you ever prepared a checklist in Excel? Checklists give you the feeling of having accomplished a task. Their utility comes from the check marks that you can put against different items within them. Note: A check mark is…
The Ultimate Guide To Excel Drop Down Lists
What if the key to collaborating in Excel was a different way of making tables? We have all used tables in Excel, but what if you are looking to make this table into a list for others to use?…