Author Archives: ajigou

Excel Videos

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.

Here is a link to YouTube: https://www.youtube.com/playlist?list=PLF_zs3YRWdbwUfIL0uLdVRno1ZyENCGVq

Otherwise, check out my other helpful Excel tips on my blog. https://iteachais.com/category/excel/

A New Look at Machine Learning

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.

Listen to how Machine Learning is being used in agricultural equipment. https://www.investors.com/videos/ai-and-machine-learning-to-power-john-deeres-lineup-of-farm-equipment/

Blockchain in Accounting – Hype or not?

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.

A recent podcast with the Journal of Accountancy discusses where the accounting industry is at this time for using blockchain. To view the article and associated podcast, go to: https://www.journalofaccountancy.com/podcast/blockchain-accounting.html

In my opinion, the use of blockchain was over hyped at first. Now that the dust has settled, accountants can find ways to use it to increase reliability of transactions and speed up some processing.

Think Cryptocurrency is safe? Think again.

“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.

Currency Exchange Rates

Unlike other frauds, if a person loses cryptocurrency, there is no recourse or way to recover it.

For how forensic accountants can help, go to: https://blog.aicpa.org/2020/05/cyber-criminals-are-finding-ways-to-steal-your-digital-dollars.html#sthash.Sv5ebunY.dpbs

Technology Trends 2020

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

For the entire executive summary, go to: https://www2.deloitte.com/us/en/insights/focus/tech-trends.html

For the entire report, including videos, go to: https://www2.deloitte.com/us/en/insights/focus/tech-trends.html

Free CPE and Courses for IMA members

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
  • Communicating in the 21st Century
  • Strategic Management Webinars on Demand
  • Leadership I and Leadership II Webinars on Demand

To become a member, or to access these courses, go to : https://www.imanet.org/

I have taken advantage of several of these opportunities as an IMA member. I hope you find them useful.

Data Security Tips for during a crisis

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:

Image by Gerd Altmann from Pixabay
https://www.journalofaccountancy.com/issues/2020/may/data-security-tips-during-coronavirus-pandemic.html?utm_source=mnl:cpald&utm_medium=email&utm_campaign=18May2020

Free Books from Springer

Springer publishing is offering several books and textbooks for free for a limited time.

A couple of interest to AIS profressors may include:

  • Data Mining
  • Excel Data Analysis
  • Python Programming Fundamentals

To find the over 300 free books, go to https://www.springernature.com/gp/librarians/news-events/all-news-articles/industry-news-initiatives/free-access-to-textbooks-for-institutions-affected-by-coronaviru/17855960

This image has an empty alt attribute; its file name is blur-books-close-up-159866.jpg

Improve your Digital Fitness

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.

To sign-up, go to https://www.pwc.com/us/digitalfitness  . If you need a code to signup, use LRNALL.

Start improving your digital fitness 2 minutes at a time.