Struggling with Excel? 3 tips and tutorials to help you out

Ah, Excel. It’s been around since the ’80s, yet it can still stump many of us. There’s a lot to learn, from creating complex formulas to navigating pivot tables.

So, where do you turn? You can buy a paid course, which will give you a lot of bang for your buck, but you can also start smaller — and free.

Here are a few resources to get you started. This tip is sponsored by Oracle NetSuite, the world’s No. 1 cloud business system.

1. Clean up your data

The first rule of Excel: The cleaner your data, the better. There are countless ways typos, spaces and odd characters can gum up the works. Tap or click here for a great resource from Microsoft: The top ways to clean up your data. You’ll find a list of the most common mistakes and steps for cleaning them up.

2. Watch some high-quality tutorials

Seeing a program in use is much easier than reading about it. YouTube is great for this, and many high-quality channels are out there. MotionTraining has a great beginner’s series and videos that cover all the basics. TeachExcel is a popular channel with 169,000 subscribers and quick videos on just about anything you want to be done in Excel.

3. Find templates to do the work for you

There are lots of pre-made templates you can download right from Microsoft. Downloading from the source is nice because you know they are safe to use and will get the job done. Tap or click to see Microsoft’s offerings, from nutritional recipe calculators to finance balance sheets.

Bonus: For your financials, move to software that makes the job easy.

If you’re a business owner, you don’t need me to tell you running a business is challenging. Don’t let QuickBooks and spreadsheets slow you down, and stop paying for multiple systems that don’t give you the information you need when you need it. It’s time to upgrade to NetSuite by Oracle.

NetSuite gives you visibility and control over your financials, HR, inventory, e-commerce and more — all in one place — instantaneously. Whether you’re doing a million or hundreds of millions in revenue, save time and money with NetSuite. Join the over 24,000 companies using NetSuite right now!

Continue reading

Tech cleanup: Files and folders taking valuable storage from your PC

It happens. The longer we keep our devices, the more cluttered they become.

Open your phone’s app tray for a great example. How many are sitting there that you haven’t opened in months or years? This clutter isn’t just annoying — it can be dangerous, too. Tap or click to delete apps you’re not using.

Continue reading

Excel error codes? Here's the fix

Open/download audio

Do you use spreadsheets a lot? I bet you’ve seen your fair share of error codes. Try these easy one-minute fixes.

Learn more about your ad choices. Visit megaphone.fm/adchoices

📩 Your inbox isn’t safe: Hackers are sending sneaky phishing emails with SVG image attachments that slip past spam detectors. They open in a fake Excel spreadsheet with a built-in login form to steal your credentials. Others pose as official documents, prompting you to download something — but it’s malware. Never click on attachments unless you’re 1,000% sure they’re legit.

40 years (almost!)

That’s how long Microsoft Excel has been around. It’s come a long way from a clunky, black-and-white number cruncher to an AI-powered spreadsheet wizard. It’s crazy to think an estimated 1.1 billion people now excel at using it.

Tech how-to: 5 ways to share files too big to email

Our cameras take fabulous photos and videos. Our computers tackle data-packed spreadsheets. We can create detailed graphics that look incredible when blown up. But all of that comes with a drawback: huge files.

First, you need to make sure your computer, tablet or smartphone has enough storage to handle those files. Tap or click here for a quick trick to free up more space.

Continue reading

5 ways to share files that are too big to email

We all have file-size problems. Our cameras now take fabulous photos and crisp videos. Our computers can tackle monstrous spreadsheets. But all of that comes with a drawback: really huge files. So what do you do when you want to send that pile of digital photos to grandma, but the file is too big to attach to an email? In this tip, I’m sharing five ways to handle it.

Continue reading

Microsoft's easy-to-use new app combines Word, Excel and PowerPoint

Microsoft recently launched the Microsoft Office app for Android, which includes Word, Excel and PowerPoint. It’s free to use and download, but the premium features will cost you. If you’re on a strict budget, tap or click here to learn more about how you can get Microsoft Office for free.

Continue reading