by John Legge | Aug 19, 2020 | Excel Tips, Hints and Tips, Microsoft Office Courses Cambridgeshire
VBA Input Message Boxes – how can I create them in my spreadsheets? This week’s hint and tip is about VBA input message boxes in Excel. It looks at how to make an Excel worksheet more interactive by using a macro with input message boxes. We also did an... by John Legge | Jul 15, 2020 | Excel Tips, Hints and Tips, Microsoft Office Courses Buckinghamshire
Dynamic Arrays in Excel 365 – how can I use this in my worksheets? This week’s hint and tip is about dynamic arrays in Excel 365 and how you can use it in your worksheets. This feature isn’t covered in our courses, so we wanted to create a hint and... by John Legge | Jul 8, 2020 | Excel Tips, Hints and Tips, Microsoft Office Courses Cambridgeshire
Groups of option buttons in our little quiz! How many questions did you get right? This week’s hint and tip is slightly different, we are bringing you a Quiz! This quiz has been created using groups of option buttons and you can see how they are used in this... by John Legge | Jul 1, 2020 | Excel Tips, Hints and Tips, Microsoft Office Courses Staffordshire
Data Validation in Excel – how do I apply this in a spreadsheet? Watch the video to learn more This week’s hint and tip is about how to apply and use data validation within Excel. This is on our Advanced Excel course and covers where the option is found... by John Legge | Jun 3, 2020 | Excel Tips, Hints and Tips
Changing Excel chart types, styles and location – how do I do this? Watch the video to learn more This week’s hint and tip is about how to change the type, style and location of your chart within Excel. These are on our Intermediate Excel course and they... by John Legge | May 27, 2020 | Excel Tips, Hints and Tips
Inserting Excel chart elements – how do I add more detail and explanation to my charts? Watch the video to learn more This week’s hint and tip is about how to add chart elements to your charts in Excel. This is on our Intermediate Excel course and it...