Excel Tutorial

Excel Tutorial Shortcut Keys in Excel Formatting in Excel Notes in Excel Formats in Excel Cells and Ranges in Excel Excel Function and Formulas Conditional Formatting in Excel Data Validation in Excel Charts in Excel Excel Ribbon Toolbar Basics of Excel Spell Check in Excel Data Analysis in Excel AutoFill in Excel Goal Seek in Excel Solver in Excel Pivots Table in Excel Go-To Special function in Excel Blank cells in Excel Count Cells with Text in Excel Date and Time in Excel-VBA Dependent Drop-down List in Excel Operators in Excel Dependent Combo box in Excel VBA Error Bar in Microsoft Excel Excel Axes Excel File using Password Excel Unique Values Frequency Distribution in Excel Gauge Chart in Excel Histogram in Excel Sum Every Nth Row in Microsoft Excel SumIF Formula in Microsoft Excel Multiplication in Excel Unique Values in Excel Trendline in Excel Excel Themes Copying formula in Excel Check Marks in Excel Calculating the Last Day of the Month in Excel Calculating Age in Excel Insert Row in Excel

Functions

Excel MAX() Function Excel INT() Function Excel MOD() Function Excel ROUND() Function Excel ROUNDUP() Function Excel AVERAGE() Function Excel COUNT() Function Excel COUNTA() Function Excel COUNTBLANK() Function Excel MIN() Function Excel EDATE() Function Excel EOMONTH() Function Excel HOUR() Function Excel MINUTE() Function Excel SECOND() Function Excel TIME() Function Excel WORKDAY() Function Excel WORKDAY.INTL() Function Excel DAYS() Function Excel WEEKNUM() Function Excel WEEKDAY() Function Excel SMALL() Function Excel LARGE() Function Excel LEFT() Function Excel RIGHT() Function Excel MID() Function Excel FIND() Function Excel SEARCH() Function Excel EXACT() Function Excel SUBSTITUTE() Function Excel TEXT() Function Excel VALUE() Function Excel AND() Function Excel OR() Function Excel IFERROR() Function Excel IF() Function Excel Nested IF’s Function Excel IFNA() Function Excel COUNTIFS() Function Excel VLOOKUP() Function Excel HLOOKUP() Function Excel INDEX() Function Excel MATCH() Function Excel OFFSET () Function Averageif Function in Excel

How To

How to import Microsoft Access data into the Microsoft Excel How to use TODAY function in Excel How to Alphabetize in Excel How to remove duplicate values from excel How to lock cells in Excel How to create drop down in excel How to Delete Row in Microsoft Excel How to Highlight Duplicates Words in the Microsoft Excel How to print titles in Excel How to make use of the Wildcard in Excel How to Make Use of the F-Test in Excel How to make use of the Excel Autofit in Excel How to generate random numbers in Excel How to apply Advanced Filter in Excel How to use Index and Match in Excel

Misc

Absolute Value in Excel Adding Column in Excel Converting Units in Excel Count Characters in Excel Custom Sort Order in Excel Decimals in Excel Division in Excel Locate Maximum Values in Excel Nearest Multiple in Excel Paste Options in Excel Quarter Dates in Excel Row Difference in Excel Separate Strings in Excel Reverse List in Excel Array Formula in Excel What if Analysis Data Table in Excel Excel Shortcut Keys What is a spreadsheet in Excel?

Excel Function and Formulas
2019-11-12 10:50:40

Excel Function and Formulas

Excel Today() Function

The today() function returns the serial number of today’s date as per system number of today’s date as per system’s regional settings.

Syntax

Today()

Parameter

NA

Category

Date & Time

Returns

This function returns today's date in date format.

Example 1

Objective: To get the current date

Result Formula
11/6/2019   =Today()

Example 2

Objective: Add 5 days to the current date and return the future date in a cell

Result Formula
11/11/2019   =Today()+5

Example 3

Objective: Calculate number of days between today's date and date in Col A

Result Formula Result
12/31/2015   =Today()-12/31/2015   1406
1/3/2010   =Today()- 1/3/2010   3594  
12/11/2015   =Today() - 12/11/2015   1426

Excel Now() Function

The now() function in Excel Returns the serial number of current date and time as per the system's regional settings.

Syntax

Now()

Category

Date & Time

Parameter

NA

Return

This function returns current date and time in excel date and time format

Example 1

Objective: Get the current date and time stamp in cell

Result Formula
11/6/2019 21:52   =Now ()

Example 2

Objective: To return the current time only in cell

Result Formula
21:52   =Now ()- Today()

Example 3

Objective: To calculate the Date and Time 7 days ago

Result Formula
10/30/2019 22:02   =Now ()- 7

Excel Upper Function

The Upper() function in excel  converts the text to uppercase.

Syntax

Upper(text)

Parameter

text(required)- This parameter represents the string for which you want to convert all letters into UPCASE

Category

Text

Return

This function returns the entire text string after converted into uppercase letters

Example 1

Objective: Change the ‘Name’ column in Uppercase

Name Formula Result
Varun SYEda   =Upper(Varun SYEda)   VARUN SYEDA
RAYAEL Pereyra   =Upper(RAYAEL Pereyra)   RAYAEL PEREYA
ThOMAs AlWachELL   =Upper(ThOMAs AlWachELL)   THOMAS ALWACHELL
ASHISH KUMAR PaTRA   =Upper(ASHISH KUMAR PaTRA)   ASHISH KUMAR PATRA
DELIA AZAHARI   =Upper(DELIA AZAHARI)   DELIA AZAHARI
mAR martin cASTellano   =Upper(mAR martin cASTellano)   MAR MARTIN CASTELLANO
DanIEL OSO   =Upper(DanIEL OSO)   DANIEL OSO
AmAN BHArDWAJ   =Upper(AmAN BHArDWAJ)   AMAN BHARDWAJ
KRiya BhansALI   =Upper(KRiya BhansALI)   KRIYA BHANSALI

Example 2

Objective: To convert the values in Text column into UPPERCASE
Text Result Formula
Laptop LAPTOP  =UPPER(A15)
Excel EXCEL  =UPPER(A16)
superstore is closed now SUPERSTORE IS CLOSED NOW  =UPPER(A17)

Excel Lower Function

The Lower() function in excel  converts the text to lowercase.

Syntax

Lower (text)

Parameter

text(required)- This parameter represents the string for which you want to convert all letters into LOWERCASE

Category

Text

Return

This function returns the entire text string after converted into lowercase letters

Example 1

Objective: Change the ‘Name’ column in Lowercase

Name Formula Result
Varun SYEda   =Lower(Varun SYEda)   varun syeda
RAYAEL Pereyra   = Lower (RAYAEL Pereyra)   rayael Pereyra
ThOMAs AlWachELL   = Lower (ThOMAs AlWachELL)   thomas alwachell
ASHISH KUMAR PaTRA   = Lower (ASHISH KUMAR PaTRA)   ashish kumar patra
DELIA AZAHARI   = Lower (DELIA AZAHARI)   delia azahari
mAR martin cASTellano   = Lower (mAR martin cASTellano)   mar martin castellano
DanIEL OSO   = Lower (DanIEL OSO)   daniel oso
AmAN BHArDWAJ   = Lower (AmAN BHArDWAJ)   aman bhardwaj
KRiya BhansALI   = Lower (KRiya BhansALI)   kriya bhansali

Example 2

Objective: To convert the values in Text column into LOWERCASE
Text Result Formula
Laptop laptop  =LOWER (A15)
Excel excel  =LOWER(A16)
superstore is closed now superstore is closed now  =LOWER(A17)

Excel Proper Function

The Proper () function in excel capitalizes the first letter in each word of a text value.

Syntax

Proper (text)

Parameter

text(required)- This parameter represents the string for which you want to convert all letters into PROPERCASE

Category

Text

Return

This function returns the entire text string after converted into propercase letters

Example 1

Objective: Change the ‘Name’ column in Propercase

Name Formula Result
Varun SYEda   =Proper(Varun SYEda)   Varun Syeda
RAYAEL Pereyra   = Proper(RAYAEL Pereyra)   Rayael Pereyra
ThOMAs AlWachELL   = Proper(ThOMAs AlWachELL)   Thomas Alwachell
ASHISH KUMAR PaTRA   = Proper(ASHISH KUMAR PaTRA)   Ashish Kumar Patra
DELIA AZAHARI   = Proper(DELIA AZAHARI)   Delia Azahari
mAR martin cASTellano   = Proper(mAR martin cASTellano)   Mar Martin Castellano
DanIEL OSO   = Proper(DanIEL OSO)   Daniel Oso
AmAN BHArDWAJ   = Proper(AmAN BHArDWAJ)   Aman Bhardwaj
KRiya BhansALI   = Proper(KRiya BhansALI)   Kriya Bhansali

Example 2

Objective: To convert the values in Text column into UPPERCASE
Text Result Formula
Laptop Laptop  = Proper (A15)
Excel Excel  = Proper (A16)
superstore is closed now Superstore Is Closed Now  = Proper (A17)