News & Tips
AllAdobe IllustratorAdobe InDesignAdobe PhotoshopAutoCADGuides & TipsManagementMicrosoft AccessMicrosoft ExcelMicrosoft Power AutomateMicrosoft Power BIMicrosoft PowerPointMicrosoft ProjectMicrosoft SharePointMicrosoft WordNewsResilienceSQLTime Management
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…
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 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…
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…
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…
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?…
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…
Creating Arrays [Excel Array Formulas]
Array formulas are some of the most powerful functions in Excel. They let you perform multiple calculations all at once. But we often find even on our advanced Excel courses that they are some of the hardest to understand!…
Insert An Excel Chart In Word – Just 2 Steps!
Inserting your Excel Chart straight into Word will make your document This tutorial will show you how to insert your Excel Chart straight into a Word Document. This will work with Excel charts and tables. Most importantly, when you change…