Array formulas let you perform calculations across entire ranges of data in a single formula. Hence, you can handle lightning-fast lookups, filtering, and sorting with just one po ...

Excel has several advanced sorting options, but most of us never venture beyond the ordinary alphabetic and numeric sorts. If you need more than a simple sort, check out Excel’s advanced sorting ...

FILTER works well with other Excel functions like SORT and UNIQUE to create powerful data management combinations. You can ...

Have you ever spent hours perfecting a spreadsheet, only to find that a simple task like sorting or filtering data suddenly breaks? If so, you’re not alone. One of Excel’s most beloved features—merged ...

Most people view Microsoft’s Excel as a simple “spreadsheet program” that’s rapidly being eclipsed by free web-based apps that run on any cheap laptop. Well think again. Modern-day Excel is an ...

Google Spreadsheets is a free, Web-based spreadsheet tool from Google that does a surprisingly good job as a basic number cruncher, and the price is right. Google began accepting sign-ups to ...

Microsoft Excel 2007 is one of the main components of Microsoft Office 2007. It is a popular tool used by small businesses to create spreadsheets for tracking important data such as sales and customer ...

Google Spreadsheets is a free, Web-based spreadsheet tool from Google that does a surprisingly good job as a basic number cruncher, and the price is right. Google began accepting sign-ups to ...

Nick Carr offers his assessment of Google's evolving Office plan. He posits that Spreadsheets makes Excel more valuable because is provides a simple Web interface to Microsoft's Office spreadsheet--it ...