Ah, Excel. It’s been around since the ’80s, and yet it can still stump many of us. From creating complex formulas to navigating pivot tables, there’s a lot to learn.
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
Sometimes, seeing a program in use is a lot easier than reading about it. YouTube is great for this, and there are a ton of high-quality channels out there. MotionTraining has a great beginners 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 get 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 tough. 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 our sponsor, 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!