"Day 6: Excel Essentials Unveiled - Sharing Today's Insights on My Learning Adventure! 📊🚀 #ExcelSkills #LearningJourney"

EXCEL - 5

COMMON FUNCTIONS USED ARE : -

Mostly in both Google sheets and Excel Functions are the same.

Before we get into function lets learn about cell reference

Cell reference

Relative reference
Absolute reference ( do not change as we use it again “$”, press F4 to add $ sign )
Mixed reference

Relative to Absolute, just add $ with F4 buttons.

Mathematical functions

Sum, Sumif, Sumifs
Round, Roundup , RoundDown
Subtotal
Sumproduct
Sequence
Randarray
Aggregate
Even
Odd

Suffix if - it takes only one condition.
Suffix ifs - It takes multiple conditions.

STATISTICAL FUNCTIONS

Function :-
Count, countif, countifs ( only for numerical )
Countblank ( count number of blank )
Counta ( alphanumeric )
Average, Averageif, Averageifs.
Max , Min, Maxifs, Minifs

Logical operators :-

<

<=
<> is taken as =

If we want to know how value is intaken in a formula ,
Select the formula and press F9 key it will show all the values selected from the cell.

Double negatives ( - - ) turn true False into a value.

LEARNING IS AN EVERYDAY PROCESS SO, i will be updating previous learning with new tips and tricks.

Follow me on this where every day will be added if i learn something new about it :- https://dev.to/nitinbhatt46

Thank you for your time.