My main program is the Excel Pro Challenge. It is a 15-day step-by-step course that takes you from beginner to confident — ...

Excel's query tool reshapes messy imports into 1NF, so AVERAGEIFS replaces hacks and your summaries run faster.

Microsoft Excel is a useful tool for managing data sets large and small. But it can quickly turn frustrating if you're unsure how to get the desired outcome to sort your spreadsheet with so many menu ...

Hiding lines, or rows, in Microsoft Office Excel 2010 is very simple: Right-click the lines and select "Hide." However, expanding the hidden lines in the Excel spreadsheet is not as simple. To get the ...

Audit hidden data, filters, and hard-coded values to ensure your Excel spreadsheets are professional and precise.

You’d think stock traders, of all people, would have the best data available. But that wasn’t the case when JPMorgan started bleeding billions on bad trades. Investors got worried. The bank dismissed ...