[Uncut Webinar] How to Use Find & Replace in Excel Like a Pro | Excel Sifu
This is a lunch and learn session covering the usage of "Find & Replace" in Microsoft Excel.
00:00 Introduction
00:47 Setting Up Excel File
01:39 Understanding Find and Replace in Excel
04:16 List down all matched cells in an Excel spreadsheet
04:58 Understanding difference between "Replace All" and "Replace" in Excel
05:36 Speedy Shortcuts and Tips to "Find and Replace"
08:19 Find and Replace on Specific Cells in Excel
09:10 Changing Year in All Date Data with Find and Replace
09:40 Replacing All
10:46 Options in "Find and Replace"
11:26 Replacing To Another Value by Matching Colour and Values
14:05 Changing to Different Colour and Values
15:14 Finding and Replacing Across Multiple Worksheets
19:20 Removing All Spaces with Find and Replace
21:47 Finding and Replacing Specific Digit in Numbers
23:36 Easy Way to Scramble Data in Excel
29:29 Summarizing Find and Replace in Excel
30:00 Closing
Connect to me in LinkedIn
/ excelsifu
Like our FB
/ whyexcel