Tutorials and Articles

Home: Welcome

Program Mouse Clicks in Excel

In 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...

Excel Map charts

Excel's, "Filled Map", chart allows you to colour in a map based on values from your worksheet. In the following example the Australian...

Add geography data to Excel | Tutorial

In seconds you can link an Excel cell to a free database, and then use demographic data in formulae, tables, charts and anywhere else...

Excel Data Validation | Tutorial

Well thought out data validation helps users to enter consistent and accurate data, and drop-down lists of valid values can also make...

Add stock prices to Excel | Tutorial

In seconds Excel 365 users can include constantly refreshed trading prices to their stocks and shares spreadsheets - and if you have one...

Discussion and Problem Solving