SoCal Chapter Webinar – Preparing Data for Cost Estimating: Data Consolidation Techniques in Excel

Michael Finnegan has often found it useful in his career to ask two key questions: “How can I make this easier in Excel?” and “How can I reduce my file size?” Join him on Wednesday, April 9th for a lunchtime webinar as he walks through some basic (and not-so-basic) Excel capabilities relevant to cost estimating. Michael builds tools for data consolidation, escalation, reporting, learning curves, pricing, CER development, and more– while taking approach that avoids a “black box.” He strives to create (and encourages others to create) Excel tools that everyone can use, understand, and replicate. Toward that end, Michael will demonstrate how he applies INDEX/Match, SumIfs, OFFSETs, Power Query, and other techniques for consolidating and analyzing data. He will also show various methods he uses to keep his file sizes small enough to operate efficiently while handling large(ish) data sets from various sources.