top of page
Derek Burrows-Johnson
Dec 30, 20222 min read
IF Function
WHAT IS IT? The IF function in Excel is a powerful tool that allows users to perform conditional logic in their spreadsheets. It allows...
Derek Burrows-Johnson
Nov 30, 20221 min read
Creating a PivotTable
Select the cells you want to create the PivotTable from Select Insert>Pivot Table 3. Once you click this, it will create a PivotTable...
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...
James Dupuis-Howard
Oct 10, 20224 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 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...
bottom of page