Description

CFI’s Excel Book is free and available for anyone to download as a pdf. Learn about the most important Excel shortcuts and functions to succeed in your career!

 

CFI’s Excel Book- Excel Shortcuts for PC and Mac (Chapter 1)

• Editing Shortcuts
• Formatting Shortcuts
• Navigation Shortcuts
• File Shortcuts
• Ribbon Shortcuts
• Paste Special Shortcuts
• Clear Shortcuts
• Selection Shortcuts
• Data Editing Shortcuts
• Data editing (inside a cell) Shortcuts
• Other Shortcuts
• Reasons to use Excel Shortcuts
• Free Excel Course

 

Basic Excel Formulas (Chapter 2)

• Basic Terms in Excel
• Five Time-saving Ways to Insert Data in Excel
• Seven Basic Excel Formulas For Your Workflow

 

CFI’s Excel Book – Advanced Excel Formulas (Chapter 3)

• INDEX MATCH
• IF combined with AND / OR
• OFFSET combined with SUM or AVERAGE
• CHOOSE 92 XNPV and XIRR
• SUMIF and COUNTIF
• PMT and IPMT
• LEN and TRIM
• CONCATENATE
• CELL, LEFT, MID, and RIGHT functions

 

Most Useful Excel functions For Financial Modeling (Chapter 4)

• Date and Time
  • DATE
  • EOMONTH
  • TODAY
  • YEAR
  • YEARFRAC
• Financial
  • DURATION
  • NPV
  • PMT
  • PPMT
  • XIRR
  • XNPV
  • YIELD
• Information
  • TYPE
  • ISBLANK
• Logical
  • AND
  • IF
  • IFERROR
  • IFS
  • OR
  • CHOOSE
  • HLOOKUP
  • INDEX
  • MATCH
  • OFFSET
  • VLOOKUP
• Math
  • ABS
  • SUMIF
• Statistical
  • AVERAGE
  • CORREL
  • COUNT
  • COUNTA
  • COUNTIF
  • RANK
  • SMALL