top of page


Excel Macros with ChatGPT
The new AI tool is a powerful tool and can help produce macros in your Excel tables to automating data entry or data cleaning tasks,...
Derek Burrows-Johnson
Jan 20, 20232 min read

Quick Analysis in Excel Using Charts
Select a range of cells. Select the Quick Analysis button that appears in the bottom right corner after the data is selected. You can...
Derek Burrows-Johnson
Dec 17, 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

Create a Chart in Excel - Visualize your Data
Select the data in the chart you want to visualize Select Insert > Recommended Charts Select the chart you'd like to preview on the...
Derek Burrows-Johnson
Dec 9, 20221 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 10, 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...
Derek Burrows-Johnson
Nov 3, 20222 min read


The benefits of having a trained Excel & tables workforce
The benefits are clear with Excel and tables workforce. You can save time, make more money and even transform your life. People often...
James Dupuis-Howard
Oct 10, 20224 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
Oct 1, 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...
James Dupuis-Howard
Sep 20, 20222 min read
bottom of page