In these step-by-step tutorials, learn how to use Microsoft Excel. Find out how to get started with MS Excel in under 10 minutes. Learn about Pivot Tables, formulas and functions, vlookup, shortcuts. Also, find out about the latest new features and the top tips and tricks.
Curated by: Kevin Stratvert (120 videos)
Learn how to find and remove duplicates, count unique values among duplicates, and use the new unique function. At the end, I cover how to use Excel for free on the web. Excel on the web supports conditional formatting to find unique values and duplicates, remove duplicates, and the new unique formula. The new unique formula is currently only available to Office Insiders. It will be available to all users soon. To try it out, you can opt into being an Office Insider from within Excel. Here's the sheet I used if you want to follow along: https://1drv.ms/x/s!AmxrofZZlZ-whId6gyC3j47tETM8Pg?e=nPVUfg Watch more Excel tutorial videos: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY - Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com As full-disclosure, I work at Microsoft as a full-time employee.