First, a reality check on "free"
Only two of the five are third-party. Vertex42 makes Mini Calendar and Date Picker, and Frontline Systems makes Solver. People Graph is published by Microsoft Corporation, according to its Microsoft Marketplace listing. The Analysis ToolPak and Power Pivot are Microsoft features.
Microsoft's support page says Solver is available when you install Office or Excel, though you have to load it first. Microsoft also calls Solver a free add-in. That wording is easy to misread, so it's worth stating plainly. "Free" here means no extra charge. It does not mean every add-in works on every edition and platform.
Phillips's closing advice is sound: check the price, look into the developer, and see whether Power Query already does the job before you install anything else.
1. Mini Calendar and Date Picker: point-and-click dates
Phillips says Excel for the web lets you double-click a date-formatted cell to open a calendar. He says desktop Excel has no such feature "at the time of writing". This add-in fills that gap.
Microsoft's Marketplace listing describes it as a small monthly calendar embedded in the sheet. You use it to enter a date or the current time into the selected cell. The listing also says you can:
- highlight dates by selecting a range in the spreadsheet
- toggle the calendar's size
- show week numbers
- switch between U.S. and ISO calendar systems
- pick a theme such as blue or green
Phillips adds that it applies a date number format to the cell automatically.
How to install it: Open the Add-ins store from the Home tab, search for the add-in and click Add. Phillips notes the labels can vary by version.
Things to know:
- The listing says the add-in can read and change your document, and can send data over the Internet. That is standard for many Office add-ins. It is still worth a look if your workbooks hold sensitive data.
- Phillips lists Excel 2013 SP1 or later on Windows, Excel 2016 or later on Mac, and Excel for the web. I couldn't independently confirm those exact version numbers, so check the store listing for your build.
- A date picker saves typing. It is not a replacement for data validation. If a sheet must only accept dates in a certain range, set up validation rules separately.
2. People Graph: icon-based infographics
People Graph is a Microsoft add-in that turns two columns of data into a picture, with rows of small icons standing in for the numbers. The two columns are category labels and numeric values. The Marketplace listing says it offers three chart types, seven themes for each type and 16 shapes.
Phillips suggests using box icons to compare product sales, or money bags for revenue. He says the graphic updates when the data changes, but you must extend the range yourself if you add rows.
Things to know:
- The listing says People Graph can read and change the document and can send data over the Internet. If you handle confidential or regulated figures, check your organization's rules before you put them in an online-connected add-in. The listing doesn't say what data is sent or where it goes, so don't assume either way.
- Phillips warns that colleagues without the add-in may not see the same result. Test how the graphic looks for the people you share it with.
- Standard Excel charts remain the better choice for anything analytical. People Graph is for flair in reports and presentations.
3. Analysis ToolPak: statistics without writing formulas
Microsoft says the ToolPak saves steps on complex statistical or engineering analyses. You supply the data and parameters. Excel then calculates the result and shows it in an output table. Some tools also produce charts.
Microsoft's Windows add-ins guide names regression, histograms, sampling and z-tests. Phillips highlights several tools:
- Descriptive Statistics: one summary table covering mean, median, standard deviation, minimum and maximum.
- Correlation: how closely two variables move together.
- Moving Average: smooths short-term noise to show longer trends.
- Regression: how one variable relates to one or more others.
How to load it on Windows:
- Select File, then Options, then the Add-ins category.
- In the Manage box, choose Excel Add-ins and select Go.
- Check Analysis ToolPak and select OK.
- If it isn't listed, select Browse. If Excel says it isn't installed, select Yes to install it.
On Mac:
- Open the Tools menu and choose Excel Add-ins.
- Check Analysis ToolPak and select OK.
- Accept any install prompt, then quit and restart Excel.
What success looks like: a Data Analysis command appears on the Data tab.
Things to know:
- Microsoft's page says the data analysis functions work on one worksheet at a time. If you run them on grouped worksheets, results appear on the first sheet only. You must rerun the tool for each worksheet.
- Microsoft says some languages aren't supported, and the ToolPak shows in English in those cases.
- If you need the VBA functions, Microsoft says to load Analysis ToolPak - VBA the same way.
- Phillips stresses that results are static. If your source data changes, rerun the analysis. If you need a live number, use a formula instead.
- The ToolPak computes whatever method you pick. It won't tell you whether that method suits your data, and a correlation is not proof of cause.
Phillips gives Excel 2016 or later on Windows and Excel 2021 or later on Mac as the availability. Microsoft's current page lists Microsoft 365, Excel 2024 and Excel 2021 for both Windows and Mac. It doesn't confirm Phillips's minimum versions, so treat those as his claim.
4. Solver: optimization within limits
Microsoft describes Solver as a what-if analysis tool. It finds the best (maximum or minimum) value for a formula in an objective cell, subject to limits on other cells. Phillips contrasts it with Goal Seek, which adjusts one input to hit a target. Solver can change several values at once.
His example: you have $300 to split between paint, lighting and storage. Each category must get between $80 and $120. You assign each an improvement score per dollar, and Solver finds the allocation that gets the most benefit within the budget.
How to load it on Windows: Follow the same File, Options, Add-Ins, Excel Add-ins, Go steps as the ToolPak, and check Solver Add-in. Microsoft says the Solver command then appears in the Analysis group on the Data tab. On Mac, use Tools, then Excel Add-Ins, then check Solver.
Things to know:
- Microsoft states the Frontline Systems Solver isn't currently available for Excel on mobile devices.
- The answer is only as good as the model you give it. The improvement scores in the example are assumptions, and the result depends on them. Write down your objective and constraints so others can check them.
- Phillips lists Excel 2016 or later on Windows and Excel 2021 or later on Mac. Microsoft's page also lists Excel 2019 and Excel 2016 for Solver.
5. Power Pivot: modeling related tables
Microsoft calls Power Pivot an Excel add-in for powerful data analysis and sophisticated data models. It can pull in data from many sources and relate it. You can then build calculated columns and measures with formulas, and create PivotTables and PivotCharts.
Microsoft says it uses DAX, a formula language similar to Excel formulas. It adds that the model is stored in an analytical database inside the workbook. Power Pivot supports files up to 2 GB and up to 4 GB of data in memory.
Phillips's example: keep sales transactions in one table and product details in another. Link them with a shared ProductID, then build a PivotTable that summarizes sales by category. The Data Model also gives you Distinct Count, which counts unique customers rather than every transaction.
How to enable it on Windows:
- Select File, then Options, then Add-ins.
- In the Manage box, select COM Add-ins and then Go.
- Check Power Pivot and select OK.
- A Power Pivot tab should appear on the ribbon. Select Manage to open the Power Pivot window.
If the tab vanishes: Microsoft says Excel may disable the add-in if it decides it is destabilizing Excel. This can happen if Excel closes unexpectedly while the Power Pivot window is open. To restore it, go to File, Options, Add-Ins. Under Manage, choose Disabled Items and select Go. Then select Microsoft Office Power Pivot and select Enable.
Things to know:
- Phillips says it is not available on Mac. Microsoft Q&A answers I found agree that Power Pivot isn't currently available on Excel for Mac. One reply suggests the Power Query editor as an alternative for data gathering and shaping. Another says a Windows virtual machine is the workaround.
- Phillips says it is available on Excel 2016 select editions or later on Windows. Edition limits are real, so confirm your license includes it.
- In Microsoft's own comparison, Power Pivot lets you create hierarchies, KPIs and perspectives, which Excel doesn't. Excel itself can already hold a Data Model with relationships, so you don't always need the add-in for basic multi-table work.
- Power Query and Power Pivot do different jobs. Phillips puts it simply: Power Query helps you clean and prepare data, and Power Pivot helps you model and analyze it.
- Microsoft says you can't edit individual cells in a Power Pivot table. VBA isn't supported in the Power Pivot window.
Quick comparison
| Add-in | Best for | Maker | Updates automatically? | Platform caution |
|---|---|---|---|---|
| Mini Calendar and Date Picker | Entering dates | Vertex42 | Not applicable | Check store listing for your version |
| People Graph | Icon infographics | Microsoft | Yes, but you extend the range for new rows | Listing discloses Internet data sending |
| Analysis ToolPak | Statistical output | Microsoft | No, rerun it | Supports Windows and Mac |
| Solver | Constrained optimization | Frontline Systems | Rerun after changes | Not on mobile |
| Power Pivot | Related-table models | Microsoft | Refreshes with the Data Model | Not on Mac, edition limits |
I haven't tested any of these myself. The steps above come from Microsoft's documentation and Phillips's guide.
Sharing workbooks safely
Phillips's warning is the practical one. If you share a workbook that relies on an add-in, recipients without it may not get the same functionality. He singles out People Graph and Power Pivot. Before you send a model, check that the other person's Excel edition and platform can open it. Include a short note on which add-ins you used and why.
If your organization manages Office, ask IT which add-ins are approved. Some, like People Graph, send data over the Internet, and that may matter under your data-handling policy.
The bottom line
For most Windows users, the Analysis ToolPak, Solver and Power Pivot are the strongest picks. They are built for real analysis and come from the Office ecosystem. The calendar and People Graph are convenience tools. Pick by task, confirm your Excel edition supports it, and document your assumptions. Power Query remains the first stop for cleaning data.
References
- Excel is faster and easier when you combine it with these 5 free add-ins How-To Geek · 2026-10-22T17:30:17+00:00
- Excel for Mac - Power Pivot w Office 365 Subscription - Microsoft Q&A learn.microsoft.com
- Load the Analysis ToolPak in Excel | Microsoft Support support.microsoft.com