Accountants as Storytellers

Accountants not only need to analyze data and interpret the results, but they need to tell the story behind the data.

” Stories aren’t just for entertainment. Powerful stories evoke emotion and can inspire us to take action and make changes in ways that a PowerPoint data dump can’t. Those just put us to sleep like a lullaby. “

Help your clients understand the data and better relate to the facts.

For more information see the article at:

https://www.accountingtoday.com/opinion/why-accountants-need-to-be-data-storytellers

Excel Tip – Keyboard shortcuts

The fastest Excel users have one thing in common They rarely use the mouse. Most all actions in Excel can be done with a keyboard shortcut. Here are some of my favorites:

CTRL + HOME — Go to Cell A1

CTRL + END — Goes to the last cell used. 

CTRL+SHIFT + right arrow then down arrow — will select all contiguous cells

CTRL + A –  Selects entire spreadsheet

F4 – Changes cell address to Absolute

CTRL + T – Converts data range to a table

CTRL + E — Flash Fill 

CTRL + ; — Inserts the current date.

Would you sell your work password?

According to a recent survey, 20% of employees would sell their work userid and password for less than $100.

This highlights a serious issue in corporate security. How can IT protect the systems, not just from human error, but from intentional misconduct?

To read a summary of the results, go to
http://fortune.com/2016/03/30/passwords-sell-poor-sailpoint/

Can AI tell if I am angry?

Artificial Intelligence has been used to play Jeopardy, respond to verbal requests to play music, and answer trivia questions. It is also widely used in the business workplace to automate processes and predict results. AI is evolving to understand further nuances in a users voice to detect emotions.

The Wall Street journal examines the possibilities of AI:

https://www.wsj.com/articles/what-ai-can-tell-from-listening-to-you-11554169408

The Journey Begins

Welcome to my blog.  This website is to provide resources to those teaching Accounting Information Systems and related courses.  It will provide some resources for instructors to use to get started as well as news items that apply to the world of accounting and information systems.

Thank you for joining me!

Good company in a journey makes the way seem shorter. — Izaak Walton

post

Excel Tip: Quick Fill Down

Excel is THE tool for accountants. There is rarely a day that will go by without using Excel. Each Monday, this blog will post a time saving tip that is helpful. Enjoy the first tip!

In larger spreadsheets, I used to spend lots of time dragging the cursor down a column to extend a formula for hundreds of rows. This trick will save lots of frustration and TIME!

By simply double-clicking on the Fill Handle in the lower right-hand corner of the cell, the formula will copy down the column.

NOTE: The column to the left of the formula needs to contain data. If there is a blank cell in the column to the left, the formula will stop at that row. In other words, the data in the adjacent column must not contain empty cells within the data.

I hope this tip saves you as much time as it has saved me!