top of page


Derek Burrows-Johnson
Mar 24, 20231 min read
From Spreadsheet to Dashboard: How Microsoft Excel is Enabling Better Decision-Making for Businesses
Business professionals have long relied on Microsoft Excel as their go-to application for data management, analysis, and reporting. Excel...

Derek Burrows-Johnson
Mar 17, 20231 min read
5 Essential Excel Tricks for Mastering GPT-4 Chatbot Training
Conditional Formatting: With Conditional formatting, you can color-code and highlight particular cells, columns, and rows in your excel...


Derek Burrows-Johnson
Mar 6, 20232 min read
Why AI Is the Future of Excel and Data Analytics
Data analytics is now an essential component of decision-making across industries in today's data-driven environment. The spreadsheet...

Derek Burrows-Johnson
Jan 30, 20232 min read
Protecting Your Work: How to Mark Your Excel Workbook as Final
When it comes to your Excel workbooks, it's important to protect the integrity of your data. One way to do this is by marking the...

Derek Burrows-Johnson
Dec 16, 20221 min read
How to Use Flash Fill in Excel
Flash Fill in Excel is a tool that detects patterns in your data and fills in information to save you time. So for example in the columns...

Derek Burrows-Johnson
Dec 16, 20221 min read
VLOOKUP - How and When to Use It
VLOOKUP function is used when a person is trying to find a piece of information in a large set of data In the Formula Bar, type...

Derek Burrows-Johnson
Nov 28, 20221 min read
Data Sorting in Excel - Essential Excel skills series
1. Select a cell with the data. 2. Select Home>Sort & Filter 3. Select one of the following options: Sort A to Z - Sorts the selected...


Derek Burrows-Johnson
Nov 15, 20224 min read
20 NEED TO KNOW EXCEL SKILLS FOR WORK
DATA FILTERS In Excel, data filters allow you to create complex queries and extract actionable insights from your workbook. When you know...


Derek Burrows-Johnson
Nov 10, 20222 min read
The rise of online courses since COVID
Since Covid started in late 2019, there's been a trend in people taking courses online. The trend is that it's much easier to learn...

Derek Burrows-Johnson
Nov 3, 20222 min read
Excel is the most in demand workplace skill
Excel skills are important in the workplace because they are necessary for data tables. With these skills, companies can have trained...

James Dupuis-Howard
Oct 1, 20222 min read
Why Google Sheets over Excel?
First off, kudos to google for making google sheets. It's amazing. The best part of google forms and google sheets for me is they are...

James Dupuis-Howard
Sep 20, 20222 min read
XLSX vs XLSM
Maybe you are wondering why is it important? For Microsoft Excel, the difference between .XLSX and .XLSM files is quite simple. The .XLSM...
bottom of page