Course wrap-up

Data Validation in Excel

Ramiz Assaf

Academic and Professional Trainer

Chapter 1

• What Data alidation is and why it's vital for error free spreadsheets.
• Excel's Data Validation tools

Chapter 2

• Built a car loan calculator
  • Custom formulas, APRs, VIN...
• Created user-friendly error messages to guide input.
• Structured tool

 

Future courses in Excel

 

• Financial Modeling in Excel

 

• Introduction to Power Query in Excel

Congratulations!

Data Validation in Excel