Dave WestonMay 23, 20217 minProgram Mouse Clicks in ExcelIn Excel you can program actions to happen when the user left, right or double clicks the mouse. In this tutorial we use that to build a...
Dave WestonApr 20, 20214 minExcel Map chartsExcel's, "Filled Map", chart allows you to colour in a map based on values from your worksheet. In the following example the Australian...
Dave WestonApr 10, 20218 minAdd geography data to Excel | TutorialIn seconds you can link an Excel cell to a free database, and then use demographic data in formulae, tables, charts and anywhere else...
Dave WestonMar 31, 20218 minExcel Data Validation | TutorialWell thought out data validation helps users to enter consistent and accurate data, and drop-down lists of valid values can also make...
Dave WestonMar 17, 20215 minAdd stock prices to Excel | TutorialIn seconds Excel 365 users can include constantly refreshed trading prices to their stocks and shares spreadsheets - and if you have one...