How to Remove Duplicates in Excel

Now we are coming to a very useful but rather unknown function: Remove Duplicates. Let’s say, you got a list of names and some names are twice on the list. With Remove Duplicates, you can delete those duplicated names automatically so that each name appears only one time.

How to Use the Format Painter in Excel

Which step do you spend the most time, when you create an Excel model? Typing formulas and checking results, or rather setting the format, e.g. selecting borders, backgrounds, fonts, font sizes, font styles and even row and column heights and width? Formatting an Excel table can take a large amount of time, but “Format Painter” can greatly reduce the time you needed.

How to Send a Workbook as PDF Attachment From Excel

Which method do you use for sending an Excel file as a PDF via E-Mail? Go to Home –> Export –> Create PDF/XPS, then choose the folder and press “Publish”? Or do you go to Outlook, create a new E-Mail, search for the PDF file on your hard drive and attach it? There is a much faster way with just one click!