Redline Advanced Excel Training

redline_gauge_597x640.jpg
Loan Calculator Sample.png
SEARCH_screenshot.png
SCENARIO_screenshot.png
ANDMORE_screenshot.png
redline_gauge_597x640.jpg
Loan Calculator Sample.png
SEARCH_screenshot.png
SCENARIO_screenshot.png
ANDMORE_screenshot.png
sale

Redline Advanced Excel Training

59.90 149.99

Redline Advanced Excel Training is a 44-tab file that guides you through 13 real consulting problems we have seen in our work. It teaches the following functions and how to string them together to model better, faster:

  • INDEX
  • MATCH
  • Conditional formatting
  • VLOOKUP
  • SUMPRODUCT
  • Scenario design
  • Using 1's and 0's to keep models flexible
  • OFFSET
  • SUMIF
  • COUNTIF
  • SUMIFS
  • IFERROR
  • RANK
  • Pivot Tables
  • CONCATENATE, also known as '&'
  • SEARCH
  • AND
  • ROUND
  • Data tables for sensitivity analysis
  • MID
  • CELL
  • LEFT
  • RIGHT
  • Text to columns
  • ADDRESS
  • ROW
  • COLUMN
  • INDIRECT

The file will be emailed to you upon completing the purchase.

Please contact us for multiple-license discounts if you're planning to use this for your full team, reduced prices start with as few as 3 copies.

Add To Cart