Everything you need to know to become an Excel power user in Advanced Formula Techniques including;
Step 1: VLookup, R1C1 Notation, Match Look up, Composite Indexing, Correcting indexing & data types & much more
Step 2: Named Ranges, Rounding Options, Structured References & Conditional Calculations
Step 3: Array Formulas, Circular References, Mega formulas, Debugging Formulas, Additional Tools & much more
This course offers real-life business problems. Each topic starts with a problem and then provides a strategy for solving the problem.
Bill, a CFO contributor and the host of MrExcel.com, is the author of 33 books on Microsoft Excel, and Editor-at-Large of the Excel edition of
CFO Learning Pro newsletter.
He has made more than 60 guest appearances on TV's Call for Help with Leo Laporte and was voted guest of the year on the Computer America radio show. He has produced more than 1100 episodes of his daily video podcast, Learn Excel from MrExcel.