Techsloading839

Most Excel users don’t realize there’s a whole world of spreadsheet add-ins just itching to make their jobs — and lives — so much easier.

• Excel On Mac Free
• Microsoft Excel For Mac
• How To Add Cells In Excel

Open the Add-ins Menu in Excel. Select the Tools menu in menu bar. Select the Add-Ins option. Open every large Excel file on a separate “instance”; i.e. Open up a new session of Excel for each workbook. The memory limitation in Excel is for every instance and not for the entire application. Opening every file on a separate instance gives you dedicated 2GB memory rather than shared. Question: Q: excel spreadsheets reversed and upside down after installing mac os catalina More Less Apple Footer This site contains user submitted content, comments and opinions and is for informational purposes only. The user can point the Microsoft PowerApps Office Add-in at different servers to allow workbook and document portability between environments, or to facilitate sharing between customers. A Microsoft PowerApps environment and corresponding user account are required. Office 2016 is required for this add-in because of Add-in API requirements.

There are add-ins to boost your productivity, and even add snazzy visualizations to make your spreadsheets stand out from the snoozefests you’re used to. Others can help you run your business more effectively, study smarter, and save time analyzing your data.

Free Excel crash course

Learn Excel essentials fast with this FREE course. Get your certificate today!

To help you navigate all these awesome options, today we’ll be exploring the top 50 (mostly free) Excel add-ins together, broken down into 8 categories:

You can quickly jump around to the add-ins you specifically need, but we highly encourage you to read our guide in its entirety so you can discover all the add-ins you’ve been missing out on.

Boost productivity

To start, let’s jump right in with the top 5 Excel add-ins to make you more productive.

1. If you’re looking to up your productivity game, become more organized, and crush all your business goals this year, the Power User Excel add-in has your name on it.
2. Keep in mind, Power User is better suited for freelancers in the marketing and consulting spaces. For those in finance, Macabacus has features designed with your specific business needs in mind.
3. Duplicate Finder and Deleter can help you save a ton of time by finding all your duplicate spreadsheets and automatically deleting them for you. This frees up both time for you and space on your drive.
4. With this mail add-in, you can choose to send bits and pieces of your spreadsheets or the entire shebang via email.
5. ASAP Utilities helps you accomplish more with Excel by giving you time-saving shortcuts. According to their site, the average user saves an average of 30 hours per year!

Visually jazz up your spreadsheets

Keeping your charts organized and easy to understand will also help you shave time off your busy day. Here are the best Excel add-ins to up your spreadsheet game.

6. Labeling your charts is one of the best ways to make your data easy to understand. Use this chart labeler Excel add-in and your charts will be way less confusing.
7. Insert a map right into your spreadsheets to plot locations and visualize data with this Bing Maps add-in.
8. And if you’re looking to add images instead, this Pickit Free Images add-in can help you. This add-in came in second place at the 2017 Office App awards in the Best Overall App category.
9. For readers needing to add videos to their spreadsheets, reach for this Web Video Player add-in.
10. This Geographic Heat Map add-in helps you organize parts of the world using different colors so you’ll have a better understanding of where everything is spatially. This guide walks you through creating your first map.
11. If you need to merge a few of your tables, use this add-in.
12. Adding a pop of color here and there can also help keep your spreadsheets organized. This Colorizer add-in was designed to give you the flexibility to do just that.

Create unique charts not found in Excel

Ever want to take your Excel charts to the next level? Say hello to the add-ins that make those boring standard charts a relic of the past.

13. Radial charts help present data in a visually interesting way. If you’re already using a pie chart style, consider switching to this add-in to create a radial bar chart instead.
14. Bubble-style charts can also break up the monotony of traditionally styled charts.
15. Organizational charts are great for letting everyone on the team know who’s responsible for what. If you need one for your company, use this HierView add-in instead of wasting time creating your own.
16. Gauge charts can also help you visualize data like a speedometer and usually only measure certain levels of one data point. If this sounds like a chart you need, reach for this add-in.

Want to learn more?

Take your Excel skills to the next level with our comprehensive (and free) ebook!

Study more efficiently and give better presentations

The next set of add-ins will help you study more efficiently and give your presentations the boost they need.

17. If staring at a blank page makes you zone out and off the screen, consider the Quick Notes add-in. This nifty tool uses a mosaic template to nudge you towards getting started.
18. For students who prefer creating flashcards to study, why not switch to a digital form that you can easily access, edit, and share? This Flash Card Assistant add-in will give your writing hand a much needed break while still giving your brain the exercise it needs to retain important information.
19. Brush up on your Excel skills with the Excel Training and Tips add-in. Get free access to the 'how-to' cheat sheets from the popular GoSkills Excel course. Learn formulas, functions and more right within your spreadsheet.
20. If you struggle with organizing huge amounts of data, let this Mind Map add-in make things easier to understand and stop beating yourself up.
21. When it comes time to give your next presentation, consider using a Lucid chart to make all your data visually appealing, easier to read, and grab your audience’s attention.
22. Putting your data into visuals can also help you comprehend large, complex topics.

Manage and simplify finances

The next bunch of Excel add-ins makes the chore of managing your finances less overwhelming.

23. If simplifying finance spreadsheets is what you’re after, this financial reporting add-in wants to help. It even lets you keep track of your spending thanks to real-time updates.
24. For readers who need to manage their checkbooks, skip the old fashioned method and use Checkbook assistant instead.
25. You can also build and test your trading strategies before spending a dime on actual trades with this Excel add-in.
26. And if you’re looking to create trade systems or conduct a technical analysis, this Analyzer XL add-in promises to help you do just that.
27. The Analystix financial analysis add-in simplifies calculations such as weighted average cost of capital (WACC) and compound annual growth rate (CAGR).
28. To optimize your portfolio without the help of a professional, grab this add-in.
29. You can also use this one to download price data on different securities.
30. Applying for and understanding how a loan works can be tricky. Luckily, this Loan Assistant add-in should simplify the process for you.
31. The same confusion can happen any time you try to convert different currencies. But with the help of this currency conversion add-in, all the hard work is done for you so you can enjoy your trip.

Optimize marketing and branding

Hoping to improve your marketing and branding efforts? You don’t want to miss this next group of Excel add-ins.

32. It’s a pain to keep setting up your branding colors every time you need to create or use a spreadsheet. This add-in saves your company’s colors so you don’t have to waste time doing this task repeatedly.
33. SEO Gadget is an Excel add-in that helps you organize all your SEO data in one central location so you can instantly see how your site is performing. If you're looking to up your SEO game, check out these actionable SEO tips for startups.
34. And if you need SEO tools to actually get the job done, this add-in is for you.
35. Use the Excellent Analytics add-in to import your Google Analytics marketing data into a spreadsheet.
36. You can even create QR Barcodes in Excel thanks to this add-in.

Analyze data more efficiently

If you’re also looking to analyze your business as a whole (and not just your marketing efforts), the next set of add-ins has you covered.

37. The Analysis ToolPak was designed with engineers in mind. It will help you develop statistical analyses that go well beyond the basics.
38. This Solver add-in helps you uncover solutions that fall within the constraints of the problem at hand.
39. If you’re simply trying to analyze your data, enable the PowerPivot add-in built into Excel 2016 and 2013. Or install this version if you’re using Excel 2010.
40. The Spreadsheet Studio add-in has a set of tools that allow you to better analyze the structure and formulas in your workbooks.
41. Forecasting is also made simple with the help of the data mining Forecast Wizard add-in.
42. PowerApps helps you connect the dots between data points and gives you the ability to share these findings with your team.
43. Another similar tool lets your team datamine more efficiently. It helps everyone recognize patterns within tasks so the job takes less time.
44. This risk analysis add-in uses Monte Carlo simulation to help you assess your risks.

Miscellaneous Excel add-ins

Curious about all the other add-ins we haven’t categorized yet? The next add-ins will help you in a variety of different ways.

45. If your chess club needs help ranking its members, use this free Excel add-in to do just that.
46. And if you’re looking to create a place to keep all of your favorite directories and workbooks, use this Bookmarks add-in.
47. Looking for a way to hunt down economic information quickly and efficiently? Use the FRED Excel add-in to significantly cut down your research time.
48. Work with multiple documents within a single window with the Office Tabs add-in.
49. If you need to break down units of time into easier-to-understand smaller ones, reach for the Time Dimension add-in.
50. And if you’re ever struggling to come up with a bunch of random numbers, this tool can help you waste less time.

Start using Excel add-ins today

By taking advantage of one (or more) of these Excel add-ins, you’ll not only save a ton of time in your super hectic day, you and your spreadsheets will become ultra-effective, mega efficient all stars.

Whether you’re looking to create a better presentation or study smarter for finals, this list has every add-in you could possibly need. To up the ante further, check out our compilation of the best Excel templates.

So feel free to share this resource with everyone you know struggling with their spreadsheets and they’ll thank you for improving their productivity as well!

Wanna take your spreadsheet game to the next level? Try our Excel in an Hour course to learn fundamentals skills that will save you time and boost your productivity.

Free Excel crash course

Learn Excel essentials fast with this FREE course. Get your certificate today!

If you are getting error messages like 'error in module 1', 'unspecified error', or 'undefined reference', the problem is not with our add-ins! It is a problem with the installation of Office. Random Excel crashes, especially when Excel is closing, are also an indication of a bad installation of Office.

• We have tracked some crashes of Excel 2010 and above to still having Excel 2003 on the PC and Excel 2003 being corrupted. Do the repair on all releases of Office you have, even if you are not using a particular release and just kept it installed.
• Another cause we have found for random crashes are partially corrupt workbooks. How do they get corrupt? More ways than one to count. One we have noticed is corrupt workbooks made outside of Excel. Sometimes they work fine. Sometimes they done. The solution in this case is to realize it is workbook dependent. Then, the solution is to create new workbooks. And doing copying of sheets to a new workbook is not the solution. Do copy and paste special values, and recreate formulas and graphs.
• The number one cause is still a bad or corrupt installation of Office, which the steps below provide solutions.

Excel On Mac Free

The following are the steps to take to do the fix this problem by fixing Microsoft Office. Keys to fixing Excel are:

• Do the multiple reboots as instructed. A royal pain, but essential.
• Run the Temp File Deleter, all options, multiple times, as instructed.
• After rebooting, never open Excel or any other Office programuntil instructed to do so. Opening Outlook to do a quick check of your mail during the process will screw up the fixes. The same goes for Power Point to fix a presentation, etc. Office programs use common files. Opening any part of the Office Suite may prevent the steps from working.
• Do the repair of Excel last. Do not skip it.

If the message you are getting is an out of memory error or not enough resources, then either you do not have enough memory on your PC, you are running too many programs, multiple instances of Excel, or have many COM or VBA add-ins installed. See memory problems for how to fix.

REPAIR STEPS BY EXCEL VERSION

Window 10 and Office 365 or Office 2016, Excel 2019

• Reboot (important!) - this insures any file used by Office is fully released.
• Right click on the Windows start button, and select Control Panel, Programs and Settings.
• Find Office and either click on it and then Change up at the top, or right click and select Change.
• A repair options dialog will appear. There is both a quick repair and an online repair.
• Do the quick repair, Open Excel and see if all is fixed.
• If not, close Excel and do the online repair
  

Excel 2013 / Office 365

• Reboot (important!) - this insures any file used by Office is fully released.
• Open Excel
• Click File, Account
• In the right-side panel that appears, on the right side is the setting of your Office update. Confirm that it is set to update automatically. If not, click the button there and set to update automatically.
• If you had to change the button to update automatically, let it run any update.
• If you had to run an update, close and re-open Excel and then see if the problem is fixed.
• If the problem is not fixed, then:
  • Reboot AGAIN (important!) - this insures any file used by Office is fully released.
  • Go to Programs and Features in Settings, Control Panel
  • Right click on Office 2013 and select 'Change' (do not double click as that presents only the option to un-install)
  • You are presented with two options: A quick repair or an online repair. Try the quick repair first. If it does not solve, then reboot again and do the online repair. Do not skip the reboot!

Excel 2010 Users:

Microsoft Excel For Mac

• Reboot (important!) - this insures any file used by Office is fully released.
• Run the Temp File Deleter, all options. Do not open Excel or any Office program until instructed.
• Install Service Pack 2 for Office 2010. For some users, the Service Pack will not recognize your version. We have posted this issue to Microsoft and are hoping for resolution. If you cannot install, do the Control Panel/Repair steps below then try to run the service pack.
  • SP2 32 bit version (most users):
• Run the Temp File Deleter again
• Go to the Control Panel. If Windows XP, open Add/Remove Programs. If Windows 7, it is Programs and Features
• Right click on Office 2010 and run the Repair or Change option (sometimes service packs do not do a perfect job)
• Open Excel and all should work fine

Excel 2007 Users:

• Reboot (important!) - this insures any file used by Office is fully released.
• Run the Temp File Deleter, all options. Do not open Excel or any Office program until instructed.
• Install the latest service pack, SP3. Service Pack 3 (SP3) for Office 2007. Do from this link. Do not Open Excel.
• Reboot again!
• Run the Temp File Deleter again, all options. Do not open Excel before running the Temp File Deleter again.
• Do a Repair of Excel:
  • Re-open Excel for the first time
  • Click the Office Button, Excel Options, and Resources again
  • To the right of 'run Microsoft Office Diagnostics', click the button 'Diagnose'.
  • If Office advises that Diagnostics were recently run, click the button 'Run Diagnostics Again'. Installing any service pack or upgrade almost always causes bugs in Office. Even though Diagnostics may report that no problems were found, it will find and fix some problems (we've seen it happen).
  • If a description of why you should run Diagnostics appears, click the Continue button
  • Close the Resources dialog and Excel as soon as a Microsoft Office Diagnostics screen appears. This will not close the Diagnostics screen. Then click the Run Diagnostics button. If a choice of diagnostics to be run is given, select all of them.

How To Add Cells In Excel

Excel 2003 Users:

• Reboot (important!) - this insures any file used by Office is fully released.
• Run the Temp File Deleter, all options. Do not open Excel or any Office program until instructed.
• Install the latest service pack, SP3. Service Pack 3 (SP3) for Office 2003
• Reboot
• Run the Temp File Deleter again, all options. Do not open Excel before running the Temp File Deleter again.
• Do a repair of Excel:
  • Open Excel
  • Select Help, Detect and Repair.
  • A dialog will appear with an option to restore your shortcuts. Make certain it is checked.
  • Click the start button on this dialog. Even though repair may report that no problems were found, it will find and fix some problems (we've seen it happen).

If all the above fails, re-install of Office. To maximize your chance of success, do it this way:

• Make certain you have your CDs and license keys before doing these steps.
• Reboot (important!) - this insures any file used by Office is fully released.
• Go to Control Panel, Select Office and un-install Office (do not re-open any part of Office after the reboot).
  • Excel 2013 users: Un-installing may result in a lost license and Microsoft will not replace. Contact them first.
• Reboot again (this finishes the un-install).
• Run the Temp File Deleter. Run all the options. Run after the reboot.
• Reboot again. Yes, again! Reboots insure your PC is clear of any residual actions from the above.
• Do another complete un-install (yes another uninstall) using the un-install optionsfound at this Microsoft page. Use Option 2 is far easier than Option 1.
• Re-install Office. Do not open Excel, Outlook, or any part of Office when done.
• Reboot again and run the Temp File Deleter a second time. Run all options.
• Do not open Excel or any part of Office. Install the latest service pack per above instructions. (it was removed when Office was removed).
• Reboot again. Do not open Excel or any part of Office. Run the Temp File Deleter a third time. Run all options.
• Open Excel. for the first time and immediately do a repair of Excel (per instructions above).
• Close Excel.
• Re-install the add-ins.
• Open Excel and see if the add-ins work.
• If the add-ins still do not work, reboot again and run the Temp File Deleter a third time. Run all options.
• Run Windows Update. This will see if Microsoft has released any special fixes for Office and Excel that are needed on your PC.
• See if the add-ins work.

If the above does not solve:

• If one of our products, let us know. We will work with you to fix even though it is an Office problem. We can connect, with your permission, to your PC and hopefully determine the cause and hopefully fix.
  
• If the problem is caused by another vendor's products, ask them if they have an upgrade to the product you purchased.