The January 2017 JofA article “Data Mining Your General Ledger With Excel” presents a step-by-step, formula-based approach to extracting general ledger data and then scrubbing them so that they can be ...

Simplify your data transformation by skipping complex parsing expressions and instead using Flash Fill and Power Query in Microsoft Excel. Image: IB Photography/Adobe Stock If you work with imported ...

Have you ever spent hours wrestling with messy spreadsheets, trying to clean up data that just won’t cooperate? Or maybe you’ve found yourself manually merging files, painstakingly copying and pasting ...

Have you ever found yourself staring at a sprawling Excel workbook, wondering if you’re using the right tool for the job? Between Power Query, Power Pivot, and VBA, it’s easy to feel like you’re ...

Web query files are spreadsheets that Microsoft Excel creates using data from Web pages. For example, if your business wants to analyze stock data, a Web query can extract such data from a financial ...

The article How to use Microsoft Lists to organize Excel data you must track or share is an introduction to sharing Microsoft Excel data with other users via a list prepared by the Microsoft Lists app ...

Slicers provide an intuitive, user-friendly interface for filtering data in a spreadsheet. Here’s how to create slicers, format them, and use them to filter data in Excel. Spreadsheets’ greatest ...

Brian Beers is a digital editor, writer, Emmy-nominated producer, and content expert with 15+ years of experience writing about corporate finance & accounting, fundamental analysis, and investing.

Conditional formatting highlights key information in a spreadsheet so it’s easy to see at a glance. This beginner’s guide gets you started. Spreadsheets usually hold a wealth of information, but it ...