Everything Excel - The Excel Experts


  • Meet the Team
  • Testimonials
  • FREE EXCEL TRAINING

Functions and Formulas



A formula will perform calculations for you. This makes Excel more than just a grid with numbers. Use it as a tool with these guides.



Essential excel functions



This includes a guide on what a formula is and how to execute the most essential functions in Excel.



The if function



We break down the logic of an IF statement, show its powerful application in Excel and even dig into nested IFs.



VLOOKUP



One of the most desired function by employers. If you understand it's power, nothing is stopping you.



INDEX/MATCH



This deadly combo of formulas lets you get data like your playing a calculated game of battle ship! Super useful...