77. Advance Find and replace

Find and replace in Excel can do more than the normal find and replace function in other office application. You can find information within a sheet, workbook, directions and where to look for certain information. You can even look for information in formula or comments as well. As for replace, you can easily replace contents in cell with specific formating or color as well. Find out more in this video