![](/wp-content/uploads/2022/09/course-header.jpg.webp)
News & Tips
![Screenshot showing the drop down list](/wp-content/uploads/2021/10/5a-768x492.png.webp)
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…
![Data Model Cartoon 1](/wp-content/uploads/2022/02/data1-768x382.png.webp)
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…
![Lambda Function Details](/wp-content/uploads/2024/02/Screenshot_48.png.webp)
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…
![](/wp-content/uploads/2022/04/Image-1.png.webp)
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…
![Shows the table to be copied into Excel](/wp-content/uploads/2021/09/insert1-768x179.png.webp)
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…
![](/wp-content/uploads/2022/01/Image-1.png.webp)
Calculate Age From Date of Birth – Quick & Simple!
Everyone knows asking up front, “How old are you?” isn’t a great starter! But if you have someone’s date of birth, working their age out in your head can get a bit tricky too. So why not use Excel to…
![](/wp-content/uploads/2021/12/Image-5-768x402.png.webp)
Ultimate Guide: Highlighting Duplicate Values Excel
In the working world, data is never perfect and needs cleaning up before you analyse it. If you’ve ever been handed a big data set for analysis, you’ll know they come full of duplicate values! This means it’s crucial to…
![Drag the cell handle to get the results](/wp-content/uploads/2022/06/Image-50.png.webp)
Compare Two Columns In Excel (Ultimate Guide!)
When dealing with Data analytics, comparing data populated in two or more columns is common practice. Manually comparing data could take hours or even days, depending on the amount of the data in question. But when it comes to using…
![All USD prices converted to Euros](/wp-content/uploads/2022/02/Image-8-4.png.webp)
Convert Currencies With Excel – 5 Minutes Or Less!
Suppose you have financial statistics in prepared in USD, and need it converted to GBP. Why not use Excel to solve your problem? You can use currency pairs and currency exchange rates to convert currency. Excel doesn’t come packed with…
![Screenshot showing the Format Cells Dialog Box with Percentage, Sample and Decimal places highlighted.](/wp-content/uploads/2022/01/Picture5-2-768x697.png.webp)
Calculate Percentage Difference in Excel [2 Practical Examples]
In this post, we will review how to calculate the Percentage Difference in Excel. Percentage Difference is the absolute value change of two values, divided by the average of them. The result is then multiplied by 100. Excel has a…
![Highlights the Page Layout, Margins, Normal Margins and Custom Margins buttons](/wp-content/uploads/2021/10/ELA1.png.webp)
Master Your Page Layout In Excel
Page Layout is the group of commands that control how you spreadsheet looks. This guide will go over the best options to keep control of your Excel Document. This will help you make your Excel pages more readable, more eye-grabbing…
AutoCAD for Architects
Welcome to our AutoCAD course for Architects. In it we explain how to use AutoCAD to design and layout a building. Starting with the basics of setting up a file we walk you through the process step-by-step. By the end…