Jul 31, 2020
Excel – Fill in the Blanks
Spreadsheets are fantastic not just for number crunching but for extracting useful information from large quantities of data. Filtering, sorting, pivot tables all allow [...]
May 07, 2021
Have you ever...?
Have you ever...? These three words at the beginning of a sentence usually mean that the person asking has done something in the past that they're not quite sure [...]
Feb 05, 2021
Control your code with GitHub
When it comes to software development especially big projects, it can be frustrating when you are unable to compare a current piece of code to the previous versions, or [...]
Sep 30, 2020
Customise the Ribbon in an Excel workbook
We all know how to customise the Ribbon in Microsoft Excel by using the graphical user interface, but the problem with this way of customisation is that if you move the [...]
Sep 23, 2020
Asynchronous programming in C#
One of the most interesting new features in C# 5.0 is the support for asynchronous functions with the introduction of the new keywords, async and await. Writing [...]
May 29, 2021
3 programming tips in Visual Basic
As per the Microsoft Developer Network website, Visual Basic is engineered for productively building type-safe and object-oriented applications. Here are 3 tips I've [...]
Jan 17, 2021
Continuous Integration with Visual Studio
Continuous Integration (CI) is the process of automatically generating a build whenever code is checked into a source code repository system. With CI, the developer does [...]
