![](/wp-content/uploads/2022/09/course-header.jpg.webp)
News & Tips
Excel: Audit Formulas To Ensure They’re Correct
Excel has a variety of powerful tools in it’s toolbox to help you see what is going on in a spreadsheet with formulas. Formula Auditing can show you which cells are using what information in them and where the information…
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
What if all your data could be linked across from one sheet to another? You would stop needing multiple copies of the same data. You’d also minimize the risk of incorrect data due to forgetting to update the information across…
![Comprehensive data model](/wp-content/uploads/2024/03/Screenshot_56.png.webp)
6 Best Practices for Efficient Data Modeling in Power BI
Why do over 62,000 businesses worldwide choose Power BI for analytics? The visuals are simply the best on the market. However, Power BI can be complex and difficult to use, especially for newcomers to the software. This is especially true…
![](/wp-content/uploads/2023/11/FindFunction.png.webp)
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.” FIND…
![Count Function Syntax](/wp-content/uploads/2023/12/Count-Function.png.webp)
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. COUNT Function Details …
![Average function](/wp-content/uploads/2023/12/aVERAGE-1.png.webp)
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 Excel…
![TRIM Function Syntax](/wp-content/uploads/2023/12/Trim-Function.png.webp)
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. TRIM Function Details Available in: All versions of…
![](/wp-content/uploads/2023/11/SumFunction.png.webp)
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. Excel Function Details…
![Example Of A Tree Decomposition Visual in Power BI](/wp-content/uploads/2024/03/Screenshot_52.png.webp)
Decomposition Tree Visuals – Quick Guide!
Power BI has a wide range of visuals, both built-in and ones you can download. Many users stick to the tried and tested visuals in their Power BI dashboards, even when they are sub-optimal. Finding the right visual can make…
![Screenshot showing where to find the Form Control Checkbox and the ActiveX Checkbox.](/wp-content/uploads/2022/06/Screenshot141-768x683.png.webp)
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…
![Adding checkmarks in both empty and occupied cells](/wp-content/uploads/2022/06/Image-11-2.png.webp)
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…