The COUNTIF worksheet function in Microsoft Excel has a simple format that provides a quick and easy way to count the number of times a certain condition is met in a data set. By Kara Monroe That sounds imposing but it isn’t. Most likely you already use COUNT to count the number of cells that […]
Excel has an in-built feature to remove duplicates from a list but what if you want to delete both items if they are duplicated or more than two? Remove Duplicates Remove Duplicates is tucked away on the Data tab, Data Tools | Remove Duplicates. It will ensure that an Excel list/table has only unique values […]
The appearance of all your captions in Microsoft Word can be changed by modifying the style that is applied to them or selecting the text and formatting manually. See Adding Captions in Word Caption Style All captions use the ‘Caption’ style, so modifying that style will modify the format of all past and future captions. Style […]
Captions let you add autonumbered labels under most Word objects including pictures (figures), tables or equations. Captions can be combined into a list of all the figures/tables/equations in the document, along with their page numbers. As usual in Word, there are many options beyond the simple adding of captions and some ‘gotchas’ as well. See Changing […]
What’s the difference between aligning to a page and align margin in Word documents? Quite often, there’s no practical difference between ‘Align Page’ and ‘Align Margin’ in Word. These options appear when positioning an object on a page and other places. Centering an object has to be done compared to some defined ‘edge’ of a […]
