Technology news December 2012

Technology

Hide and Unhide Multiple Excel Worksheets with Ease

It's easy to hide worksheets in Excel, but unhiding multiple worksheets within a given workbook can be a tedious exercise. Users who don't know otherwise are relegated to unhiding worksheets one at a time.
Technology

"Big Data" for Small Businesses and Consumers

Small business owners and consumers – users of mobile devices and social media – have the potential to revolutionize economic activity and will soon become the drivers of "big data" science.
Technology

Utilizing Excel's COUNTIF Function to Break Ties

If two items on a list share the same value, MATCH/INDEX will return the same name for both items. Excel expert David Ringstrom describes how to use the COUNTIF function to create a tiebreaker in such situations.
Education & Careers

Conference Goers Headed to the Cloud

The three-day Digital CPA: 2012 CPA2Biz Cloud User Conference gathered nearly 400 accounting professionals to discuss the changing landscape ushered in by exciting new technologies.
Technology

Identifying Largest and Smallest Values in an Excel List

Excel guru David Ringstrom explains how to rank a series of items within an Excel spreadsheet using the LARGE and SMALL functions.