Array Syntax in Excel Formulas
With dynamic arrays making array calculations more accessible and easier to use here is a hack for using array syntax in Excel formulas.
(more…)Quotation Marks in Excel VBA
Sometimes when you are building a text string in VBA you may need to insert quotations marks. That poses a problem because quotation marks are used to surround the text you want to join and using them within the text is problematic. There is a solution.
(more…)Avoid the #DIV/0! Error in Excel
If you have the subscription version of Excel you can create your own functions. One that you may want to create avoids the #DIV/0! error. (more…)
Sparklines and Dates in Excel
A Sparkline chart is a single data series chart (graph) that exists in a cell. Usually, you only need to select one range to create a Sparkline. Sometimes you may need to handle missing dates.
(more…)Formatted Table – Change Default Colour
The standard colour for a formatted table is blue. If you use Ctrl + T to create a table, that's the colour Excel uses. You can change the default. On the Home ribbon tab, click the Format as Table drop-down and right click the colour scheme you want to set as the default. Select Set As Default from the menu - image below. Done!