Enhancements in the .NET Framework 4 and Visual Studio 2010 make Office automation solutions easier than ever to write and deploy. Here's an Excel automation scenario that reflects solutions that I've ...

Microsoft is expanding its horizons with its newly revealed Office 2010 software suite. The updated Office will be available in two separate formats: a traditional PC-based edition and a completely ...

This morning, Microsoft opened the tech preview of its long-anticipated Office Web Apps. Here’s a first look at what the online version of Excel has in store. From the online SkyDrive folders, you can ...

In a year when big names from the digital realm profoundly affected the world—Mark Zuckerberg or Julian Assange, take your pick—it's appropriate to add one more: Douglas Klunder. While largely ...

Simplify your data transformation by skipping complex parsing expressions and instead using Flash Fill and Power Query in Microsoft Excel. Image: IB Photography/Adobe Stock If you work with imported ...

How to reference cells with the COUNTIF function in Excel Your email has been sent Use COUNTIF to count values in a range that meet a certain condition and return a specified number to the cell.