- Видео 82
- Просмотров 72 856
Eduolio
Добавлен 25 май 2021
2 Ways To Remove Duplicates in Excel | Under 5 Mins
🎓 Learn advanced excel with our complete excel training course: eduolio.com/excel-course/
How to remove duplicates in excel-
Method 1:
1. Select the data range and convert it into a table. You can use the shortcut CTRL+T
2. Select the entire table and go to "Data" tab.
3. Select "Remove Duplicates" option.
4. If your table has header then make sure "My list has headers" checkbox is checked.
5. Click "Ok"
Method 2:
1. Find an empty cell next to data range.
2. Type =UNIQUE(A1:C15) where A1:C15 is the data range and hit enter.
Voila, you know 2 ways to remove duplicates in excel.
If you want to learn more excel concepts like pivot tables, dashboards, vlookup, IF formulas, conditional formatting, macros...
How to remove duplicates in excel-
Method 1:
1. Select the data range and convert it into a table. You can use the shortcut CTRL+T
2. Select the entire table and go to "Data" tab.
3. Select "Remove Duplicates" option.
4. If your table has header then make sure "My list has headers" checkbox is checked.
5. Click "Ok"
Method 2:
1. Find an empty cell next to data range.
2. Type =UNIQUE(A1:C15) where A1:C15 is the data range and hit enter.
Voila, you know 2 ways to remove duplicates in excel.
If you want to learn more excel concepts like pivot tables, dashboards, vlookup, IF formulas, conditional formatting, macros...
Просмотров: 390
Видео
Hlookup in Excel With Examples | Complete Guide
Просмотров 7910 месяцев назад
🎓 Learn advanced excel with our complete excel training course: eduolio.com/excel-course/ How to use hlookup in excel: 1. Under the cell where you want to lookup the value horizontally. 2. Type =hlookup(Lookup value, data range, row number, FALSE) and hit enter. To better understand the process, we recommend you watch the entire video to learn how to use hlookup in excel. If you want to learn m...
Show Numbers In Thousands or Millions In Excel | Quick Trick
Просмотров 9010 месяцев назад
🎓 Learn advanced excel with our complete excel training course: eduolio.com/excel-course/ How to show larger numbers in millions or thousands in excel: 1. Select all cells in the sheet 2. Right click to select "Format Cells" or use shortcut CTRL 1 3. Under "Custom" tab type 0.00,,"M" to show in millions or type 0.00,"K" to show in thousands 5. Click "Ok" Voila, you know how to display millions ...
How to Find Duplicates in Excel Using Conditional Formatting
Просмотров 15011 месяцев назад
🎓 Learn advanced excel with our complete excel training course: eduolio.com/excel-course/ How to find duplicate values in excel using conditional formatting: 1. Select all cells in excel where you want to check for duplicates. 2. Under Home tab select Conditional Formatting. 3. Choose Highlight Cells Rules and select Duplicate Values 4. Select the formatting rule to specify how to format the du...
How to Copy Formulas Without Changing Cell References in Excel | 2 Step Method
Просмотров 1,1 тыс.11 месяцев назад
🎓 Learn advanced excel with our complete excel training course: eduolio.com/excel-course/ How to copy formulas in excel without changing cell references: 1. Under Home tab select Find & Select. 2. Choose Replace option. 3. Under Find type "=" and under Replace with type "-" then select Ok. 4. Excel will replace all the "=" in the formulas with "-" 5. Copy the formulas and paste it an empty colu...
How to Calculate Rank in Excel | Rank Formula in Excel
Просмотров 1,6 тыс.11 месяцев назад
🎓 Learn advanced excel with our complete excel training course: eduolio.com/excel-course/ How to calculate rank using rank formula in excel: 1. Type =RANK(B2,B2:B14,0) Where B2 is the cell with marks/value and B2:B14 is the cell range. 0 means descending order. 2. Drag the formula down to rest of the cells. 3. Select the data headers, go to Home tab and select Filter option. 4. Sort ascending t...
Autofill Only Weekdays in Excel | Quick 3 Step Tutorial
Просмотров 130Год назад
🎓 Learn advanced excel with our complete excel training course: eduolio.com/excel-course/ How to autofill only weekdays in excel (Mon-Fri): 1. Write a date and drag it down to autofill 2. On the last cell bottom right you'll see a box, click on the same to see auto-fill options 3. Select "Weekdays" and excel will update the data to only show dates from Mon-Fri How to autofill only weekdays in e...
Add Months to Date in Excel | Under 2 Minutes
Просмотров 69Год назад
🎓 Learn advanced excel with our complete excel training course: eduolio.com/excel-course/ How to add months or years to date in excel: 1. Type =EDATE(A2,B2) where A2 is the date and B2 is the number of months. 2. Drag the formulas to the rest of the cells. 3. To add years to date in excel, type =EDATE(A2,B2*12) where A2 is the date and B2 is the number of Years. Voila, you know how to add month...
Excel Pivot Table - Percentage of Total | Quick 3 Step Tutorial
Просмотров 567Год назад
🎓 Learn advanced excel with our complete excel training course: eduolio.com/excel-course/ How to add percentage column in pivot table in excel: 1. Use CRTL A to select the entire data 2. Go to "Insert" tab and select "Pivot Table" 3. In the dialog box click "Ok" 4. Drag the needed column from field options to "Rows" 5. Drag the sales column from field options to "Values" 6. Again, drag the sale...
How to Lock Cells in Excel | Quick 2 Step Tutorial
Просмотров 13 тыс.Год назад
🎓 Learn advanced excel with our complete excel training course: eduolio.com/excel-course/ How to lock cells in excel or just locks cells with formulas in excel: 1. Select all cells in the sheet 2. Right click to select "Format Cells" or use shortcut CTRL 1 3. Under "Protection" tab, uncheck the "Locked" checkbox then click "Ok" 4. Now on the sheet, only select the range of cells which you wanna...
How to Add Leading Zeros in Excel | Under 2 Minutes
Просмотров 1,4 тыс.Год назад
🎓 Learn advanced excel with our complete excel training course: eduolio.com/excel-course/ How to add leading zeros or add zero in front of numbers in excel: 1. Select the cell range having numbers 2. Right click and select "Format Cells" or use shortcut CTRL 1 3. Select "Number" tab and choose "Custom" as Category 4. In the "Type" field remove the text and type 00000 5. Click "Ok" Voila, you kn...
Find Unique Values In Excel Using Advanced Filter | 5 Min Excel Tutorial
Просмотров 523Год назад
🎓 Learn advanced excel with our complete excel training course: eduolio.com/excel-course/ How to remove formula but keep data - ruclips.net/video/DqC0HSmtwvs/видео.html Here's how to find unique values using advanced filter in excel: 1. Go to "Data" tab and select "Advanced Filter" option 2. Select "Copy to another location" 3. In "List range" select the cell range from which you want to fetch ...
Remove Formulas But Keep Data | Convert Formulas to Data in Excel
Просмотров 2,1 тыс.Год назад
🎓 Learn advanced excel with our complete excel training course: eduolio.com/excel-course/ How to paste data as values in excel or remove formulas but keep data: 1. Select the cell range having formulas 2. Press CTRL C 3. Right click and select "Paste Special" 4. Choose "Paste Special" again 5. From the "Paste Special" dialog box select "Values" and click "Ok" Voila, you know how remove formulas...
Combine Text in Excel | Using Concatenate Function
Просмотров 49Год назад
Combine Text in Excel | Using Concatenate Function
Google Translate Function | Translate Any Language in Google Sheets
Просмотров 23Год назад
Google Translate Function | Translate Any Language in Google Sheets
Excel Random Number Generator| RAND Function in Excel | 2023 Update
Просмотров 37Год назад
Excel Random Number Generator| RAND Function in Excel | 2023 Update
Dollar Formula in Excel | 3 Quick Steps | Excel Tutorial
Просмотров 16Год назад
Dollar Formula in Excel | 3 Quick Steps | Excel Tutorial
Convert Numbers to Text in Excel | 3 Quick Methods
Просмотров 26Год назад
Convert Numbers to Text in Excel | 3 Quick Methods
How to Hide Sheet in Excel | 3 Clicks To Hide & Unhide
Просмотров 30Год назад
How to Hide Sheet in Excel | 3 Clicks To Hide & Unhide
Calculate Percentage in Excel | Simple & Quick Formula
Просмотров 24Год назад
Calculate Percentage in Excel | Simple & Quick Formula
How to Add Columns in Excel Using A Quick Shortcut
Просмотров 14Год назад
How to Add Columns in Excel Using A Quick Shortcut
Formula Tab in Excel | How to Use, Hide & Unhide
Просмотров 32Год назад
Formula Tab in Excel | How to Use, Hide & Unhide
How to Count Characters in Excel | LEN Function in Excel
Просмотров 44Год назад
How to Count Characters in Excel | LEN Function in Excel
Top 5 Math Formulas in Excel You NEED TO KNOW in 2022
Просмотров 125Год назад
Top 5 Math Formulas in Excel You NEED TO KNOW in 2022
Fill Blank Cells in Excel under 2 Mins | Excel Tutorial
Просмотров 38Год назад
Fill Blank Cells in Excel under 2 Mins | Excel Tutorial
Create Hyperlink in Excel | Add Hyperlink in 2 Minutes
Просмотров 2,1 тыс.2 года назад
Create Hyperlink in Excel | Add Hyperlink in 2 Minutes
How to Insert Diagonal Line in Excel | Split Cells Diagonally
Просмотров 22 тыс.2 года назад
How to Insert Diagonal Line in Excel | Split Cells Diagonally
How to Multiply an Entire Column by a Number in Excel | 3 Easy Steps
Просмотров 1 тыс.2 года назад
How to Multiply an Entire Column by a Number in Excel | 3 Easy Steps
How to Insert Row in Excel | Add Row Using Simple Shortcut
Просмотров 862 года назад
How to Insert Row in Excel | Add Row Using Simple Shortcut
Please provide the sheet link for practice
Thanks sir
thanks
6 out of 10 but will fool undiscerning boss.
Nice and wonderful explanation...more and more excel plz❤❤❤
Simple and effective! Thanks
Very usefull. Thanks!
Which version of Excel are you using which also has auto save option?
Can u give me a solution or tell reason why CTRL+1 isn't working???
This is new to me !!❤❤
Thank you!
Very good
Need more ...
Good
Which os u use?
Popcom 🎉❤🎉 silençe you hopland 🎉❤❤❤❤❤❤❤❤❤🎉😊❤😂😂😂
Learning English p vedio bna do
Great
Thanks. I just Learned something.
Popcom 🎉❤❤❤❤❤❤❤🎉
Popcom 🎉❤❤❤❤❤❤❤❤😊❤😊😊😊🎉😂😂😂🎉
Nice info. Can you please tell how to convert into values when data is filtered
❤bahut aacha ❤❤ agay chalkar bada channel panega ❤
❤bahut aacha ❤❤ agay chalkar bada channel panega ❤🎉🎉
❤❤😂😂❤bahut aacha ❤❤ agay chalkar bada channel panega ❤😊😊
Ya sab kya bana rahay ho bhai 😢😢
❤bahut aacha ❤❤ agay chalkar bada channel panega ❤🎉😂❤
❤bahut aacha ❤❤ agay chalkar bada channel panega ❤
❤bahut aacha ❤❤ agay chalkar bada channel panega ❤
❤bahut aacha ❤❤ agay chalkar bada channel panega ❤❤
❤❤❤ very good bahai ❤❤
❤❤❤ very good bahai ❤❤
❤❤❤ very good bahai ❤❤
❤❤❤
Nice ❤
Thank you.
Thankyou so much brother......
Hyperlink opening hone ke baad Utometic close ho jati he
When I'm dragging it's not changing
ρгό𝔪σŞｍ 😁
Very informative 👍🏻👍🏻
Bhai pivot par video banao
Thanks for the suggestion. We'll make a detailed video on pivot tables in excel.
gfgfgjfkcjcxgffgfh
🌹❤️😍😘🥰💟♥️
fgffggfghmjcjcjjcnjjfjfjfjjfnfj
Gracias 😁