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 part 1 of this blog, we managed to establish the framework for a data table to allow us to evaluate each possible combination of the whole range of resistors. The next step is to populate the data ...

Excel is that must-have tool for managing, analyzing and reporting on paid search campaigns that is impossible to know too well. Many of us are self-taught — picking up tips and tricks here and there ...

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

Q. Help! My future value calculations don’t make any sense (see the spreadsheet below). The formula in column D is the same for all rows, but for unknown reasons, it stops working after row 7. What’s ...

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.

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