# Excel basics and Excel formulas for Beginners in 2023

You can quickly go from a newbie to an advanced excel user in no time

What you will learn

### Vlookup & XLookup

Description

Updated for 2021

You would get to learn the basic concepts that run excel and become efficient at it. This is the most updated course on Excel with the Most recent formulas and Features that matter the most.

You can be the excel guru at your workplace and master most of the unknown or poorly used shortcuts. Yet very powerful in their own terms.

This course will give you a deep understanding of the advanced Excel formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. While most Excel courses focus on simply what each formula does, I teach through animated designs and videos for you to understand the concepts better.

Weâ€™ll deep dive into a broad range of Excel formulas & functions, including:

• Lookup/Reference functions
• Statistical functions
• Formula-based formatting
• Date & Time functions
• Logical operators

What gives you the right to teach this class? Canâ€™t I just Google this stuff?

I have a genuine passion for Excel that most people reserve for things like kittens, ice cream, and significant others. The only thing I love more than learning Excel is teaching it, and as the founder of YourExcelGuy and have helped 10000+ students across 10+ countries.

Thanks!

English
language

Content

### Introduction

Ribbons and Environment
Referencing
Difference Between Range and Tables

Sorting
Filtering Data
Merge and Centre
Data Validation
Text Wrap

Text to Columns
Flash Fill
Paste Special
Pivot Tables

### Operators in Excel

OR Formula or Operator
AND Formula or Operator
IF Formula

### Aggregation Formulas

Sum formula
SumIF formula
Average Formula
AverageIF Formula
Count Formula
CountA Formula
Round Formula

### Text Formulas

Len Formula
Left Formula
Right Formula
Lower Formula
Upper Formula
Proper Formula
Formula Knowledge Checker

### Date Formulas

Now Formula
Today

Check Today's 30+ Free Courses on Telegram!

X

#### Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.