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
Groups of option buttons in our fun quiz! Have a go and let us know!
Groups of option buttons in our little quiz! How many questions did you get right? […]
Read more
Data Validation in Excel – how to apply it to cells in your spreadsheet
Data Validation in Excel – how do I apply this in a spreadsheet? Watch the […]
Read more
Changing Excel Chart Types – changing types, styles and location
Changing Excel chart types, styles and location – how do I do this? Watch the […]
Read more