Excel: Advanced Formulas and Functions

4.6 /5

(10 Ratings)

Offered byLinkedin Learning

Excel: Advanced Formulas and Functions
at
Linkedin Learning
Overview

Learn everything you need to know about Excel and give a boost to your professional career

Duration	5 hours
Total fee	₹1,400
Mode of learning	Online
Credential	Certificate

Excel: Advanced Formulas and Functions
at
Linkedin Learning
Highlights

Earn a certificate of completion from LinkedIn Learning

Excel: Advanced Formulas and Functions
at
Linkedin Learning
Course details

Skills you will learn

Excel Vlookup Statistics Advanced Excel

More about this course

Follow along with Excel MVP Oz du Soleil as he demystifies the many kinds of formulas and functions available in Excel
Oz starts with a few critical keyboard shortcuts that will speed up your work, and offers grounding in how to develop your own style working with formulas and functions
Next, Oz covers a variety of formulas such as the XLOOKUP/VLOOKUP and INDEX functions, counting and statistical functions, text functions, and date/time, array, math, and information functions
Oz provides practical examples to help viewers easily transition to using Excel's most powerful formulas and functions in real-world scenarios
The course concludes with a series of challenges so you can test your knowledge

Excel: Advanced Formulas and Functions
at
Linkedin Learning
Curriculum

Introduction

Learning advanced formulas and functions using Excel

Developing your own style with formulas and functions

Challenges

Using Tables and Dynamic Arrays for Data Integrity and Consistency

Tables

Tables and absolute cell references

Dynamic arrays introduction

The World of IF Statements and Conditions

IF function

SUMIFS and COUNTIFS

MAXIFS, MINIFS, and AVERAGEIFS

Looking Up, Down, and All Around: Comparing and Combining with Lookups

VLOOKUP

XLOOKUP

VLOOKUP and XLOOKUP comparison

INDEX/MATCH

The INDEX/MATCH vs. VLOOKUP controversy

Two-way lookups

Approximate and tiered matches

INDIRECT

Formula Tips and Strategies

Use Alt+Enter to make formulas more readable

Formula vs. lookup table

Formula vs. helper columns

Build complex formulas in steps

Writing formulas for "future you"

Compatibility functions

Writing 3D formulas

Volatile functions

LET function overview

Error handling: IFNA and IFERROR

Mid-Term Challenges

Challenge 1: Course completions

Challenge 2: Two-way lookup

Challenge 3: Guitars

Date and Time Functions

Time, rounding, and converting to decimals

EOMONTH

YEARFRAC

Working with Text and Arrays

LEFT, RIGHT, and MID

UPPER, LOWER, and PROPER

TEXTJOIN

FILTER

UNIQUE

TOCOL

TEXTBEFORE and TEXTAFTER

RANDARRY

Excel: Advanced Formulas and Functions
at
Linkedin Learning
Faculty details

Oz du Soleil

He have been working with data and Excel for many years, and have developed a passion for clean data and reliable reporting.

Excel: Advanced Formulas and Functions
at
Linkedin Learning
Students Ratings & Reviews

4.6/5

10 Ratings

4-5
6
3-4
4

JINTU MANCHEY

Excel: Advanced Formulas and Functions

Offered by Linkedin Learning

Learning Experience: It was online session and all classes are recorded. So we revised or forward the video if needed.

Faculty: It was online session and all classes are recorded. So we revised or forward the video if needed. It was online session and all classes are recorded. So we revised or forward the video if needed.

Reviewed on 18 Feb 2023Read More

Sumit Kumar Raut

Excel: Advanced Formulas and Functions

Offered by Linkedin Learning

Learning Experience: The course was varied. It had many useful insights on how to use formula at the right place to shorten workings, and quick methods to solve complex tasks.

Faculty: Excellent. The structure was very well made with intermediate quizes.

Course Support: It was an amazing experience

Reviewed on 27 Jan 2023Read More

View All 2 Reviews