Check out these publications from O'Reilly which have been made available to you for free. https://www.datasciencecentral.com/profiles/blogs/80-free-data-science-books Some of these are older editions, but they are still valuable. Enjoy!
Excel Tip – Text Functions #1
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 …
FaceApp – Invasion of Privacy?
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 …
Shortcut to type times
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.
New Forensic Accounting Standards
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
I Teach Accounting Information Systems 