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?
Analytics Insight

Top Statistical Analysis Tools Compared in 2026: Pros and Cons Explained

Overview:Choosing between tools like Tableau and Microsoft Excel depends on whether users need fast visual reporting or ...
Geeky Gadgets

How to use Google Sheets for Data Analysis

Google Sheets is a powerful tool for data analysis, offering a range of functionalities that cater to both beginners and intermediate users. This article aims to guide you through the process of ...
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 ...
csis.org

Innovative Data Collection Methods for International Development

Innovative technologies of the Fourth Industrial Revolution (4IR) are transforming and modernizing the way data is generated, collected, and analyzed across different industries and fields of study. 1 ...
Investopedia

Scenario Analysis Explained: Techniques, Examples, and Applications

Adam Hayes, Ph.D., CFA, is a financial writer with 15+ years Wall Street experience as a derivatives trader. Besides his extensive derivative trading expertise, Adam is an expert in economics and ...