# Excel Tip

• ### How to do a Vlookup Function in Excel - Duration: 15 minutes.

• 2 years ago
• 2,191 views
This week’s tutorial demonstrates how to use VLOOKUP Function in excel with all its syntaxes. VLOOKUP stands for Vertical lookup, so naturally it performs a vertical search for a particular value i...
• ### How to Create an Invoice Template in Excel! - Duration: 24 minutes.

• 2 years ago
• 773,352 views
In this session, we’ve explained in easy STEP by STEP details about how to create an Invoice Template by just using some basic sum function and lookup feature without VBA in just few minutes. After...
• ### How to use TIME function in Excel with Live Examples - Duration: 8 minutes, 24 seconds.

• 2 years ago
• 2,959 views
This tutorial demonstrates the usage of TIME function and its syntax in Excel with LIVE examples.

The Microsoft Excel TIME function returns the decimal value that represents the time in Excel. The...
• ### How to use DATE function in Excel - Duration: 11 minutes.

• 2 years ago
• 1,486 views
This tutorial demonstrates the usage of DATE function and its syntax in Excel with LIVE examples.

The Microsoft Excel DATE function in Excel returns the serial number of a date that represents a ...
• ### How to use DAY function in Excel - Duration: 3 minutes, 59 seconds.

• 2 years ago
• 6,175 views
This video demonstrates the uses of DAY function with LIVE Examples.

Day function returns an integer representing the day of the month from 1 to 31 of a date supplied in the argument. It takes "se...
• ### IF Function Formulas: 10 Examples! - Duration: 16 minutes.

• 2 years ago
• 3,671 views
This video tutorial demonstrates IF function formula and what it can do with the uses of 10 examples. Microsoft Excel IF function is one of the most popular and useful function. It allows to evalua...
• ### COUNTIF Function with 12 Different Examples & Criteria - Duration: 15 minutes.

• 2 years ago
• 7,125 views
This tutorial demonstrate the uses of COUNTIF function with the different methods with the help of 12 different examples. Learn methods for counting specific numbers, greater than and less than, no...
• ### SUMIF Function With 7 Examples in Excel - Duration: 11 minutes.

• 2 years ago
• 1,199 views
This video demonstrates "How to use SUMIF for different purpose at work?". You can use this function to add things together based on the supplied criteria. If you have such data where you need the ...
• ### How to use TODAY function in Excel - Duration: 4 minutes, 18 seconds.

• 3 years ago
• 3,588 views
Excel TODAY function returns the serial number of the current date. It automatically refresh the date whenever the worksheet recalculates. TODAY function is one of easy yet powerful function in MS-...
• ### How to use NOW function in Excel - Duration: 4 minutes, 23 seconds.

• 2 years ago
• 5,817 views
This video tutorial shows "How to use NOW function in Excel" using simple methods.

As we know, there are many "Date and Time" functions in Excel, and NOW function is one of the most commonly used...
• ### How to use HOUR function in Excel - Duration: 7 minutes, 36 seconds.

• 2 years ago
• 4,136 views
This tutorial shows “How to use HOUR function in Excel” with 10 examples.

HOUR function is used to return the hour of a time value between 0 and 23. It returns the #VALUE! error when any invalid ...
• ### How to use SECOND function in Excel - Duration: 7 minutes, 41 seconds.

• 2 years ago
• 730 views
This tutorial shows “How to use SECOND function in Excel” with different time formats with 9 examples.

Microsoft Excel SECOND function returns the seconds of a time value. It returns a number from...
• ### How to use Minute function in Excel - Duration: 6 minutes, 53 seconds.

• 2 years ago
• 1,457 views
This video shows “How to use MINUTE function in Excel” with different time formats with 9 examples.

MINUTE function in Excel is used to extract the MINUTE as an integer value from a specified time...

• 6:53

• 7:41

• ### Remove Extra, Leading & Trailing Spaces using TRIM function in Excel - Duration: 7 minutes, 47 seconds.

• 2 years ago
• 1,005 views
Watch this video that shows "How to use TRIM function to remove extra, leading & trailing spaces, line breaks" with the help of 3 easiest examples.

TRIM is Excel's one of very useful function whi...
• ### How to use OFFSET function for Dynamic Range in Excel - Duration: 7 minutes, 50 seconds.

• 2 years ago
• 19,821 views
This video tutorial shows "How to use OFFSET function to get dynamic range in Excel" with the help of examples.

The Microsoft Excel OFFSET function returns a reference or specific range of cells ...
• ### Extract First, Middle and Last Name from One Cell Into Separate Cells In Excel - Duration: 26 minutes.

• 2 years ago
• 40,446 views
This video shows "How to extract First, Middle and Last Name from One Cell into Separate Cells in Excel using multiple ways".

This is one of the very common situation which almost every user must ...
• ### Prevent Duplicate Entries in a Range with Excel Data Validation - Duration: 5 minutes, 2 seconds.

• 2 years ago
• 2,085 views
This video shows "How to prevent users from entering duplicate values in a column with Data Validation in Excel with easy steps"

It is one of the best trick to implement it on your data if you do...
• ### How to Create Dependent (Cascading) Drop Down List in Excel Using 5 Different Techniques - Duration: 32 minutes.

• 2 years ago
• 64,591 views
This video shows “How to create a Dynamic Depending Drop Down list using 5 different methods in Excel with Data Validation with different data format. Dynamic Data Validation Dependent Drop Down Li...
• ### How to Create Dynamic Drop Down List in Excel Using 4 Different Methods - Duration: 15 minutes.

• 2 years ago
• 16,561 views
This video talks about "How to create a dynamic drop down list in Excel" which gets automatically updated when any new values added to the source data. There are plenty of ways doing this in Excel ...
• ### How to create Drop Down list with Data Validation in Excel - Duration: 6 minutes, 39 seconds.

• 2 years ago
• 1,853 views
This tutorial will show you how to use the data validation feature to create a drop down list of products in Microsoft Excel with multiple methods.

Data Validation not only improves the efficienc...

• 15:57

• 6:39

• ### How to use AVERAGE function in Excel - Duration: 7 minutes, 2 seconds.

• 2 years ago
• 693 views
Microsoft Excel AVERAGE function is one of the “Statistical” and most commonly used function in Excel. It is the arithmetic mean of the arguments. AVERAGE formula is calculated by adding the sum of...
• ### How to use UPPER function in Excel - Duration: 3 minutes, 18 seconds.

• 2 years ago
• 1,161 views
UPPER function is used to converts all letters to uppercase in a text-string.
• ### How to use PROPER function in Excel - Duration: 5 minutes, 1 second.

• 3 years ago
• 2,066 views
PROPER function is used to capitalize the first letter of every word in a given string. All letters that do not follow any other letter are set to uppercase and rest to lowercase.

Visit us for ...
• ### How to use LOWER function in Excel - Duration: 3 minutes, 17 seconds.

• 3 years ago
• 862 views
In Excel, LOWER function is used to converts all letters from uppercase (capital letters) to lowercase in a text string.

Visit us for daily dose of Excel Tips & Tricks at http://www.exceltip.com/...
• ### Advance Vlookup in Microsoft Excel - Duration: 6 minutes, 49 seconds.

• 3 years ago
• 11,386 views
Learn the uses of Vlookup function in advanced way. This tutorial shows "How to pickup the value depending on two lookup value criteria using Vlookup function".

how to pick the values depending on...
• CC
• ### How to insert a line break in the same cell in Excel - Duration: 4 minutes, 29 seconds.

• 3 years ago
• 66,512 views
This video tutorial will help you to insert a line break in same cell in Excel. We have added different situations for the better use of this function in Excel.

Visit us for daily dose of Excel...
• ### How to use the FIND function in Excel - Duration: 4 minutes, 47 seconds.

• 3 years ago
• 6,013 views
The FIND function in Microsoft Excel returns the position of a specified character or sub-string within a string or text. The function is case-sensitive.

Visit us for daily dose of Excel Tips & T...
• ### How to use COUNTBLANK function in Excel - Duration: 89 seconds.

• 3 years ago
• 380 views
COUNTABLANK function is used to counts and returns the number of empty or blank cells in a range.

Visit us for daily dose of Excel Tips & Tricks at http://www.exceltip.com/

In case of any simpl...
• ### How to use COUNTA function in Excel - Duration: 2 minutes, 59 seconds.

• 3 years ago
• 1,348 views
This video tutorial shows "How to use COUNTA function". The Excel COUNTA function returns the count of non-blank cells and the number of arguments that contain values in a range.

Visit us for d...
• ### How to use COUNT function in Excel - Duration: 4 minutes, 12 seconds.

• 3 years ago
• 530 views
The COUNT function returns the number of cells that contain numerical values including numbers and dates from a set of data. You can either supply values directly to the function or as a cell refer...
• ### How to use SUM function in Excel - Duration: 4 minutes, 40 seconds.

• 3 years ago
• 267 views
This video tutorial shows "How to use the SUM function in Excel". SUM function is one of the most commonly used “Mathematical” function in Excel. It adds all the numbers in a range of cells and ret...
to add this to Watch Later