๐๐๐ฌ๐ญ๐๐ซ ๐๐๐๐ ๐๐๐๐๐๐๐๐ ๐๐ฌ๐ฌ๐๐ง๐ญ๐ข๐๐ฅ๐ฌ ๐จ๐ง ๐๐ฑ๐๐๐ฅ ๐ข๐ง ๐๐ฎ๐ฌ๐ญ ๐๐ ๐๐ข๐ง๐ฎ๐ญ๐๐ฌ / ๐๐๐ญ๐ ๐๐ฅ๐๐๐ง๐ข๐ง๐ ๐๐ซ๐ข๐๐ค๐ฌ ๐ข๐ง ๐๐ฑ๐๐๐ฅ ๐๐๐๐
ะฝะฐ ะบะฐะฝะฐะปะต: ๐๐๐๐ข๐๐ ๐๐จ๐ง๐ค ๐๐ซ ๐๐ฑ๐๐๐ฅ ๐๐จ๐๐๐ก
In this video you'll learn more than 20 data cleaning tricks on Excel. We'll go from having a raw dataset that has several errors, to a clean dataset that we can present to our managers. For this, we learn tricks such as text to columns and remove duplicates, and several formulas such as the trim, proper, lower and many more.
#Excel #ExcelTutorial #ExcelData
โฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌ
Join this channel to get access to perks:
ย ย ย /ย @office-monkย ย
โฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌ
๐ File Link:
https://docs.google.com/spreadsheets/...
โฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌโฌ
Chapters:
0:00โ -โ Intro
0:14โ -โ Copy Paste Special
03:20โ -โ Group & Ungroup
04:19โ -โ Create Table
05:15โ -โ Find & Replace
05:56โ -โ Hide Rows & Columns
06:52โ -โ Add $ Sign
07:21โ -โ Copy & Paste Values
07:55โ -โ Arrange Data Without Copy Paste
08:54โ -โ Text To Columns
10:24โ -โ Unstack Data 1st Way
12:04โ -โ Unstack Data 2nd Way
13:12โ -โ Unstack Data 3rd Way
14:44โ -โ Convert
15:29โ -โ Create Filters
16:12โ -โ Delete Blank Cells
16:57โ -โ Fill Special Character
18:00โ -โ Flash Fill
19:00โ -โ Change Cases
20:18โ -โ Find & Delete DUPLICATES
20:56โ -โ Clear & Manage FORMAT
22:14โ -โ Bonus Tips
23:12โ -โ Closing
Intro Clip / Video Credit: Vecteezy
@Vecteezy
ะกะผะพััะธัะต ะฒะธะดะตะพ ๐๐๐ฌ๐ญ๐๐ซ ๐๐๐๐ ๐๐๐๐๐๐๐๐ ๐๐ฌ๐ฌ๐๐ง๐ญ๐ข๐๐ฅ๐ฌ ๐จ๐ง ๐๐ฑ๐๐๐ฅ ๐ข๐ง ๐๐ฎ๐ฌ๐ญ ๐๐ ๐๐ข๐ง๐ฎ๐ญ๐๐ฌ / ๐๐๐ญ๐ ๐๐ฅ๐๐๐ง๐ข๐ง๐ ๐๐ซ๐ข๐๐ค๐ฌ ๐ข๐ง ๐๐ฑ๐๐๐ฅ ๐๐๐๐ ะพะฝะปะฐะนะฝ ะฑะตะท ัะตะณะธัััะฐัะธะธ, ะดะปะธัะตะปัะฝะพัััั ัะฐัะพะฒ ะผะธะฝัั ัะตะบัะฝะด ะฒ ั ะพัะพัะตะผ ะบะฐัะตััะฒะต. ะญัะพ ะฒะธะดะตะพ ะดะพะฑะฐะฒะธะป ะฟะพะปัะทะพะฒะฐัะตะปั ๐๐๐๐ข๐๐ ๐๐จ๐ง๐ค ๐๐ซ ๐๐ฑ๐๐๐ฅ ๐๐จ๐๐๐ก 20 ะัะฝั 2024, ะฝะต ะทะฐะฑัะดััะต ะฟะพะดะตะปะธัััั ะธะผ ัััะปะบะพะน ั ะดััะทััะผะธ ะธ ะทะฝะฐะบะพะผัะผะธ, ะฝะฐ ะฝะฐัะตะผ ัะฐะนัะต ะตะณะพ ะฟะพัะผะพััะตะปะธ 50 ัะฐะท ะธ ะพะฝะพ ะฟะพะฝัะฐะฒะธะปะพัั 2 ะปัะดัะผ.