SUMIF and COUNTIF Functions in Excel – what do they do?
SUMIF and COUNTIF Functions in Excel – using these functions in your spreadsheet, have you […]
Read more
Formula Conditional Formatting in Excel – using formulas to apply it
Formula Conditional Formatting in Excel – how can I use formulas to apply conditional formatting […]
Read more
Excel Green Triangle Errors – what do these mean?
Excel green triangle errors – have you ever come across these errors/notifications before? Watch the […]
Read more
RANK and XLOOKUP in Excel: using these in spreadsheets
RANK and XLOOKUP – how can I use both of these my worksheets? This week’s […]
Read more
Excel Shortcuts Part 2 – F2, F4 and cut, copy and paste shortcut keys
Excel Shortcuts Part 2 – the F2 and F4 function keys and cut, copy and […]
Read more
Excel Shortcuts Part 1 – F1, F11 and undo/redo shortcut keys
Excel Shortcuts Part 1 – the F1 and F11 function keys and undo/redo shortcut keys, […]
Read more
Creating a beep sound in Excel – how to make a beep appear on command!
Creating a beep sound in Excel – did you know you could make the sound […]
Read more
SORT Function in Excel – using this newer function in your spreadsheets
SORT Function in Excel – how can I use this function in my spreadsheets? Watch […]
Read more
Excel Useful Features – using flash fill and text to columns in spreadsheets
Useful Excel Features – how can I use the flash fill and text to columns […]
Read more
Pivot Table from an Excel Table – another way of creating a pivot table
Creating Pivot Tables from a table format in Excel – how can I do this […]
Read more
6 MS Office shortcuts in Excel, Word and PowerPoint to save you time
6 MS Office shortcuts that you can use to save you time with your work […]
Read more
CONCATENATE Function in Excel – using a text function in your spreadsheet
CONCATENATE Function in Excel – how can I use this function in my spreadsheets? Watch […]
Read more