When I was in high school, we used to plot points on graph paper and then try to fit a curve with some plastic templates named in undoubtedly sexist terms as French Curves. There was also a flexible ...

Solver allows you to use an Excel spreadsheet to easily solve problems with multiple variables. We'll look at a couple of examples to see what Solver can do and how easy it is to use. Solver is an add ...

So, you’ve made it through a particularly busy month or quarter, and you finally have a moment to breathe and gather your thoughts. Your first thought may be: What should I do next? This is the ...

Excel is one of those programs with so much depth that there are whole areas many of us will never come to grips with. One such area is Excel’s support for XML through the program’s XML maps feature.

Create robust, backward-compatible Excel workbooks by leveraging the structural power of the ROWS function.

TFS 2010 uses SQL Server Reporting Services to provide reports, but because it uses data warehouse and analysis services to store reporting information, users can roll their own. In this column we are ...

When Google rolled out penguin there was a tizzy online. Site owners freaked out, SEOs began running tests and searches to figure out what exactly happened. One of the characteristics that seemed to ...

In the second part of this two-part series, Mickey Gousset shows how TFS 2010 lets users create Excel reports, including pivot tables and charts, from a work item query. The report can then be ...