7 Useful Excel Hacks You Should Know About

Excel newbie no more.
by The Candy Staff   |  Nov 12, 2020
Image: SHUTTERSTOCK
Share This!

As part of the younger generation who grew up immersed in the digital world, it’s safe to say that we’re pretty well-versed when it comes to technology—except maybe when it comes to Microsoft Excel. We can figure out how to navigate through a brand new app, but there’s a learning curve we just can’t get pass through when it comes to Excel. Many students, however, rely on the software for class requirements and projects and would take a looot of time to navigate through the program whenever they have to use it for class.

So for everyone who feels like they’re still an Excel newbie even after years of using the software, watch these TikTok videos for useful Excel hacks you should know about:

Separating names into different cells

@keyapot00

In-hale, Excel with me!! #microsoftexcel #exceltricks #exceltips

? Desce Pro Play (PA PA PA) - MC Zaac & Anitta & Tyga

Combining names from different cells into one cell

@keyapot00

Easy way to combine names!! #fyp #foryoupage #microsoftexcel #excel #exceltricks #exceltips #learnwithlove

ADVERTISEMENT - CONTINUE READING BELOW
? How You Like That - BLACKPINK

Auto-filling numbers

@excel.tricks

How to add Numbers automaticly! #study #student #foryou #excel #exceltricks #exceltips #class #job

? She Share Story (for Vlog) - ??

Transposing

@businessrob

This is one of my favorite Excel tricks - Transpose!! #excel #tutorial #course #spreadsheet

CONTINUE READING BELOW
Featured Video
? She Share Story (for Vlog) - ??

Protecting and locking cells

@coachubby

Macro 3 #SkillBuilding #excel #excelpinoy #edutok #educreator #EdukasyongPinoy edutokph #excel_learning #tiktoku #exceltips

? original sound - coachubby

Alphabetizing with data

@exceltipss

How to sort names+data into alphabetical order

? Garage Room Freestyle (Reel It In) - Number9ok

Lowercase to uppercase characters

@exceltipss

Lower to Upper case

? Steven Universe - L.Dre

***

CanB is finally here! If you're an aspiring writer, vlogger, artist, or kahit marami ka lang talagang time, submit your entries here and make your mark in the Candy community! Share your feels, show your skills. Don't worry—we won't judge. ;)

REAX!
How do you feel about this article?
About the author
The Candy Staff
VIEW OTHER ARTICLES FROM The Candy Staff
How do you feel?
Click on your mood to read related stories
The Latest
Plus, products available in the market that contain them.
You'll remember Lee Woo Je as Hwang In Yeop's BFF in 'True Beauty'!
All you need is internet and a laptop or a desktop.
They've conquered national TV and the internet.
The Korean romantic drama has left viewers rightly confused.
LOAD MORE ARTICLES
CONNECT WITH US