Using Excel’s AND function
This function takes multiple arguments and all the arguments must return TRUE for the function to return TRUE. You will most likely find this function combined with another function, as…
productivity through technology
This function takes multiple arguments and all the arguments must return TRUE for the function to return TRUE. You will most likely find this function combined with another function, as…
Considering the fact that URLs are most often lengthy, you might find yourself in a situation where you want to “wrap” them over more than one line. Up until recently,…
When you need horizontal spacing in a paragraph other than a single space using the space bar, you should use Tab Stops (or just “tabs”). Tabs are set per paragraph…
The Freeze Panes command makes it easier to work in spreadsheets when scrolling both vertically and horizontally by allowing the user to specify heading row(s) and/or heading column(s) that should…
It is possible to export text from many applications and most databases in a structured manner, for example, CSV or tab-delimited text. Where such text is available, it is possible…
The English language employs a number of different dash-like punctuation marks. These have largely fallen out of favour as keyboards and touchscreens offer easy access to the now much-abused dash.…
This is something that is tested almost every year in Grade 12 exam papers: the Subtotal command in the Outline group of the Data ribbon. It is a useful way…
When you create a Form you select the underlying object. A Form can be based on a table, or multiple tables, or a query, or multiple queries. When you create…
OK, so the following scenario catches me every time: Conditional Formatting of cells based on values in a separate range of cells! In the example below, we have rows of…
The Table of Contents feature relies on the use of Styles in a document. The feature works “out-of-the-box”: it is based on the default Heading 1, Heading 2 and Heading…