Time goes, you say? Ah no! Alas, Time stays, we go.
Henry Austin Dobson (1840 – 1921)
Monthly Archives: December 2017
Copying a Date Down a Long List in Excel
Two techniques make it quick and easy
There are a number of mouse and keyboard shortcuts for copying. But there is one type of copy that can be frustrating. Copying dates can be challenging because, in general, Excel wants to increment them, not copy them. There is a simple technique to instruct Excel to copy a date.
A library is thought in cold storage.
Herbert Samuel (1870 – 1963)
Columns in a Text Box
You learn something new every day.
Today I discovered that you can have columns within a text box.
If you right click the text box and choose Format Shape the Task Pane below should open on the right.
Click the third icon (Size and Properties) at the top and then open up the Text Box options.
The Columns button allows you to specify how many columns plus the gap between them.
Have fun.
Towards a Simpler IF Function
New function in Excel 2016
Excel 2016 has introduced a new type of IF function to simplify handling multiple conditions. It is called IFS.
2017-12-12
Top Ten
Woohoo – my book made it to 3 on the top ten e-books in the CPA Library.
A man travels the world over in search of what he needs and returns home to find it.
George Moore (1852 – 1933)
Handling DR and CR at the end of numbers in Excel
Sorting out debits and credits
Some systems add DR and CR to the end of numbers when they export into Excel. This renders the values useless for normal calculations. You can use data cleansing techniques to remove the characters using formulas or Power Query. There is one function however that can perform calculations on these types of entries.
I cannot remember the books I have read any more than the meals I have eaten; even so, they have made me.
Ralph Waldo Emerson
Hide and Seek with Excel Charts
Hiding rows and columns
Charts have a behaviour that many people don’t realise. That behaviour can also be turned off. If you hide a row or column in the data range used by a chart, the values will also be hidden on the chart.
If you are after some worthwhile reading check out this list.
I have three of them and a few are on my wish list.