Excel can do almost anything, but a surprising number of everyday jobs still take a formula you have to look up, a macro you have to write or ten minutes of copying and pasting: combining a folder of workbooks into one sheet, splitting a list into separate tabs by region, merging cells without losing their contents, finding duplicates across two...
