Cell Line Breaks Via a Formula
When creating a cell that joins text together you may want to include a line break between parts of the text. A function and a format combined can provide that. (more…)
Special Rounding
When you need to round to a certain number, e.g. 5 cents, you can use the MROUND function. If cell A1 contains a number then the following formula will round the value to the closest 5 cent value. =MROUND(A1,0.05) The MROUND function does have some issues - see this blog post.
The New Slicer in Excel 2013
Slicers are a graphic filtering tool added in Excel 2010. They allow you to filter Pivot Tables. Excel 2013 added a new slicer that makes filtering by dates a lot easier. (more…)
Formatted table shortcuts
Two of Excel keyboard shortcuts work differently in Formatted Tables (tables that are created using Format As Table icon on the Home ribbon) Ctrl + Space normally selects the entire column(s). In a formatted table it selects the data in the column. Pressed again it selects the heading and the data pressed once more it selected the whole column. Shift + Space normally selects the whole row(s), in a formatted table it will select the row within the table.
Two Excel Functions to Format Numbers as Text
Using numbers in automated text sentences can be frustrating. Typically you don’t want to display decimals, but you do want to use the comma format. (more…)