有哪些免費非常好用的excel插件值得下載使用?
插件Add-in的使用大大豐富了Excel的功能
There is no doubt about it – Excel is one powerful tool. However, it has does have its limitations. That is where add-ins come in to play. Microsoft has been kind enough to open its code base and allow third party developers to extend the functionality of Excel. These add-ins make data analysis and manipulation easier and have practical applications in the business world. Below you find a list of 50 useful paid and (mostly) free Excel add-ins that will help you with just about any endeavor you have.
Data Analysis
One of the classic add-ins for Excel is the Analysis Toolpak which does not come installed. (Mac installation instructions). Mac/PC, Multiple Editions.
The Excel Solver tool is another classic tool that requires extra unpacking (Mac directions). Mac/PC, Multiple Editions.
The PowerPivot turns excel into a business intelligence tool. PC, 2010/13.
Data Explorer is the newest data analysis tool and the preview is now available for download. PC, 2013.
There are not a ton of add-ins for Mac but StatPlus for Mac is a must have data analysis too. Mac 2008/11.
Run regressions with the classic Excel Analysis ToolPak.
Get Federal Reserve data with the FRED add-in. PC/Mac, Multiple Editions.
Need more data? Get US Crime Stats from Data.gov. PC, 2013.
SimTools and FormList add stats functions and procedures to perform Monte Carlo simulations and risk analysis. PC, Version 5 (old!) and later.
Need to make some forecasts? This Data Forecasting add-in can use several forcasting methods including moving average, exponential smoothing, regression and double exponential smoothing and comes with a template to experiment with.PC, 2003.
Need to generate some random numbers? Then check out this Random Number Generator. PC, 2013.
Need data? Get free U.S. crime stats from within Excel with this handy http://DATA.GOV add-in.
Presentation
Get visual with maps with the new Heat Map add-in. PC 2013.
Draw diagrams and flowcharts fast and easy with Lucid Charts. PC 2013.
Spice up your measure of progress with a gauge display. PC 2013.
Looking to get creative with the way you report your data? Try this Radial Bar Chart. PC 2013.
Show your data in a fun and interactive way with this Bubbles display add-in. PC 2013.
Bring your data to life with the Bubbles add-in.
Bring structure to your ideas with the click of a button with the Mind Mapper addin ($2.99). PC 2013.
Looking for a quick way to generate molecular structures? The Structure Viewer is a chemists dream. PC 2013.
GeoFlow is the newest addition to Microsoft Excel and adds complex data visualization to Excel. It』s not available yet but check out this preview. PC 2013.
Label chart data points with the XY Chart Labler. Mac/PC, Multiple Editions.
Do advanced data visualization with the soon to be launched GeoFlow add-in.
Investing
The Bing Finance add-in adds a finance pane to Excel that allows users to grab current stock prices and other metrics, and continually updates the worksheet. PC 2013.
Risk optimize your investments with this equity optimization add-in (comes with demo template). PC, Multiple Editions.
Download quotes and technical analysis metrics with AnalyzerXL (Starts at $49.95, free versions available for TDAmeritrade and Forex.com customers). PC, Multiple Editions.
Evaluate risk for investments for business projects with this Risk Analyzer ($49.95).PC, 2003.
Test Your Excel Skills
Powered by Interact
Business
The Excel Model Creator adds a wizard to Excel that will allow you to make models for almost any business situation including sales, financial statements, and asset modeling. PC, 2013.
Determine the best long term project with this Capital Budgeting add-in (comes with demo template). PC, Multiple Editions.
Manage projects, budgets, and collaborate with Mavenlink, the ultimate project management add-in. PC, 2013.
Track, analyze, and make re-ordering easy with the Inventory Analysis add-in. (comes with demo template). PC, Multiple Editions.
Create financial statements in no time with the Excel Model Creator.
Show context related tweets in the sidebar of your Excel sheet with ExTweet. PC, 2013.
Visualize, share, and mine Google Analytics add-in with Excellent Analytics. PC, 2007/10.
SEO Gadget has some cool add-ins for the Adwords API, Mozscape API, and Link Categorization. PC, Multiple Editions.
Do you use SEOlytics or Majestic SEO? Then check out Neil Bosma』s SEO Tools for Excel which integrates with those two services as well as Adwords and Google Analytics. PC, Multiple Editions.
Integrate QR codes into all your Excel docs with QR4Office. PC, 2013.
Scrape the Internet for SEO data with Neil Bosma』s free SEO Tools.
Personal
Balance your checkbook in Excel with this free Checkbook Assistant, PC, Multiple Editions.
Perform quick loan calculations and analysis with the Loan Assistant ($24.95). PC, Multiple Editions.
Make learning fun and easy with the free Flash Card Generator. PC, Multiple Editions.
Utilities Productivity Tools
ASAP Utilities ($49, free trial available) adds over 300 new functions to Excel, enough to fill up its own Ribbon and makes Excel easier to use. PC, Multiple Editions.
AbleBits Utility Pack ($99, free trial available) adds 20+ smart data manipulation tools. A handfull of these features are now free for Excel 2013. PC, Multiple Editions.
Macabus Productivity Tools ($9.95, freeware version available) adds almost 200 new functions including auditing, formatting, and modeling tools, including 130 new shortcuts. PC, Multiple Editions.
Need to slice, dice, and merge? Mr. Excel』s Easy-XL ($89, free trial available) adds over data analysis and manipulation tools. PC, 2010.
The DigDB Toolkit a ($78/year) adds 40 advanced data analysis tools to Excel. PC, 2007/10.
Not sure which one to pick? Then try out the free Power Pak from John Walkenbach』s The Spreadsheet Page. PC, Multiple Editions.
Have a Mac? Then try Ron de Bruin』s Power Pack for Mac 2011.
Convert standard measurements to metric with the Unit Converter, PC, 2013.
Quickly convert to any currency with the Exchange Rate Converter ($34.90). PC, 2000 and later.
Enter dates quicker with the Calendar entry add-in. PC 2013. (Mac versionavailable).
Merge cells with ease with AbleBits free add-ins for Excel 2013.
Organization
If you are in excel all the time this favorite workbooks bookmarker will help you get back to your most active workbooks quickly. PC, Multiple Editions.
Find, replace, or delete duplicates in massive spreadsheets with this Duplicate Finder ($24.95). PC, Multiple Editions.
BrushTools ($37) adds color to your spreadsheet to help you distinguish between input, formula, linked, and calculation cells. PC, 2007/10.
BrushTools brings Excel to life and helps discern between formula and input cells.
Find the differences between cell blocks with the DiffEnginex」s Select Diff Tool($1.99). PC, 2010.
Track, analyse, and display time dimensions with a few clicks with the Create Time Dimension add-in. PC, 2013.
Simple and easy emailing from Excel with RDBMail. (Mac version available). 2007 and later editions.
If you made it all the way through this list then this Add-in Manager will you manage all your new add-ins. PC, Multiple Editions.
Advanced Add-In Information
Discern the differences between COM and Automation Add-ins.
Can』t find the add-in you want? Then Build your own add-in.
If you can』t find the add-in you need, why not learn some Visual Basic and make your own?
Excel Just Became Easier!
If you are interested checking out more paid and free Excel add-ins, try the Microsoft App Store, Add-Ins.com ($), and OzGrids ($). Many data analysis tools and software platforms have their own add-ins such as Tableau, MATLAB, and Bloomberg so if you are working with a similar platform it is possible your provider has an add-in for you. If you love add-ins please share this page with your friends and bookmark our page to come back periodically as we plan to update the list whenever we find new and cool add-ins. If you are looking for Excel tools and resources than consider taking a peek at our Excel mega resource list which includes templates, apps, tutorials, and courses. Best of luck with your new add-ins!http://www.skilledup.com/learn/business-entrepreneurship/mostly-free-excel-add-ins/科學網—[轉載]50+ (Mostly) Free Excel Add-Ins For Any Task方方格子Excel工具箱,完全免費的,及其強大的excel插件
拋磚引玉,我給大家安利一個免費的插件叫Funfun,非常簡單易用,介紹戳這 https://www.funfun.io/1/msaddin
Funfun的核心功能是可以讓用戶在Excel裡面直接運行JavaScript的代碼,像這樣
如果你經常需要做數據可視化或者數據分析的話就知道,JavaScript裡面有很多很強大的第三方庫比如Chart.js, D3.js等等。有了Funfun,你就可以直接在Excel裡面調用這些庫,直接使用SpreadSheet裡面的數據來畫圖。比如這樣
上面的這些例子都是在Excel利用第三方的庫畫出來的(D3.js,HighChart.js),而且即便是在Excel中,這些可視化圖表也是可以交互的。這種類型的圖原本只用Excel之中是很難直接繪製的。上面這些只是例子,具體就是。。你能用JavaScript幹什麼,用Funfun就全部都能幹!
而且除了Excel中的插件之外,Funfun還有一個Online Editor,戳下面這個連接可以看
https://www.funfun.io/1/edit/5a365e7c74efa7334ff272a6
用Online Editor的好處是,你可以先在Online Editor上面寫好代碼,出好圖。等你有了想要效果之後,可以直接用Onlien Editor的鏈接把你的結果導入Excel當中,像下圖這樣
然後你的數據和代碼就直接導入了,按一下左上角的Run就可以直接把圖畫出來了。
經常用JavaScirpt和Excel做數據可視化的盆友可以試一試Funfun,以上。
推薦閱讀:
※為什麼excel不能正確處理utf8 csv?
※Excel里常見的錯誤值分別代表什麼意思?
※Excel 單元格中的下三角箭頭是做什麼用的?如何實現?
※python如何對excel表格指定內容查找?
TAG:MicrosoftExcel |