Excel Tips
Excel Tips
  • Видео 31
  • Просмотров 1 679
How to separate Pincode from Address
Multiple functions are used to separate the Pincode(Post code) from the address, which is very useful in a data analytics profile.
Просмотров: 4

Видео

Use of MID,MAX And LEN function
Просмотров 1417 часов назад
The LEN function returns the number of characters in a text string The MID function extracts a substring from a larger text string, starting from a specified position and for a specified number of characters. The MAX function returns the largest number in a range of number
Use of Exact function in Excel
Просмотров 820 часов назад
The EXACT function in Excel compares two text strings and returns a logical value.
Pull out a Value using VLOOKUP function.
Просмотров 322 часа назад
The VLOOKUP formula is used to search for related information in a table by row or column
Pivot table
Просмотров 3222 часа назад
A PivotTable in Excel is a tool that summarizes, analyzes, and presents data in a spreadsheet.
Use of AVERAGEIFS function.
Просмотров 7День назад
AVERAGEIFS function used in Excel to calculates the average of a range of cells that meet multiple Conditions.
Use of Sumifs function with an Ai tool.
Просмотров 24День назад
The Sumifs function use to return the value in a cell based on multiple conditions which is very useful for generating various types of reports in any sector.
How to separate Last name from Full name.
Просмотров 42День назад
By using this function we can separate last Name from Full name in one second, those who want to know how to separate first name please use the link to open vedio ruclips.net/video/kea62aeSut4/видео.htmlsi=pPA8GQ_fxjSQNFkb
How to separate Middle Name from Full Name.
Просмотров 32День назад
By using this formula we can separate the Middle Name of a Person in a second.
How to separate First Name from Full Name.
Просмотров 24День назад
By using this formula we can separate First name from a Full Name in excel file.
#Text to Columns
Просмотров 136День назад
This is a Basic Tool of Excel allows you to easily separate text into multiple columns.
#xlookup function
Просмотров 153 месяца назад
The Xlookup function in excel is used to search for a return values from a table or a range of data.
#Trim function
Просмотров 12Год назад
Trim formula use of Trim Function in excel, a Commonly used formula, for Data accuracy we must use this function ,
#index match
Просмотров 35Год назад
Index match is a Lookup function in Excel, it is a combination of two functions that is Index and match.
# Use of Nested if Function in Excel.
Просмотров 89Год назад
In this video, we are going to learn about the Nested if function and how it works. where it will help us with a small exercise. a Commonly used function by People.
VLOOKUP Assignment
Просмотров 68Год назад
VLOOKUP Assignment
#Macro
Просмотров 433 года назад
#Macro
#sum Vs Sumif
Просмотров 203 года назад
#sum Vs Sumif
#uk simply heaven
Просмотров 373 года назад
#uk simply heaven
#If function in Excel
Просмотров 763 года назад
#If function in Excel
#Count A # Count # Count Blank
Просмотров 553 года назад
#Count A # Count # Count Blank
AVERAGE AND AVERAGE IF FUNCTION.
Просмотров 243 года назад
AVERAGE AND AVERAGE IF FUNCTION.
Virtual get together
Просмотров 1613 года назад
Virtual get together
AND and AND with IF Function
Просмотров 313 года назад
AND and AND with IF Function
Functions of excel
Просмотров 253 года назад
Functions of excel
Absolute and relative Reference
Просмотров 333 года назад
Absolute and relative Reference
Use of Concatenate function
Просмотров 483 года назад
Use of Concatenate function
Know Insert and Delete Raw & Columns.
Просмотров 373 года назад
Know Insert and Delete Raw & Columns.
Use of Proper,Lower & upper function.
Просмотров 713 года назад
Use of Proper,Lower & upper function.
First Topic
Просмотров 743 года назад
First Topic

Комментарии