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
Time Calculations in Excel – using cell formatting to allow use of these in spreadsheets
Time Calculations in Excel – how can I use cell formatting to allow use of […]
Read more
PDF Data into Excel – using the ‘Get Data’ feature in Excel to save you time!
PDF Data into Excel – how can I use the ‘Get Data’ feature in my […]
Read more
VBA Input message boxes in Excel – something to stretch your knowledge
VBA Input Message Boxes – how can I create them in my spreadsheets? This week’s […]
Read more
Dynamic Arrays in Excel 365 – what is it and how can I use it in Excel?
Dynamic Arrays in Excel 365 – how can I use this in my worksheets? This […]
Read more