Essential Formulas and Functions in Excel
Course

Essential Formulas and Functions in Excel

Simon Sez IT
Updated Jan 31, 2020

Course Overview

In this short Excel course, we take you through some essential formulas and functions you need to get started in Excel. 

This course is perfect if you’re new to Excel and want a crash course in how formulas and functions work and how to use them to help you do the heavy lifting.

Target Audience

Administrators, Graduates, people in Financial Services, Accountancy.

Learning Objectives/Outcomes 

In this course you will learn:

  • How formulas work
  • How to use functions – the basic rules
  • All about Absolute and Relative values
  • About three dimensional formulas
  • About logical formulas such as IF
  • How to use VLOOKUP and HLOOKUP
  • How to audit your formulas
  • All about text functions