Check out this short video for a clear introductions to predictive analytics.
Check out these publications from O’Reilly which have been made available to you for free.
Some of these are older editions, but they are still valuable. Enjoy!
There are times text needs to be converted to lower case, proper case, or upper case for consistency sake. Excel provides functions to easily convert text in these cases.
However, Excel does not convert text to sentence case — the first letter only is capitalized. Using a combination of functions will easily convert text to sentence case.
The formula to convert the text in A1 is:
For examples, see the following:
Next week will continue with more useful text functions.
A recent trend in social media is the use of FaceApp. Upload your photo and it will return an image of how you would look in the future. You may also use the app to change your appearance in a variety of manners. Although it appears to be a fun use of Artificial intelligence, are you also giving them permission to use your photo?
From FaceApp’s Terms and Conditions: ” You grant FaceApp consent to use the User Content, regardless of whether it includes an individual’s name, likeness, voice or persona, sufficient to indicate the individual’s identity. By using the Services, you agree that the User Content may be used for commercial purposes. “
According to this, they can use your photo as they like — including selling it.
To read more about their policy:
Here is a new tip for me. If you type 10 space a, Excel will return 10:00 AM. Similarly, if you type p rather than a, it will return 10:00 PM.
Unfortunately, to get 9:39 AM, you still have to enter 9:39 space a, which isn’t as much of a timesaver.
The AICPA issued new standards for those that perform forensic accounting services engagements.
The standard defines forensic services as those “provided for investigation or litigation”.
To read more about the release of standards, go to: https://www.journalofaccountancy.com/news/2019/jul/forensic-accounting-aicpa-standards-201921580.html
To review the Statement on Standards for Forensic Services No. 1, go to: https://www.aicpa.org/content/dam/aicpa/interestareas/forensicandvaluation/resources/standards/downloadabledocuments/ssfs-no-1.pdf
The Institute of Management Accountants has a new podcast called “Count me In.” The bi-weekly podcast covers the latest developments in the fields of accounting and finance.
Topics thus far include blockchain, business innovation, data analytics and much more.
Go to https://podcast.imanet.org/ to subscribe.
Data analytics is changing many areas of accounting. One area that it will have a dramatic effect is financial planning and analysis.
The following chart shows some of the differences.
For a more complete review of the changes, go to: https://sfmagazine.com/post-entry/july-2019-profitability-analytics/
Can their be a downside? When electric cars are running, they are virtually silent. This poses a danger to those that may be visually impaired, shorter, or even those that are distracted.
The European Union has proposed that these cars be fitted with an Acoustic Vehicle Alert System that will vary the noise with the speed of the vehicle.
To read more about this feature, go to: https://sfmagazine.com/technotes/june-2019-quiet-streets-are-becoming-too-dangerous/
Your colleague just handed you a complex spreadsheet for you to maintain. The first thing you need to know is which cells contain formulas.
The easiest way to display all formulas is to press CTRL + ~ (tilde).
The tilde is on the key to the left of ‘1’.