FINANCIAL MODELING COURSES & TRAINING CFI's financial modeling courses and financial analyst certification programs are delivered by instructors with years of experience training industry-leading global companies. Our ABOUT CFI | CORPORATE FINANCE INSTITUTE® Corporate Finance Institute® (CFI) is a leading global provider of online financial modeling and valuation courses. Since 2016, CFI’s programs and certifications have been delivered to over 800,000 individuals at top universities, investment banks, accounting firms, and operating companies around the world. FMVA ® - FINANCIAL MODELING AND VALUATION ANALYST FMVA™ is the Financial Modeling & Valuation Analyst program to become a certified financial analyst. CFI's FMVA program has 12 required courses on topics including accounting, Excel, finance, financial modeling, valuation, presentations, and other critical skills that financial analysts need. EXCEL TEST - 20 QUESTIONS TO TEST YOUR EXCEL KNOWLEDGE! Take CFI’s Excel Test. This Excel Test is designed to help you assess your knowledge of basic Excel functions and formulas. We strongly encourage any students who are planning or are beginning their FMVA certification program Become a Certified Financial Modeling & Valuation Analyst (FMVA)® to take this test to determine whether you will need to take the prerequisite Excel Crash Course and IF STATEMENT BETWEEN TWO NUMBERS Example of how to use the formula: Step 1: Put the number you want to test in cell C6 (150). Step 2: Put the criteria in cells C8 and C9 (100 and 999). Step 3: Put the results if true or false in cells C11 and C12 (100 and 0). Step 4: Type the formula =IF (AND (C6>=C8,C6=C8,C6=C8,C6=C8,C6=C8,C6