All Access

7 Useful Excel Hacks You Should Know About

Excel newbie no more.
IMAGE SHUTTERSTOCK

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
Recommended Videos
? 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. ;)

your REACTION
CUTE

4

OMG

4

HEART

0

YAY

0

/////////////////////////////
COMMENTS. JOIN THE DISCUSSION BELOW!
Comments
About the author
The Candy Staff
VIEW OTHER ARTICLES FROM The Candy Staff

Create your content

Photo
Video
SoundCloud
Hi, you!
Title
Body Text
*1st 15 seconds will be uploaded
*File size limit (up to 60MB)
*File size limit (up to 60MB)
or
Upload Video
*For the direct video upload option, only the first 15 seconds of the video will be uploaded
*File size limit (up to 60MB)

By submitting your post, you agree to Candymag's Terms of Use and Privacy Policy.

Thank you for submitting your post.
You will be notified via email once your entry has been approved by the Candy team.

Submitted posts will be subject to the approval of the Candy Team.

A few reminders:

  1. Candy Bulletin is an online platform where users can upload original work, personal passion projects, and other forms of self-expression, for the purpose of sharing with the community.
  2. You can upload photos of your curated OOTDs, 15-second videos, essays, poems, and more, as long as the submitted work is original, follows copyright laws, and free of any nudity, pornography, or profanity.
  3. You are encouraged to comment on one another's posts, as long as everyone remains respectful.
Submit Another Post View More Posts
latest on CandyMag.com
 
x
Share
 
x
Share
They once received a lot of hate for their dark skin, but they rose above it and are now leading the shift in society's beauty standards.
 
x
Share
First of all, you will be laughing so hard with each episode. Surprise!
 
x
Share
Coincidentally, Pink Sweat$ got engaged to girlfriend JL Bunny just a day before.
 
x
Share
What's more motivating than "studying" with seven Grammy-nominated superstars?
LOAD MORE ARTICLES
your REACTION
Pick a sticker to view stories by reaction!
/////////////////////////////
CONNECT WITH US