A macro in Excel is a recorded series of actions, such as formatting a report or cleaning imported data, that Excel saves as VBA code and can replay whenever you need it. To create one, go to View > Macros > Record Macro, give it a name, carry out the steps once, then click Stop Recording. Run it again with Alt + F8, a keyboard shortcut or a button, and save the file as an Excel Macro-Enabled Workbook (.xlsm) so the macro is kept.
To insert a clickable checkbox in Word, first show the Developer tab: go to File > Options > Customize Ribbon, tick Developer and click OK. Then place your cursor where the checkbox should go and click Developer > Check Box Content Control in the Controls group. Click the box to tick or untick it. For a checklist that will be printed and ticked by hand, use Home > Bullets > Define New Bullet > Symbol and choose an empty box symbol instead.
To remove duplicates in Excel, click anywhere in your data, go to the Data tab and click Remove Duplicates in the Data Tools group. Tick the columns Excel should compare (all columns removes only identical rows; one column removes repeats of that value), make sure My data has headers is ticked, and click OK. Excel deletes the duplicate rows, keeps the first occurrence of each, and tells you how many were removed.
To lock cells in Excel, select the whole sheet, press Ctrl + 1, and on the Protection tab untick Locked. Then select only the cells you want to lock, press Ctrl + 1 again and tick Locked. Finally, go to Review > Protect Sheet, choose what users can still do, add a password if you want one, and click OK. Locked cells can no longer be edited until you go to Review > Unprotect Sheet.
To add page numbers in Word, go to the Insert tab, click Page Number in the Header & Footer group, choose a position (Top of Page, Bottom of Page or Page Margins) and click a style. Word numbers every page automatically and updates the numbers as you add or remove pages. To leave the first page unnumbered, tick Different First Page on the Header & Footer tab. To change the style (such as i, ii, iii) or the starting number, use Page Number > Format Page Numbers.