Percentages are calculated for many things, such as interest rates, income tax, profit margins, restaurant bills, and possession in football matches. There are three main percentage calculations; each is shown in the document. Percentage of Total (Page 1) The exam…
Excel’s status bar shows various statistics based on the values in the selected cell range (e.g. sum, average, max and min). Right-clicking on it opens the Customize Status Bar menu where you can choose what is featured. Microsoft stealthily snuck…
I’ve often wondered why the Format Cells window for conditional formatting only has half the border styles found in the standard one. I like the thick border styles because they stand out more. There have been numerous occasions when I’ve…
The easiest way to find the difference between two dates is to subtract the older date from the newer one. That will return the number of days; however, you may want it in weeks, months or years. DATEDIF is a…
VBA lacks a keyboard shortcut for commenting. This is a standard feature in modern IDEs, however, the VBA Editor is not modern, so we are forced to tolerate its drawbacks. Comments are denoted using a single quotation mark (‘). Block…
Press Shift + Ctrl + A after a function to display all its arguments. Then put a leading single quote to signify text. I often find this useful if I need to retrieve the arguments of a function I’m explaining….
End of content
End of content
