Complete MS Excel Tutorial for Beginners
1) DATE Functions:
2) WORKDAY
3) WORKDAY.INTL
4) NETWORKDAYS
5) NETWORKDAYS.INTL
6) Datedif (year , Month , Day)
---------------------------------------------------------------------
VLOOKUP:
The VLOOKUP function is used to search for a value in the first column of a table and return a value in the same row from a specified column. Here's the basic syntax:
HLOOKUP:
The HLOOKUP function is similar, but it searches for the lookup value in the first row of the table and returns a value in the same column from a specified row. Here's the basic syntax:
----------------------------------------------------------------------------
Welcome to our Excel tutorial on mastering some of the most essential functions for data analysis and calculation in Microsoft Excel. In this video, we will cover the
SUM, SUMIF, SUMIFS, COUNT, COUNTIF, and COUNTIFS functions step by step.
----------------------------------------------------------------------
Addition:
To add two or more numbers in Excel, you can use the + operator. Here's an example:
=A1 + B1
This formula adds the values in cell A1 and B1.
Subtraction:
To subtract one number from another, use the - operator. For example:
=A1 - B1
This formula subtracts the value in cell B1 from the value in cell A1.
Multiplication:
For multiplication, use the * operator. Here's an example:
=A1 * B1
This formula multiplies the values in cells A1 and B1.
Division:
To divide one number by another, use the / operator. For example:
=A1 / B1
This formula divides the value in cell A1 by the value in cell B1.
Exponentiation (Power):
To raise a number to a power in Excel, you can use the ^ operator. For example, to calculate 2 raised to the power of 3:
=2^3
-----------------------------------------------------------------------------------
ONE CARD CREDIT : https://1cardapp.page.link/rAiY
----------------------------------------------------------------
FACEBOOK : https://www.facebook.com/profile.php?...
INSTAGRAM : / keshwarraja143
TELEGRAM : https://t.me/eshwarrajaDataAnalysis143
LINKEDIN : / kuncharapu-eshwar-14a601224
--------------------------------------------------------------------------
EMAIL ID : analysisdata80@gmail.com
---------------------------------------------------------------------------
#excel #tutorial #for #beginners,#excel# tutorial,#excel #for #beginners,#microsoft #excel #tutorial,#microsoft #excel #tutorial #for #beginners,#microsoft #excel,#learn #excel,#excel,#basic #excel #tutorial,#excel #tutorial #free,#how #to #use #excel,#excel #365 #tutorial #for #beginners#,microsoft #excel #for #beginners,#excel #tutorial #for #beginners #in #hindi,#excel #basics #for #beginners,#complete #microsoft #excel #tutorial,#excel #for #dummies,#complete #ms #excel #tutorial #for #beginners