JournalofAccountancy

Using Excel’s What-If Analysis with Data Table for data analysis

Q. You explained Excel’s Scenario Manager in your November 2024 Tech Q&A article and Goal Seek in your December 2024 Tech Q&A article. Can you please explain the final What-If Analysis tool: Data ...
Technical

City data analysis: Just one example of how LLMs and AI can help efficiency

How can the mainstream adoption of language learning models (LLMs) and other generative AI tools help workers be more productive and efficient in their work? Data analysis is one area where the use of ...
The New York Times

How data departments have evolved and spread across English football clubs

The data genie is well and truly out of the bottle. The presence of data-driven consultancies, the rise of public data websites and the growth of its use in the media (cough, cough) highlight how ...
JournalofAccountancy

Using Excel’s Goal Seek for data analysis

Q. In your November Tech Q&A article on Excel’s Scenario Manager, you mentioned two other “what-if” tools: Goal Seek and Data Table. Can you show how those work like you did with Scenario Manager?
Investopedia

Financial Ratio Analysis: Definition, Types, Examples, and How to Use

Andrew Bloomenthal has 20+ years of editorial experience as a financial journalist and as a financial services marketing writer. David Kindness is a Certified Public Accountant (CPA) and an expert in ...
Investopedia

Pareto Analysis: Definition, How to Create a Pareto Chart, and Example

Will Kenton is an expert on the economy and investing laws and regulations. He previously held senior editorial roles at Investopedia and Kapitall Wire and holds a MA in Economics from The New School ...