Common Office 365 Features: looking at Excel, Word and PowerPoint
Common Office 365 Features – how can I use these features in Excel, Word and […]
Read more
Duplicate Values in Excel – how can I show them?
Duplicate Values in Excel – how can I shows these highlighted in my spreadsheets? This […]
Read more
NETWORKDAYS.Intl Function in Excel – what is it and how do I use it?
NETWORKDAYS.Intl Function in Excel – using this function in your spreadsheets. Have you used it […]
Read more
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