Candy Crush Champ Ben Chin revealed his sweet secrets for crushing the competition 🍭
Master Excel with these 5 genius tricks
You can’t keep track of everything on paper. Excel can play a significant role in your daily workload. Whether you’re a beginner or a pro user, there’s much to learn — like these five useful Excel tricks.
Want to become an Excel expert? It’s a good strategy for small business owners who want to grow this year. After all, you’ll generate tons of data. Speaking of which, here’s how to stop third parties from selling your data.
Maybe you’re overlooking the most useful Excel strategies. Scroll down for five Excel tricks to simplify your professional and personal life.
1. First of five useful Excel tricks: Solve errors
Microsoft Excel is chock full of practical formulas. They help save hours you’d otherwise spend clacking away at a calculator.
Unfortunately, it’s easy to make mistakes when calculating through Excel. Its formulas reference many cells, and you can confuse them if you don’t pay attention. Use this table to fix common Excel error messages:
| Error message | Why did you get it? | How to fix it … |
| ##### | One of your columns isn’t wide enough. | Increase the column width. |
| #DIV/0! | Your formula refers to a cell that has 0 or is blank. | Make sure your divisor in a function isn’t blank or zero, or try these other solutions. |
| #REF! | Maybe you deleted or moved a cell one of your formulas refers to. Either way, your cell reference isn’t valid. | Restore any cells you deleted or change the formula. |
| #N/A | One of the values in your function or formula isn’t available. | Replace #N/A with new data. |
| #NAME? | Excel doesn’t recognize the text in your formula. | First, make sure the cell name exists. Then, check for spelling errors. |
| #NULL! | You made an error when specifying an intersection of two areas. | Use a colon (:) to separate references to a contiguous range of cells. Are you referring to two areas that don’t intersect? Use a comma (,) instead. |
| #NUM! | Your formula or function has invalid numeric values. | Make sure the arguments used in functions are numbers. |
| #VALUE! | You used the wrong type of variable or value in a math operation. | Double-check your formula, function and cells referenced by the formula. |
2. Transpose data in a snap
So you transferred some data into Excel — but it didn’t look how you wanted it to. Maybe you entered the data as rows when you wanted them to become columns. Don’t worry: You don’t have to reformat each cell manually.
With these steps, you can rotate data in your worksheet from columns to rows and vice versa.
- First, select the data in your desired column or row.
- Then, press Ctrl + C to copy the selected cells.
- Right-click an empty cell in a row or column where you want the copied cells to go.
- Select Transpose from the paste options.
Just like that, you’ll be able to reformat your data.
Hiring or looking for a job? Upgrade your LinkedIn profile to stand out
When most people find themselves unemployed or are looking for a career change, they head to a job board. But have you heard of LinkedIn? It’s a social media platform with a twist.
LinkedIn also offers excellent options for those looking to hire employees who don’t want to wait for a sea of faceless applications to pour in. It provides prospective employees unique ways to stand out and gives companies a fresh way to look for new talent. Tap or click for smart things you should be doing with your LinkedIn profile.
Competition is a win for consumers: AT&T and AST SpaceMobile are joining forces to provide internet service from space. The deal runs through 2030. Starlink has a similar arrangement with T‑Mobile. More competition = Cheaper prices. Love when that happens!
42% of web traffic
Is generated by bots. And 65% of those are for shady stuff like spying on competition, hoarding inventory and making lookalike phishing sites. There are no laws to protect businesses or consumers against the bot army.
iBUYPOWER's prebuilt PCs will supercharge your gaming
Top gamers trust iBUYPOWER for unparalleled performance and reliability
When you’re gaming, the last thing you want is a lagging computer or unexpected crashes. Game over!
Small business owners, it’s time to upgrade
If your company is growing, you may need more than just Microsoft Excel to keep track of everything. You need high-quality finance software that gives you the complete picture. With our sponsor, NetSuite by Oracle, you can:
298 miles per hour
Speed of record-breaking new quadcopter drone. Father and son Luke and Mike Bell’s remote-controlled Peregrine 2 flew past the competition for the title of world champ. See it in action here. Talk about bonding!
This is hard-core: The Justice Department just hit Apple with a huge antitrust lawsuit. They say Apple is playing dirty to maintain a monopoly over the smartphone market (and keep its prices high) by smothering the iPhone’s competition. Apple says it’s all about keeping user data safe. Su-u-u-re.
Streaming prices are out of control - See what services are charging
We’ve come a long way from the days of visiting Blockbuster Video on a Friday night to find a few movies to pass the weekend. These days, you don’t have to get off the couch to rent the latest Hollywood smash hit.
Now, you just fire up the smart TV and connect to your favorite streaming service to have fantastic content at your fingertips. Giants like Netflix, Hulu, Disney+, Max, Amazon Prime Video, Apple TV+ and Paramount+ have emerged as dominant players, offering a vast array of movies, TV shows and original content.
Can Apple's pricey headset make us accept VR in our everyday lives?
According to ’80s and ’90s movies, we should all be using virtual reality (VR) daily by now. But the tech has yet to catch on. People don’t want to be immersed in an all-digital world (We’re looking at you, Facebook metaverse).
7 new Android 12 features to simplify your day to day
The release of a new operating system is a big deal for mobile developers. This plays a big part in their competition against each other as each tries to retain their users while enticing others to hop the fence.
Android 12 launched last month for Google Pixel phones, while Samsung, Xiaomi OnePlus and other phones that run Android will get the update in the coming months.
Want to go to space? Win a trip on Richard Branson's spaceplane
Frank Sinatra famously sang in 1964, “Fly Me to the moon, let me play among the stars.” The lines were delivered five years before the U.S. made its infamous journey to the moon. Space travel has been the fascination of children and adults alike ever since.
Use Roku? You may lose access to a popular streaming service
Video and music streaming services have skyrocketed in popularity over the last few years. The onset of the pandemic and subsequent lockdowns further increased the user bases of many platforms.
Netflix, the most popular paid-for streaming service by a long shot, added 4 million new subscribers so far in 2021, bringing its total viewers to 208 million. For the same period last year, the platform added 16 million new subscribers. Tap or click here for YouTube tricks and tips you’ll wish you knew sooner.
Antitrust lawsuits: Google accused of manipulating what you see in web searches
Google is without a doubt the biggest search engine in the world. And when it gets accused of manipulating what you see when browsing the net, it’s bound to get ugly. This is not the first time that the search giant has been accused of antitrust behavior.
Facebook slapped with massive antitrust lawsuits to break up social media chokehold
For years, Facebook has been fighting threats of lawsuits, legal challenges and investigations into its practices. It all came to a head this week.
Those legal issues aren’t the only problems Facebook has faced recently, though; Facebook-owned Instagram was accused of illegal facial recognition scans of millions of users earlier this year.
Google reportedly snooping on how you use its rival apps
Is Google using an internal program to keep tabs on rivals’ popular social media apps? A recent report claims that’s precisely what it’s been doing — gathering data and other information from rival third-party apps — and then using that information to create its own competing apps.
Online quiz HQ Trivia is back to give out money, take your mind off COVID-19
Updated 03/30/2020 – If you’re looking for fun ways to pass time during this coronavirus pandemic, there’s good news. The once-popular HQ Trivia app that closed shop in February is back online with new investors. Its most recent host, Matt Richards, announced the trivia app is back this weekend on Twitter and said if you’ve been waiting to cash out, you’ll be able to this week.