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
Inserting Excel Chart Elements – adding more details to your chart
Inserting Excel chart elements – how do I add more detail and explanation to my […]
Read more
Inserting Excel Charts – how do I do this? Learn three ways you can here
Inserting Excel Charts – how do I create a chart in Excel? Watch the video […]
Read more
Excel linking – linking within a workbook and between workbooks
Excel Linking – how do I create links between worksheets in a workbook and also […]
Read more
Excel Filtering – a video on how to filter in your data in Excel
Excel Filtering – how do I use the filter in Excel? Watch the video to […]
Read more