AI part of Microsoft 365

Microsoft is infusing AI into many aspects of Microsoft 365 for Office users. Check out the following video for some of the new user friendly options.

https://www.linkedin.com/feed/update/urn:li:activity:6567816925953556480/

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



Slicers — Making Pivot Tables Easier

You have perfected your data analysis with a pivot table and you are about to share with other users. Slicers make Pivot Tables easier for other users to filter data in the table.

Slicers are a pop-up dialog box which allow the user to click on button to quickly filter the data.

To insert:

  1. Click in your Pivot Table.
  2. From the Pivot Table Tools > Analyze toolbar, Click Insert Slicer.
  3. Select the fields to provide a filter.
Insert slicer

4. To filter select the value on the slicer dialog box.

Slicers with Pivot Table

To select multiple values, click on the Multi-Select icon then click on the desired values. To clear the filter, select the Clear Filter icon with the red x to display all values.

Technical Disruption – Target Corp

Imagine — the busiest shopping day of the week and all of the systems to checkout customers are shutdown. Imagine you are one of the largest retailers nationwide.

Target Corporations experience an outage on Saturday of all stores nationwide due to a software outage. It seems the software outage was caused by routine maintenance — which obviously failed.

More from the Wall Street Journal at https://www.wsj.com/articles/target-stores-suffer-nationwide-outage-11560627812

Accounting and Football?

Love sports? Good at Data Analytics? There may be a new job for you.

The Southeast Conference (SEC) recently hired Deloitte to review their football officiating program. The firm is to review play by play reports and using a statistical analysis, determine if there are any outliers or exceptions. They are also to compare to other conferences to ensure quality standards are being met.

Hopefully between analysis, the auditors can watch a game or two.

https://www.accountingtoday.com/news/deloitte-hired-to-review-sec-football-officiating

New to Analytics? — Start here

Think you are new to analytics? You may have a start. Most of us in business, and especially accounting are quite adept in Excel. This makes the tool a perfect place to start. You cannot use the largest data sets, but with new Excel tools such as PowerPivot, that is constantly increasing.

Analyzing data in Excel helps you learn the process of determining which questions can be answered from the data and using an analytics technique to summarize. If you can do a Pivot Table in Excel, you are on the road to learning more about analytics.

For more information, see this article from Computerworld: https://www.computerworld.com/article/3315737/use-microsoft-excel-to-learn-about-data-analytics.html