This excerpt from the CGMA report 'Re-inventing Finance for a Digital World' highlights how a machine-learning system delivered tremendous forecasting efficiencies for one company.
The Name Manager can make spreadsheets easier to follow, but Excel modellers must know how โ and, more importantly, when โ to properly use the tool.
Even before releasing Excelโs new array functionality to the general public, Microsoft has improved one function and replaced another in a move that could put current spreadsheets @ risk.
With the right toolset of techniques, you can design spreadsheet models that smoothly produce forecast projections using historical and current information.
Youโve heard of blockchain, artificial intelligence, and robotics. Here are six trends that will grow in importance this year and what you need to know about each.
In the final instalment of a seven-part series, Excel MVP Liam Bastick wraps up his examination of Excelโs new Dynamic Arrays capabilities by assessing how they could affect Excel features Data Tables and PivotTables.
In Part 4 of a seven-part series, Excel MVP Liam Bastick takes a look at two of the seven new functions Microsoft has created to go with its spreadsheet programโs new Dynamic Arrays capabilities.
In Part 6 of a seven-article series, Excel MVP Liam Bastick explores two of the seven new functions Microsoft has created to go with its spreadsheet programโs new Dynamic Arrays capabilities.