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.
Check out this short video for a clear introductions to predictive analytics.
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 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.
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’.
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.
- Click in your Pivot Table.
- From the Pivot Table Tools > Analyze toolbar, Click Insert Slicer.
- Select the fields to provide a filter.
4. To filter select the value on the slicer dialog box.
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.
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
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.
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