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

Related learning

Microsoft Excel 2016 for Mac: Basic FormulasCourse ⋅ 56 mins

Microsoft® Excel® 2013 Using Basic Formulas Part 1Interactive ⋅ 15 mins

Introduction to Microsoft ExcelCourse ⋅ 300 mins

Microsoft Excel 2016 Essentials: Formulas and FunctionsCourse ⋅ 68 mins

Explore more technology skills

IT Software

Web Design and Development

Data & Analytics

Design and Animation

Gaming and Games Development

Devops, Networking and Security

Programming and Web Development

Computer Science and Engineering

Simon Sez ITGLOBAL

Self-paced, affordable software training is what Simon Sez IT is all about. They teach people to use the most popular business software including Microsoft Office, Microsoft Project, Photoshop, Web Design and QuickBooks®️. Their approach to teaching comes from their passion to fully explain how something works. They don’t skirt around the edges. With 50+ courses and over 1000 learning resources now available in Go1 globally, Simon Sez IT makes business and technical software simple to learn. From Excel to photo editing, their step-by-step tutorials will kickstart your software skills and help you learn IT. Simon Sez IT is based in the US, however all of their content is globally relevant.