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
Nested IF Statements – using them in your data with other functions
Nested IF statements – how do I create a nested IF statement? Watch the video […]
Read more
Excel Sorting – a video on how to sort your data in Excel
Excel Sorting – how do I sort my data in Excel? Watch the video to […]
Read more
Replicating your spreadsheet layout…surely there must be a quick way?
Replicating your spreadsheet layout…surely there must be a quick way? This week’s hint and tip […]
Read more
Borders and Fill Colour, do you use them in your spreadsheets?
Using Borders and Fill Colour in your spreadsheets to make them stand out This week’s […]
Read more