Data Entry

5 MS Excel Tips and Guides That Might Help You Get Hired

July 1, 2021

5 MS Excel Tips and Guides That Might Help You Get Hired

Are you still using Microsoft Excel as something like Microsoft Word? It’s definitely a lot more than just typing words and numbers. A tool that might actually increase your chances of getting hired as a Freelancer because of how useful it is. 

If you already have a job then learning these could make your tasks easier. For those applying for a work-from-home job like a virtual assistant. You can definitely highlight this as part of your skills/knowledge which really comes in handy especially for administrative tasks. Here are the top 5 Microsoft Excel Tips and Guides that you can easily learn:

Pivot Table

Pivot Table is very useful when it comes to reporting or getting a quick overview of what’s the current status of pretty much any tasks you are doing. I used to panic when I hear the word Pivot table thinking that it has something to do with programming or formula but it’s actually very simple.

https://www.microsoft.com/en-us/videoplayer/embed/RWedWH?pid=ocpVideo0-innerdiv-oneplayer&postJsllMsg=true&maskLevel=20&market=en-us

Vlookup

This one is probably one of the most useful excel functions especially for Data entry or Administrative tasks. It makes Excel search for a certain value in a specified column. It can be used either to match data, validation or checking for duplicate entries.

https://www.microsoft.com/en-us/videoplayer/embed/RWebqk?pid=ocpVideo0-innerdiv-oneplayer&postJsllMsg=true&maskLevel=20&market=en-us

The formula for Addition, Subtraction, Multiplication, and Division

An obvious advantage of Excel is its automation to compute large numbers of entries easily without manually doing any kind of equation.

https://www.microsoft.com/en-us/videoplayer/embed/RWer07?pid=ocpVideo0-innerdiv-oneplayer&postJsllMsg=true&maskLevel=20&market=en-us

Duplicate Entry Checker/Removal 

A simple yet effective option to remove duplicate entries when you’re dealing with a lot of data that involves money, supplies, orders, or anything that needs to be check for duplicates. 

There are 2 ways to work on duplicate entries. 1st is the option to remove duplicate data by highlighting an entire row, click on Data, click on Remove Duplicates and click Ok.

It should change from this:

To this:


The other option to check for duplicates is to simply get the duplicate entries highlighted without removing them so that you can view them first. You can do this by highlight the entire row, click on home, conditional formatting, highlight cells rules, duplicate values, and click ok.

It should look like this once you’re done:

Drop Down Filter is done to easily filter out certain values or entries to make it easier to manage or have a quick look. You can just click on the column and press and hold the shortcut: Ctrl + Shift + L

Drop Down List is when you want to limit what needs to be placed under a certain cell. It lets other people know what are the valid options are.

https://www.microsoft.com/en-us/videoplayer/embed/RWfbUM?pid=ocpVideo0-innerdiv-oneplayer&postJsllMsg=true&maskLevel=20&market=en-us

Knowing these won’t automatically get you hired but it can definitely be an edge you can always highlight during your job interview. It won’t only come in handy for work but also when you have your own business where you want to track down practically anything to make sure everything is in order.

Leave a Reply

Your email address will not be published. Required fields are marked *