In a data area, several cells are selected by highlighting in a different color. The example show cells that were manually selected, rather than using conditional formatting. However, if cells are shaded or have a different font color due to conditional formatting, this will work as well. These can easily be sorted to the top …
Author Archives: ajigou
Unintended consequence of AI
To develop a new Artificial Intelligence model, it needs to be trained. This is done by processing a large amount of data several times until the model works. With AI models becoming more complex, larger datasets are required to fully operationalize the model. This is taking significant amounts of computing power, and thus, electricity. In …
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 …
Study: Women more affected by automation
There is no doubt that emerging technologies such as artificial intelligence, blockchain, and robotic process automation are going to change the skills needed in the workplace. A recent global report by McKinsey Global Institute showed that women may be more affected than men by automation. A summary of their findings: Women and men face a …
Excel Tip: Easily enter Absolute references
When entering formulas, use the F4 key to toggle between absolute and relative references. When typing the above example, after typing “A1”, press F4. Keep pressing F4 until the combination of absolute/relative references appears. Press F4 to make cell value Absolute For a refresher on the differences between Relative and Absolute references, go to: https://www.youtube.com/watch?v=7Gh-sRgV-DA
I Teach Accounting Information Systems 