The 5 Best Excel Tricks I’ve Learned on TikTok

If you want to add "proficient in Excel" to your resume, it's about time you discovered Excel TikTok.

portrait of Meg Embry
by Meg Embry

Updated April 19, 2022

Edited by Jennifer Cuellar
Share this Article
The 5 Best Excel Tricks I’ve Learned on TikTok
Feature Image: Westend61 / Westend61 / Getty Images


Let's be honest: Working in Excel is tedious, and numbers can be scary. But if you're job hunting, you will benefit from getting comfortable with both.

Excel skills have become nonnegotiable for many good jobs across industries. A 2019 study by Burning Glass Technologies projected that employer demand for Excel skills would grow by 23% in just five years. In the information economy, employers are looking for people who can wrangle data, make sense of it, and use it to inform business decisions.

www.bestcolleges.com is an advertising-supported site. Featured or trusted partner programs and all school search, finder, or match results are for schools that compensate us. This compensation does not influence our school rankings, resource guides, or other editorially-independent information published on this site.

Ready to start your journey?

What Makes Excel So Scary?

Excel has been around for nearly 40 years, adding new functions all the time. Currently, there are nearly 500 functions.

The sheer scale of the program can be overwhelming. That's why many of us tend to cling to the basic functions we already understand and ignore the rest. Excel expert Simon Hurst has estimated that the average user only employs about 10% of Excel's processing power.

But you know who isn't scared of all those functions? Gen Z. Some of these young people –– who Business Wire places "firmly at the vanguard of technology use across all generations" –– are even becoming Excel influencers on TikTok.

They manage to make mastering all those functions and formulas fun.

TikTok Is a Skills Platform –– Really

You're probably thinking: TikTok? Isn't that, like, a dancing app for teens?

Sure, you can learn the latest dance moves on TikTok –– if that's what you want. But you can also learn so many other things. In the right hands, TikTok is a digital wonderland of upskilling opportunities and career training resources.

On Excel TikTok, you can learn how to visualize data, perform calculations, and impose order on the chaos of your existence, one digestible short-form video at a time.

Here are the five most satisfying Excel tricks I've learned on TikTok so far.

1. How to Upload Data from a Photo

If your manager wants you to do a bunch of data entry by hand, try this instead.

@exceldictionary maybe next time boss #excel #exceltips #tutorial #spreadsheet ♬ Mission Impossible (Main Theme) - Favorite Movie Songs

2. How to Make a Geographic Heat Map

Thanks to COVID-19, we've all become pros at reading heat maps. Here's how to visualize your own data on a map.

@miss.excel

Geo Heat Map — make it Haute 🔥

♬ Haute - Tyga & J Balvin & Chris Brown

3. How to Format a Massive Spreadsheet

Say your team is working out of a spreadsheet with a billion rows and columns, and none of them are formatted for visual clarity. Here's a quick fix that only takes a couple of keystrokes.

@miss.excel Get ready to impress the whole team with this one 🔥 #theassignment #selfimprovement #todayilearned #excel #learnhow ♬ The Assignment - Tay Money

4. How to Look up Two Separate Fields at Once

If you need to pull data from a table by range or row, use the XLOOKUP function (the latest update to the VLOOKUP function), which lets you look up two fields at once.

Now when you enter your lookup values, XLOOKUP will return the corresponding item!

@excel.friend impossible with vlookup but so easy with xlookup #learn ♬ original sound - Max P

5. How to Create and Format Charts and Graphs

Need to visualize some data for a presentation? Turn it into a gorgeous chart.

Formatting not quite right?

Who knew numbers could look this good?

@miss.excel Chart Magic✨ #excel #howto #summer2020 #summerlooks #edutok #spreadsheet ♬ Magic In The Hamptons - Social House

As you can see: If you're on the job market, angling for a promotion, or just trying to build skills as you go, it might be time to download TikTok.

Frequently Asked Questions About Excel

What is Excel?

Excel is one of the most popular and powerful software programs available. Launched by Microsoft in 1985, it uses spreadsheets to organize data. While Excel is largely used for business finance and accounting, professionals across industries also use it to record, manage, and analyze data.

What are some common uses of Excel?

  • Data entry
  • Data management
  • Charting and graphing
  • Programming
  • Time and task management
  • Customer relations management
  • Accounting
  • Financial Analysis
  • Financial Modeling

What are the benefits of using Excel?

You don't have to be a data analyst to benefit from Excel; it can be a great tool in almost any role. Here are three major benefits of using Excel at work:

1. Everyone else is doing it: According to the Financial Post, there are over 750 million Excel users worldwide, and 63% of businesses rely on the program. Competitors have launched their own spreadsheet programs, but Excel continues to be a shared language that makes communication easier across industries, companies, and stakeholders.

2. It can improve your productivity: Building out an Excel-based workflow can streamline your daily processes, automate tedious manual tasks, increase the visibility of important information, make it easier to track goals, and help reduce opportunities for error.

3. You can extract meaning from huge datasets: Big data is everywhere. Excel can help you sift through it to find patterns and trends. Whether you're making graphs, creating pivot tables, categorizing ranges, or searching for specific information, Excel has a function or tool to make your job quick and accurate.

What jobs require Excel skills?

While the usefulness of Excel transcends roles, you definitely need to know the basics if you're considering a career in any of the following fields:

BestColleges.com is an advertising-supported site. Featured or trusted partner programs and all school search, finder, or match results are for schools that compensate us. This compensation does not influence our school rankings, resource guides, or other editorially-independent information published on this site.

Compare your school options.

View the most relevant school for your interests and compare them by tuition, programs, acceptance rate, and other factors important to find your college home.