Leslie Kramer is a writer for Institutional Investor, correspondent for CNBC, journalist for Investopedia, and managing editor for Markets Group. Correlation measures the linear relationship between ...

Almost every day you can find in media commentary that XYZ is causing stocks to fall (or rise). Such definitive statements are common—but what’s almost always missing is statistical proof. And if you ...

Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on certain arguments you input. However, combining—or nesting—functions ...

1. Is there a way to subtotal large volumes of numbers in Excel 2010, while ignoring the values contained in hidden rows? 2. What is the best way to subtotal data in Excel 2010 that contain ...

Excel's AGGREGATE function lets you perform calculations whilst ignoring hidden rows, errors, or other functions that appear in the data. It's similar to the SUBTOTAL function but provides more ...

Suzanne is a content marketer, writer, and fact-checker. She holds a Bachelor of Science in Finance degree from Bridgewater State University and helps develop content strategies. Learn about our ...