When data is imported into Excel sometimes the values come in as text rather than values. Most functions can’t perform any calculations with text numbers, but one can. See how easy it is to add up text values.
Monthly Archives: October 2017
All glory comes from daring to begin.
Eugene F. Ware (1841-1911)
Word tip – increase font size
I recently found this keyboard shortcut for MS Word to increase the font size of the selected word(s).
To reduce the font size use
Our grand business in life is not to see what lies dimly at a distance, but to do what lies clearly at hand.
Thomas Carlyle (1795-1881)
Power Query Privacy Setting Problem
Excel 2016 solution
Privacy settings allow you to control who sees the Power Query data. There seems to be a bug that remembers your response to a dialog and this ignores any changes to the Privacy settings. Find out the VBA line of code that can fix it.
We could never learn to be brave and patient if there were only joy in the world.
Helen Keller (1880-1968)
Old Article
Some articles make a greater impression than others. I was recently asked about a magazine article from August 2011.
Someone had changed jobs and needed to be reminded of the rolling 13 month technique.
The congratulations relate to 15 years of Excel Yourself!
How to Handle a Formatted Table Limitation
Choose from simple or advanced
Formatted Tables are great but there is an issue when it comes to copying formula that use the table names (Structured References). There are two techniques that cope with this limitation.
Declaring Variables in Excel VBA
Using the Dim statement
In a Linkedin Excel Group recently there was a discussion about whether or not you should use the Dim statement to declare your variables. The argument was that you don’t have to and someone had managed to successfully create some code without declaring variables.
Simple Excel Drop Down List
Quick Solution
A drop down list in Excel can help speed up data input and ensure the user has entered a valid entry. If you have only a few choices, creating the drop down can be a quick process.