EDN

Using Solver in Excel, Part 1

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 ...
How-To Geek on MSN

I use these 3 Excel formulas to organize my daily life

=LET (Spend,SUMIF (T_Budget [Category],E2,T_Budget [Cost]),IFS (Spend>F2,"Over budget",Spend=F2,"Budget hit",Spend> (F2*0.9),"Near budget",TRUE,"Within budget")) Let's break the formula down to ...
Computerworld

Analyzing Twitter with Excel, Part 1

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.
Search Engine Land

PPC Excel Tips For Every Level: Part 1, Huge Time Savers For Beginners (And Beyond)

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 ...
Visual Studio Magazine

TFS 2010 Reporting Using Microsoft Excel – Part 1

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

Using Solver in Excel, Part 2

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