Top 10 skills you need to learn in Excel to make you look like a wizard.

So you said you were competent in Excel and all Microsoft programs, because that’s what you do on a CV isn’t it? To be fair, you used a Word template that you downloaded, you applied for the job by emailing it from Outlook, and you made presentations in Powerpoint in school. So that’s pretty much professional! Isn’t it?

Each program has hundreds of functions and features that can make a real difference to your job and the work that you do. Being realistic so many of them are for very specific purposes that you probably won’t need to learn much more than the key skills. 

Here are my Top 10 things you should learn in Excel to make you look like a wizard to your colleagues, and to your boss. Some of them are very simple, others are not. I will expand on these topics in other posts over the following weeks. Click the links below to dive in.

1. Moving around the worksheet using the keyboard.
2. Autosum.
3. Filtering.
4. Formatting cells.
5. Printing all columns (or rows) per sheet.
6. Vlookup.
7. Conditional formatting.
8. Remove duplicates.
9. Autofill.
10. Text to columns.

What have I missed out that you couldn’t do without?

The Excel cheat sheet mugs below will give you a head start to becoming a Spreadsheet wizard!