Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.

Breakthroughs, discoveries, and DIY tips sent every weekday. Terms of Service and Privacy Policy. Let’s all come together and face it: spreadsheets can be scary ...

Excel macros use Visual Basic code to perform functions unavailable through the program's graphical controls. For example, macros can extract data from a sheet, perform string operations on them and ...

FILTER works well with other Excel functions like SORT and UNIQUE to create powerful data management combinations. You can nest FILTER inside SUM or AVERAGE formulas to calculate values from filtered ...

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, ...

Relying solely on fundamental Excel skills is becoming obsolete, especially for CPA firms aiming for operational excellence and competitive advantage. Traditional spreadsheet proficiency, while ...

Microsoft announced in early 2012 that it would extend support for aging Visual Basic 6 runtimes and code syntax for the entire life cycle of Windows Vista, Windows Server 2008, Windows 7 and the ...