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
Auf dieser Seite können Sie das Online-Video Complete MS Excel Tutorial for Beginners mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Data Analysis Tech 01 Januar 1970 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 200 Mal angesehen und es wurde von 27 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
