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
Financial Cell Formatting in Excel – using it to format your data specifically
Financial Cell Formatting in Excel – how can I use this formatting in my spreadsheets? […]
Read more
XLOOKUP and Filter Functions – new to you in a 365 update!
XLOOKUP and Filter Functions in Excel – how can I use these newer functions in […]
Read more
Ways to View a Formula in Excel – 3 different ways to see what is in a formula
Ways to view a Formula in Excel – how can I see what is actually […]
Read more
FV Financial Function in Excel – using financial functions for working out calculations
FV Financial Function in Excel – how can I use this financial function in my […]
Read more
Dependent List Data Validation in Excel – using dependent lists to make it more advanced
Dependent List Data Validation in Excel – how can I use this more advanced example […]
Read more