If you’re a marketing person or manager, Microsoft Excel is part of your daily life. You can’t imagine your life without Excel, unless you’re a practitioner of other data analysis tools like SAS, SQL, R etc. I have been using excel for a long time as my workflow requires me to do a lot of data cleaning, filtering and analysing. The most of my work until now was done by using an Excel addin like Asap Utlities, SEO Tools for Excel by Niels Bosma, Ex Tools, Analytics Edge etc to name a few. My excel is pretty slow in spite of my high end laptop. Once you start getting deeper into marketing, addins can’t save your life and you have to learn Excel functions and formulas to accelerate your workflow. If you’re interested in learning about some important Excel functions or formulas or tips or tricks that can be helpful, keep reading.
As a marketer or someone who needs to use Excel every day, you must be well familiar with the following (order does not show the importance):
- Advanced Filtering
- Pivot Tables
- Functions (Especially conditionals like Sumif, countif etc.)
- Conditional Formatting
- Keyboard shortcuts
- VLookup, HLookup
- Creating Histograms
- Regression Analysis
Now it’s not possible to accommodate all of that in just a single page and we would limit ourselves to the first thing that one needs to master while working with excel, which is keyboard shortcuts. Practically, you need to observe your own workflow to find out the kind of things that you’ve to do very often using mouse. Using a keyboard shortcut instead of mouse movement will always save you a few seconds. At the end of the day, the combined effect of those few seconds every now and then will be a lot more than you’d expect. Let’s get started using the Excel shortcuts.
Common Keyboard Shortcuts
- Ctrl + N Creates a new workbook
- Ctrl + O Opens a new workbook
- Ctrl + S Saves the current workbook
- F12 Save the active workbook under a new name
- Ctrl + W Close the active workbook
- Ctrl + C Copy the contents of the selected cells
- Ctrl + X Cut the contents of the selected cells
- Ctrl + V Paste the content of the clipboard into the currently active cell(s)
- Ctrl + Z Undo your last action
- Ctrl + P Open the print dialog
As you’d know the keyboard shortcuts mentioned above are common and apply to other programs like Microsoft Word, browsers, pdf editors, text editors etc. If not, remembering these shortcuts will make your overall life much easier as they can be applied to many software on PC.
I will add more keyboard shortcuts in this post later as I work more and more. For a big list of excel columns visit the links below