5 Basic Excel Skills Every Beginner Should Learn

They’ll never suspect you lied to get the job.

It wasn’t a big lie. You just really needed the job, and now you don’t know what to do now that you have it. Your boss thinks you know how to make Excel spreadsheets, but you have no idea where to even start. 

Luckily for you, Excel is easy to learn once you get the ball rolling. There are plenty of beginner tips and tricks to remember, and we’re here to help you out. 

Keep reading below to discover 5 basic Excel skills you need to know. Your boss will never suspect a thing. 

  1. Learn the Shortcuts

Keyboard shortcuts on Excel will save you time. Take some time to learn them before you head into the office. 

A major shortcut you’ll want to use is Ctrl+c to copy a cell and then using Ctrl+v to paste. This is a great shortcut if you’re having to do repetitive tasks on Excel. 

If you need to find something, try Ctrl+f. Are you wanting to copy the entire sheet? Use Ctrl+a. 

  1. Quickly Sort Data

When working with large chunks of data, it’s easiest to sort the data in order to quickly find what you’re looking for later on. For example, many people sort things alphabetically. 

To sort data, highlight all of the data you’d wish to sort. Click on the tab labeled “Data”, and then go ahead and click the “Sort” button. All you have to do now is chose how to sort it. 

If you need to be extra quick and don’t even have time to mess with Microsoft Word, try C# Excel Library.

  1. Practice With Basic Math

As you learn how to use Excel, start practicing simple math before you jump into complex equations. Remember, as you type out your math problems, Excel only does the work when you put an equals sign first. 

It’s like learning how to ride a bike. You need to start with training wheels.

  1. Use a Filter

Filtering your data is great when you’re looking for something specific. Click on the “Data” tab to get started. You’ll then want to hit the “Filter” button. 

Press the “Autofilter” button, and then you’ll need to decide how you want to filter the data.

  1. Peek at Page Layouts

When your boss asks you to print out your spreadsheets, you need to be prepared. One of the best Excel tips for beginners is taking the time to mess around with page layout options. 

Click on the Page Layout tab. Print out a few different copies, and alter the page numbering and columns in each one. You’ll be able to see which looks best. 

Important Basic Excel Skills for Beginners

As you navigate the world of Excel, start off by learning the above basic Excel skills for beginners. Once you master those, you’re ready to master more. 

Know how to filter your data and what shortcuts to use as you work. Before you start printing anything, make sure you understand the page layouts. 

For more quick reads on topics such as technology and health, check out the rest of our page. 

 

Leave a Reply