My Accounting Information Systems students are preparing to take the Microsoft Excel Expert certification exam in a few weeks. To help them review, I have created several videos that cover topics on the exam.
I am sharing the playlist of Excel videos with you, in hopes you find something useful. Some topics that are covered include: Vlookup, Match/Index, Pivot Tables and other functions.
I will keep adding to the playlist, so please check back.
At the Consumer Electronics Show earlier this year, John Deere showcased how it is using Artificial Intelligence in its products. A large display of agricultural equipment is not what many attendees expect to find at the consumer electronics show, but a John Deere Sprayer was displayed prominently among the drones, games and other gadgets.
Not that long ago it seemed that blockchain was everywhere. The hype of blockchain as a cure-all was quite prevalent, including a commentary in the Wall Street Journal commenting how blockhain can end poverty. See article.
However, it seems that much of the hype has died for the moment as practitioners find ways to utilize blockchain when it makes the most sense, rather than implementing blockchain for the sake of using blockchain.
“In 2019 alone, an estimated $4.26 billion in cryptocurrencies was lost due to hacks, cybertheft, scams, misappropriation or insider fraud, up about 250% from 2018.” Fraudsters have upped efforts to attack cryptocurrencies in recent years.
Fraudsters are using schemes such as: embezzlement, Ponzi schemes, phishing and ransomware.
Unlike other frauds, if a person loses cryptocurrency, there is no recourse or way to recover it.
Deloitte released its 11th annual report on Tech Trends in the accounting field. Note: this report was written before the COVID 19 pandemic, so it will be interesting to see how that may change things in the 2021 report.
Some of the trends highlighted in the report include:
Macro Technology Forces – firms need to find value and bring the recent technologies together
Ethical Technology and Trust – use the new technologies in an ethical manner while building trust with all stakeholders
Finance and the Future of IT – using technology to become more agile within the organization
Digital Twins – bridge the physical and the digital operations to help the other
Benard Marr has released a new book on Tech Trends in Industry. This is a supplement to his previous books on technical practices in industry. His books have great practical examples of how various companies are using technology for practical solutions:
If you are an IMA member, there are several courses and educational opportunities available related to AIS as well as several others. If you are a student, you can become a member for $35 and take advantage of these opportunities. The following AIS-related resources are available to members, some for only a limited time
Data Analytics and Visualization Fundamentals Certificate (9 CPE)
Blockchain 101 (1 CPE)
Technology Webinars on Demand (8 CPE)
Technology II Webinars on Demand (6 CPE)
Excel 365: Tips in 10
Count Me In Podcasts — many technology topics here
Other available courses for members:
IMA Strategy and Competitive Analysis Learning Series – prep for CSCA exam
A crisis, such as the one we are in now due to COVID-10, is a time when cybercriminals thrive. A recent article in the Journal of Accountancy provides some reminders of tips your orgainization should take to strengthen your data security. Check out the article below:
Thanks to a former student, I have been trying new Digital Fitness app from PWC. During the pandemic, they are making it free for anyone wanting to better understand the changing technologies and other issues in business.
Once you setup an account, the app guides you through a quiz to determine your digital aptitude. Then based on your score it puts you on a Fitness plan. You improve your score by reading short article or watching videos on various topics from environmental impacts, basics of the blockchain and project management. The articles I have read have been quite informative and interesting.