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

Excel

Advanced Excel

Advanced Excel Formulas

Pivot Table and Slicers

Advanced Conditional formatting

VBA

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!

-Kadhir (Founder, YourExcelGuy)

English
language

Content

Introduction

About me
Ribbons and Environment
Referencing
Difference Between Range and Tables

Basic Features

Sorting
Filtering Data
Merge and Centre
Data Validation
Text Wrap

Advanced Features

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 Image Powered by Code Help Pro

Ads Blocker Detected!!!

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

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock