AS Excel - stylus

You will find learning Excel (and other software) far easier if you can quickly learn the names of all the…

The results from left-click-dragging the Fill Handle are dependent on the contents of the selected cell or range. Follow the…

Macros are handy tools for automating your work. Recording Macros and inspecting the code is also an easy and enjoyable…

The TODAY() function is one of the four Excel functions that does not take an argument. The function returns the…

Excel has 3 functions for rounding numbers: ROUND, ROUNDUP and ROUNDDOWN. As I explained in the post about the TRUNC…

Naming cells or ranges of cells is a powerful way to make your functions and formulae easier to read and…

The mode of a range of numbers is the number that occurs most often in that range. The mode of…

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…

When using Excel logic functions such as COUNTIF() and SUMIF() which involve ranges being evaluated based on criteria, you cannot…

Tag: AS Excel