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.
Master The FIND Function In 5 Minutes
The FIND Function in Excel is useful for locating specific text within a cell. It tells you where the text starts. For example, FIND can tell you where the word “apple” begins in the sentence “I like apple pie.” For…
How To Use The COUNT Function
The COUNT Function in Excel is useful for quickly counting the number of cells in a range that contain numbers. It simplifies data analysis by providing a fast way to quantify numeric data in your spreadsheets. For more on Excel…
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. For more on Excel check out our Microsoft Excel courses!…
Clean Data With The TRIM Function In Excel
The TRIM Function in Excel is useful for removing extra spaces from text. It’s especially handy when cleaning data imported from other sources, ensuring consistency and accuracy in your Excel work. For more on Excel check out our Microsoft Excel…
Excel Tips: The SUM Function
The SUM Function in Excel is useful for: quickly adding up numbers in a range of cells. It’s a basic yet powerful tool that can handle everything from simple additions to complex calculations involving multiple data types. For more on…
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 reason…
Inserting A Check Mark (Tick ✓) Symbol in Excel
Have you ever prepared a checklist in Excel? Checklists give you the feeling of having accomplishing a task. Their utility comes from the check marks that you can put against different items within them. Note: A check mark is also…
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? You…
How & When To Create A Data Model [5 Simple Steps]
Excel data models are made to help users integrate data from multiple tables. It is of great use to professional Excel users as it saves tons of effort and time that otherwise goes into collating data manually. All that you…
Excel’s LAMBDA Function [Simple Breakdown]
The LAMBDA Function lets you create and modify your own formulas. Instead of creating complex sets of formulas with messy referencing, just master this one skill! We will guide you through the basics of the function, and show just how…
Creating Arrays – Excel Array Formulas
Array formulas are some of the most powerful functions in Excel. But we often find on our courses that they are some of the hardest to understand! That is one big reason why you’d often find Excel users resorting to…
How To Insert An Excel Chart In A Word Document
This tutorial will show you how to insert your Excel Chart straight into a Word Document. This guide will have you put the charts from your own Excel workbook straight into Microsoft Word. This guide uses the most current versions…