productivity through technology
Microsoft Excel tutorials with downloadable workbooks and step-by-step instructions and annotated screenshots.
Macros are handy tools for automating your work. Recording Macros and inspecting the code is also an easy and enjoyable…
Naming cells or ranges of cells is a powerful way to make your functions and formulae easier to read and…
Charts are an excellent way to not only visualise data but also to identify trends in data. In the following…
You will often come across the scenario where data is filled into an Excel worksheet and an error occurs that…
The Freeze Panes command makes it easier to work in spreadsheets when scrolling both vertically and horizontally by allowing the…
This tutorial explains the COUNTIF function in Excel, which counts cells meeting specific criteria within a range, featuring syntax explanation…
Below is some data from a questionnaire where the respondent was asked: “What is your favourite ice cream flavour?”. The…
When using Excel logic functions such as COUNTIF() and SUMIF() which involve ranges being evaluated based on criteria, you cannot…