Every Legal Way to Use Excel for Free and Put It to Work
This guide covers how to use Excel for free, including Excel for Web, mobile, education, trials, and alternative tools. Follow along to create tables, use formulas, share files, and print.
Quick Fix — Get Started in 5 Steps
- Sign in to office.com with a free Microsoft account
- Create a new workbook in Excel for Web
- Paste sample data, then press
Ctrl+Tto create a table - Practice key formulas (XLOOKUP, FILTER, and Amount calculations)
- Share or download the file (PDF, .xlsx)
5 Legal Ways to Use Excel for Free
Excel for Web (office.com)
Use it in your browser with no installation required. Supports AutoSave, version history, and co-authoring.
Excel Mobile App
For basic editing, reviewing, and camera-to-table recognition.
Education or Organization Licenses
Free access may be available through an account provided by your school, library, or company, depending on its policy.
Microsoft 365 Trial
Useful for short-term projects. Back up your files before the trial period ends.
Free Alternatives
Use a hybrid workflow with Google Sheets and LibreOffice.
Excel for Web Practical Tutorial
New Workbooks, AutoSave, and Version Recovery
Set a file name → turn on OneDrive AutoSave → File > Info > Version History.
Tables and Functions
=[@Qty]*[@UnitPrice]
=SUMIFS(tbSales[Amount], tbSales[Category], "IT", tbSales[Qty], ">=2")
=FILTER(tbSales, (tbSales[Category]="IT")*(tbSales[Qty]>=2))
=XLOOKUP("Mouse", tbSales[Item], tbSales[Amount], "N/A")
=INDEX($B$2:$B$6, XMATCH(150, $A$2:$A$6, -1))
Charts, Conditional Formatting, and Data Validation
Insert > Charts, Home > Conditional Formatting, Data > Data Validation.
Co-authoring, Comments, and Permissions
Set sharing link permissions (view/edit), then select Review > New Comment.
Exporting PDF/CSV Files and Using Templates
File > Download > PDF/CSV/Excel, or start quickly with a template.
Mobile Tips
Make files available offline and use camera-to-table recognition for faster entry.
Trial and Education License Checklist
- Set an expiration reminder and back up your data to OneDrive.
- Check external sharing policies.
Free Alternatives and a Hybrid Strategy
Download files from Sheets as .xlsx, then apply advanced features in Excel.
Troubleshooting
| Issue | Cause | Solution |
|---|---|---|
| File overwritten | Version history was not used | Use OneDrive AutoSave and Version History |
| Formula spill error | Not a table or a blocked spill range | Press Ctrl+T and clear space for the spill range |
| PDF printing is distorted | Paper or font issue | Adjust scaling and margins; use web-safe fonts |
| Co-authoring conflict | Permission settings | Check edit permissions and invite specific users |
| #N/A | Mixed blanks or formats | Use TRIM/VALUE and IFERROR |
| Incorrect approximate match | Sorting or mode error | Sort ascending and use XMATCH -1/1 |