How to Use Excel Basics

SCI Online Programs and Courses
Request More Info

By submitting this form, I agree that Southern Careers Institute may contact me via email, text message or telephone, including the use of autodialers, regarding its programs and offers. Standard text and/or usage rates may apply.

How to Use Excel Basics: 4 Tips to Boost Your Hirability

We’ve all been there: you’re trying to get a task done quickly–say you’re planning for a party or you are evaluating products in a side-by-side comparison to see what the best option is for price and benefits. Something that you would like to get squared away sooner than later. You open up a spreadsheet to input some data and then something happens–a cell freezes or you can’t get the numbers formatted correctly, and BOOM–you’re frustrated.

Before you blame it on the darn software that isn’t working, or curse yourself for not being tech-savvy, here is the truth–you have simply not taken the time to how to use Excel. That’s Step 0–admitting you’re a beginner, and dropping all the stressful feelings and negative self-talk. There–that wasn’t so bad, was it? Now that we have established that, we can start to understand WHY it’s important to learn how to use Excel basics and how it can help you GET and KEEP your job.

Tip 1–Understand why learning Excel basics is important

Computer-Excel-Basics-Career-Training What do administrative assistants, business analysts,accounting specialists, & department managers have in common? Besides all struggling to make the coffee in the shared kitchen to everyone’s liking, all of these positions use spreadsheets in their day-to-day to get important things done (Techwalla). According to a study reported in Fortune, “jobs that require a high school degree but not necessarily a college education found that 78% of jobs require digital skills like Excel and word processing.” These job candidates with technical capabilities also tended to get paid more, too. Microsoft Excel is an incredibly powerful tool, and can accomplish in seconds what once took hours of data entry, analysis, and complex calculations. No matter what your career goals are, learning Excel basics can open doors to higher-paying job opportunities.

Tip 2–Explore Excel Basics

Although the Microsoft Office suite isn’t free, chances are your future employer pays for it and you will be using it day-to-day. So how can you learn how to use Excel for free before you begin a career-training program or a job that requires word-processing software? Google “Microsoft Office free trial” and you will score yourself access to not only Excel, but Word, PowerPoint, and Outlook for a month. If you don’t have a PC, your nearest library will have computers you can use and will likely have Microsoft Office software installed–just be sure to call their front desk to find out for sure. If you decide you want to get advanced career training to prepare you for your next job, you can use the computer labs at a school like Southern Careers Institute. Even if you take online classes through SCI, the ground campus facilities are open to you. Once you open up the programs and start to play around with it, it is useful to go through several of their tutorials and training roadmaps to start to gain confidence and understand some of the Excel basics before you advance to learn how to use Excel in a more complex has to offer. Microsoft also offers an Excel app so you can view, edit, and open documents on your phone, as well.

Tip 3: Learn some time-saving shortcuts

Once you start to understand how to use Excel for the most basic operations–like setting up rows and columns doing simple mathematical functions, you could try creating a pivot table that helps you visualize the data you enter in different ways–columns vs. rows, for example. Another shortcut is learning how to use filters, which can let you easily reveal the data you’re looking for and hide all irrelevant information.

How-to-Use-Excel-Filter-Gif

Image source: https://blog.hubspot.com/marketing/how-to-use-excel-tips

Need to add additional rows quickly as you input data on the fly? Instead of highlighting one row and slowly adding one row at a time, simply highlight the number of rows you would would like to add, right-click, and hit “Insert” and voila, you got yourself lots of extra space to work within.

How-to-Use-Excel-Insert-Spaces-Gif

Image source: https://blog.hubspot.com/marketing/how-to-use-excel-tips

Tip 4–Update your resume and network!

Once you get the Excel basics down, you can and SHOULD add Microsoft Excel and any other software that you become familiar with to your resume. Once you do, you should ensure that you upload the updated resume to LinkedIn, SCI Connect, and any other job-searching platform like Indeed or Monster. It is also a good idea to follow up with any industry career contacts in your network that you know that you may have had employment-related conversations with in the past. It is a good excuse to reconnect with these people. Who knows, maybe someday you will be teaching some of your future colleagues how to use Excel!

Here’s an example of a quick e-mail you can use to write to your contacts:“Hey [CONTACT NAME], I wanted to let you know that I’ve been teaching myself some Microsoft Excel basics and I have updated my resume to reflect my new skillsets (see attached). I am interested in pursuing any opportunities that you may have available in [administration] / [accounting] / [insert applicable role here]. I hope this note finds you well and I hope to see you soon! Best regards, [YOUR NAME HERE].” Be honest but confident about your technical abilities and communicate your progression. Employers always like to hear about how you have taken the steps to learn the tools of the trade for your future role.

Want to fast-track your success by getting the training, know-how, and connections to get that next great job opportunity? Fill out the below form so we can get to know you better and connect you with a career specialist today.

Want to learn more about how National Certifications might help you in today’s job market?

What SCI Students Are Saying

“I made a complete career change when I started my training at Southern Careers Institute. I needed a stable career to continue providing for my growing family. SCI provided me with the medical terminology and know how that I needed to understand and acquire a career in the medical field. SCI taught me that it doesn’t matter where you are in life right now; you always have room to advance and learn.”

Testimonal

Denise S.
Medical Assistant

“I am extremely grateful for the assistance I received from SCI’s Career Services team. I enjoy where I work and what I do. SCI has helped me succeed in life by getting me the necessary education and by making me a stronger and more confident person.”

Testimonal

Raquel S.

“Once I graduated from SCI, I had a sense of accomplishment that helped me through the job search process. SCI provided me with the opportunity to brush up on my skills, extend my accounting knowledge, and they boosted my self-confidence. I went to work two days after my last day of school.”

Testimonal

Annette D.
Business Accounting

“When my youngest child graduated from high school, I told my husband that it was my time. I went back to school to change careers after spending 37 years in the business field. At SCI, the instructors are professional, and they care about what they are teaching you, as well as expect you to give 100% in return. I had problems understanding how to draw in syringes and give injections. I requested extra help from a knowledgeable instructor, and I was able to receive one-on-one training. Today, I draw injections for approximately 100 patients each week. I am very confident in what I’ve learned. SCI has given me the chance to do what I always wanted to do. Thank you for my education. I am doing wonderful.”

Testimonal

Bonnie M
Medical Assistant

“I am now a certified Lab Tech. SCI helped me get an externship, and I came out with a job. After my little sister had cancer, I knew I wanted a career in the medical field that allowed me to help others. I am happy about what I do.”

Testimonal

Sidney B
Medical Assistant

“The best place ever!! Ms.Tonia rocks she is the best teacher… I love going to school my time there is amazing.”

Testimonal

Andrea Garcia

“Southern Careers went beyond my expectations. Very impressed. The assistance I got from Career Services is truly amazing. They really went out of their way to get me placed. They really care and I am grateful to all of them.”

Testimonal

Olga C.

“Southern Careers Institute totally surpassed my expectations. Once I finished school, the Career Services team helped me find a job. I would tell anyone thinking about starting career training that you have nothing to lose and a lot to gain. I wish I would have started my training sooner.”

Testimonal

Valerie D.

“I am very happy with where I am and where I’m going. Through high school, I struggled with math. When I came to SCI, I enrolled in the Business Accounting Specialist program to see if I could do it. SCI provided me with the accounting skills I needed to help me find a career. Now, I have an amazing career and room to grow in the company.”

Testimonal

Crystal H.
Business Accounting

Speak with an
Admissions Advisor

Call 1.833.SCI.TEXAS

Our mission is to ensure the long-term success of our students by delivering employer-tailored programs that result in an increasing demand for Southern Careers Institute graduates.

Contact Us Today

Request Info