One of the more interesting technology battles this year (and probably 2008) will pit Microsoft's Office 2007 coupled with SQL Server 2005 against established business intelligence players. That fact ...

Overview:  Confused between Power Query and Power Pivot? These two Excel tools serve completely different purposes but work ...

David Nield is a technology journalist from Manchester in the U.K. who has been writing about gadgets and apps for more than 20 years. He has a bachelor's degree in English Literature from Durham ...

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work. Most Microsoft Excel functions are autonomous—one ...