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 sentence case.

The formula to convert the text in A1 is:

=UPPER(LEFT(A1,1))&LOWER(RIGHT(A1,LEN(A1)-1))

For examples, see the following:

Examples of text functions.
Examples of Text functions

Next week will continue with more useful text functions.

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 you also giving them permission to use your photo?

Images using FaceApp aging filter
Images using Faceapp aging filter

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:

https://www.businessinsider.com/faceapp-privacy-data-terms-service-russia-2019-7



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

The Downside of electric cars

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.

Electric car
Electric Car

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/

Think you need to be a data scientist?

Harvard Business Review named the data scientist the sexiest job of the 21st century. This job requires significant computing and statistical skills.

With the rise of analytics and artificial intelligence, these skills are needed, but even more critical are individuals that have excellent business acumen.

These individuals can fill the role of translator. Not in the traditional language sense, but translate business requirements for the technical individuals.

” translators play a critical role in bridging the technical expertise of data engineers and data scientists with the operational expertise of marketing, supply chain, manufacturing, risk, and other frontline managers. In their role, translators help ensure that the deep insights generated through sophisticated analytics translate into impact at scale in an organization.  “

For more on these roles, see the article at: https://hbr.org/2018/02/you-dont-have-to-be-a-data-scientist-to-fill-this-must-have-analytics-role?