How-To Geek on MSN

How to generate random numbers, shuffle lists, and create test data in Excel

Excel's randomization functions generate values, shuffle datasets, and simulate timelines using simple formulas.
Houston Chronicle

How to Organize Raw Data Into a Spreadsheet in Excel

Quit the data-search struggle by organizing your raw data into a Microsoft Excel spreadsheet. Rather than manually scrolling through a list of disorganized records, use Excel's built-in tools to find ...
InfoWorld

Book excerpt: Converting XML to spreadsheet, and vice versa

Often it is useful for XML data to be presented as a spreadsheet. A typical spreadsheet (for example, a Microsoft Excel spreadsheet) consists of cells represented in a grid of rows and columns, ...
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 ...
Journal of Accountancy

Using Excel to identify financial statement red flags

Excel is a great tool for integrating various financial statement analyses and presenting the results in a way that ...