News & Tips
Implementing 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…
How to Use the Moving Average Forecast in Excel
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. It’s a technique that has a…
SORT And SORTBY Functions – Mastering Excels Array Tools
If you’ve ever tried doing so, you’d know how problematic data sorting in Excel could be. Doing it using formulas, you’d have to put together an insane combination of functions. However, the new dynamic array functions make it super-easy for…
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. We find delegates always want to learn about Flowcharts in our top-rated Microsoft Excel courses. What Is A Flowchart?…
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…
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…
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…