Excel is many things: powerful, useful, colorful, handy, but its logic functions can be challenging to newcomers due to their implied logic, and a shorthand syntax designed to fit on a single line in ...

Data lookups have always been a fundamental aspect of Microsoft Excel, allowing users to retrieve and match information across datasets. However, traditional methods like VLOOKUP and XLOOKUP often ...

Microsoft Excel is a powerful piece of software that can help you sort, manipulate and interpret raw data, but many find it fearfully intimidating. If you’ve ever suspected that you’re just scratching ...

Learn how to add subtotals to your filtered data in Excel with this quick tutorial. Episode 2563 covers the essentials!

Is Apple’s iWork a viable alternative to Microsoft Office? To find out, we asked Rob Griffiths—our go-to expert on spreadsheets—to use Excel 2008 and Numbers ‘08 to create the same project, ...