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.
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. |
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.
Just like that, you’ll be able to reformat your data.
Microsoft Office has been around for a long time, and understandably, people love the familiarity with its applications. But it is expensive.
As more businesses and educational institutes switch to Google programs such as Docs and Sheets, it can’t hurt to check them out. And you can save money by switching.
💺 Pick the right office chair: Choose one with adjustable seat height and tilt functions for good posture, aka a happy back. Lumbar support is nice for maintaining the natural curve of your spine. FYI: Pricey “gaming” chairs are often overrated. Get an ergonomic office chair instead; they’re built for long-term comfort.
We may receive a commission when you buy through our links, but our reporting and recommendations are always independent and objective.
Netflix is arguably the biggest streaming platform globally, with just over 220 million users. The U.S. and Canada make up a big slice of the userbase, collectively accounting for 75 million. At $15 per month for a standard subscription, that is a sizeable revenue.
Keeping your operating system updated to the latest version ensures that you get new functions and security patches. But while it isn’t strange to have a few hiccups along the way, you don’t expect the new OS to stop your computer from working.
