• Post category:StudyBullet-13
  • Reading time:5 mins read


VLOOKUP, IF, SUM, AVERAGE, COUNT, MIN, MAX, CONCAT, LEN, REPLACE

What you will learn

VLOOKUP, IF, SUM, AVERAGE, COUNT, MIN, MAX, CONCAT, LEN, & REPLACE

Learn Foundational Excel Formulas Fast!

Provides stepping stones for more advanced excel work!

Learn by real examples!

Description

Requirements

· No Prior Excel Knowledge Required

· Microsoft Excel 2007, 2010, 2013, 2013, 2019 or Microsoft 365 Excel Loaded on Computer to Follow Along with Instructor Lectures is Recommended

Description

Microsoft Excel: Formulas for Beginners

This Microsoft Excel course will teach you the foundational excel formulas in record time! Below are the formulas that you will learn:

· VLOOKUP

· IF

· SUM

· AVERAGE

· COUNT


Get Instant Notification of New Courses on our Telegram channel.


· MIN

· MAX

· CONCAT (Replaced CONCATENATE in 2016)

· LEN

· REPLACE

Topics covered in this course apply to Excel 2007, 2010, 2013, 2016, 2019 (Microsoft/Office 365)

Whether you have been struggling with a specific formula or you have just started your excel journey, this course will walk you through the basic excel formulas in an easily to understand and approachable format. I’ve designed this course to be as short as possible to cut the fluff and to allow you to ingest the information quickly and effectively. My goal is to have you fluent in these formulas and use this as a booster to your excel learning expedition.

Who this course is for:

· This Microsoft Excel courses will take you through all of the most common formulas that you need to be successful in excel.

· This course is designed for the beginner, but the intermediate user will still benefit from the content.

Content

Introduction

Introduction

Foundational Formulas

SUM()
AVERAGE()
COUNT()
MIN() & MAX()
CONCAT(), LEN(), & REPLACE()

The Vlookup()

Vlookup(): Example 1
Vlookup(): Example 2
Vlookup(): Example 3

The IF() Statement

IF() Statement: Example 1
IF() Statement: Example 2
IF() Statement: Example 3
IF() Statement: Example 4
English
language

Content

Introduction

Introduction

Foundational Formulas

SUM()
AVERAGE()
COUNT()
MIN() & MAX()
CONCAT(), LEN(), & REPLACE()

The Vlookup()

Vlookup(): Example 1
Vlookup(): Example 2
Vlookup(): Example 3

The IF() Statement

IF() Statement: Example 1
IF() Statement: Example 2
IF() Statement: Example 3
IF() Statement: Example 4