In Part 1 of this blog, we looked at the way that Excel can help generate an equation that describes a curve based on collected data. Then, that curve can be linearized. We left off noting that the ...

Learn how to add, configure and use checkboxes in Excel to create interactive task lists and trigger formatting without relying on macros. Recently, Microsoft has introduced the ability to add ...

In the first part of this blog, Using Solver in Excel, Part 1, we started looking at what we can do with the Solver add-in to the Excel spreadsheet program. We looked at using Solver for the design of ...

Microsoft recently announced that they are adding a feature to Excel that will allow Python code to be embedded and used for advanced analytics. That made me wonder if it might be possible to create ...

Today we have more handy Excel tricks from Bing Ads Evangelist John Gagnon. This second installment of PPC Excel tips focuses on intermediate level techniques for speeding up campaign analysis. Paid ...

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 ...

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.