Spreadsheets are a part of the trendy enterprise world, and meaning sometime you are going to have to take a look at one. The sorts of options you want out of your spreadsheet software can fluctuate, although, with many customers by no means coming near needing the sturdy options of Microsoft Workplace’s Excel.
For these of us that are not accountants crunching numbers daily, Microsoft Workplace, which incorporates Excel, might be prohibitively costly. You are taking a look at paying $99 a yr for a enterprise person, $6.99 a month for dwelling use, or $149.99 for an Workplace Residence and Pupil 2019 license.
If you do not have that form of cash, or do not want these sorts of options, or just need to save money, there are many viable alternate options to Microsoft Excel which can be obtainable within the cloud and put in in your pc. Better of all, these alternate options are free.
SEE: IT budgeting: How you can do it proper (free PDF) (TechRepublic)
1. Google Sheets
Google Sheets is Google’s cloud-based reply to Microsoft Excel, and it is able to doing the overwhelming majority of what the typical Excel person wants. It is also hosted within the cloud and runs in an online browser, so it is platform unbiased and might be run on Home windows, macOS, and Linux techniques.
You by no means have to fret about shedding a single calculation, both—Google Sheets saves every thing in Google Drive, making a crashed pc of no concern to your essential knowledge.
As with Google’s different workplace instruments, Sheets options real-time collaboration that permits a number of customers to edit a doc on the similar time. Customers can see the cursor place of different folks within the doc, see what they’re doing as they’re doing it, and chat proper within the doc window.
Superior options that some Excel customers want are lacking, although, so should you’re an Excel energy person it is a good suggestion to search out out if the options you want can be found earlier than migrating. There have additionally been reported problems with formulation in Excel spreadsheets breaking once they’re uploaded to Google Sheets, so remember that you may run into points transferring .xls or .xlsx recordsdata out of your pc to Sheets.
SEE: How you can keep away from and overcome presentation glitches (free PDF) (TechRepublic)
2. Microsoft Workplace Excel On-line
To not be outdone by Google, Microsoft has created its personal on-line model of Workplace, which features a stripped-down model of Excel that’s higher in comparison with Google Sheets than to the desktop model of Excel.
It is to not say that Excel On-line is unusable or not value your time—it is undoubtedly extra like Excel than Google Sheets, so should you desire a well-known interface chances are you’ll need to go for Excel On-line as an alternative of going the Google route.
Recommending Excel On-line to the typical Excel person is ok—it does all of the fundamentals of the desktop model whereas including automated cloud saving in OneDrive, and it has real-time collaboration instruments that Workplace 365 and 2019 lack.
Excel energy customers could need to keep away from Excel On-line. A lot of the options you depend on are gone, restricted, or read-only—there is not any VBA scripting, no creating exterior knowledge connections, no discover and exchange, and no superior charting options. All of these capabilities exist in Excel On-line, however they’re read-only.
SEE: Price comparability calculator: G Suite vs. Workplace 365 (Tech Professional Analysis)
Three. Apache OpenOffice Calc
After I speak to Home windows customers who hate the look of Microsoft Workplace’s post-2007 interface, I all the time suggest Apache OpenOffice. Calc, OpenOffice’s Excel different, does an excellent job feeling and looking identical to Workplace 2003, which is nice should you’d desire a time earlier than the Workplace ribbon.
Previous to the appearance of the cloud and the dominance of Google’s on-line workplace instruments, OpenOffice reigned supreme amongst these on the lookout for a free Microsoft Workplace different. That is very true within the case of Calc, which retains many of the essential superior capabilities of Microsoft Excel, albeit in barely totally different varieties in some circumstances.
If you happen to’re an Excel energy person enthusiastic about migrating to OpenOffice, make sure you learn the person information—it’s going to assist you determine if the capabilities important in your work can be found in Calc; if they’re, you may need discovered your new favourite program.
There may be one main disadvantage to OpenOffice, which is a matter with different free platforms: An absence of cloud assist. There is not any native cloud connection or real-time collaboration for Calc, so if that is a deal-breaker, chances are you’ll need to keep away from this one.
four. LibreOffice Calc
Like OpenOffice, LibreOffice is a free workplace suite that features its personal Excel different, additionally referred to as Calc. It runs into the identical restrictions as OpenOffice, in that LibreOffice Calc lacks cloud assist and real-time collaboration.
What LibreOffice does have is a surprisingly sturdy checklist of options, lots of which are not even current in Excel.
LibreOffice has extra capabilities than Excel, can examine two separate spreadsheet recordsdata, has extra cell formatting choices, and it might even deal with imports of legacy spreadsheets from retired functions (Microsoft Works, Lotus 1-2-Three, BeagleWorks, Claris Resolve, and so forth.) previously obtainable on Home windows and macOS.
There are good causes to provide LibreOffice a attempt to good causes to not as effectively, which embody: It has restricted macro recording talents, it might’t deal with outdoors knowledge sources, it lacks the power to show many superior kinds of charts, and it might’t export paperwork as generic XML.
Earlier than attempting LibreOffice, learn the options checklist to make certain your necessities are included.
5. WPS Workplace Spreadsheets
In the case of sturdy options which can be a real competitors for Excel, WPS Workplace Spreadsheets can’t be beat and with good purpose: It is the one freemium product on this checklist. WPS Workplace is definitely a paid product, but it surely does include a fully-featured free model with one catch—it is advert supported.
Do not let that flip you off from giving WPS Spreadsheets a strive—the adverts are fast (typically lasting about 10 seconds), and solely pop up once you attempt to print, save to PDF, or use a few of its different extra particular instruments; when you watch an advert, that function is unlocked for 30 minutes.
If you happen to determine you need to do away with the adverts in WPS Workplace, you must pay $29.99 a yr, or $79.99 for a lifetime license. That is quite a bit lower than Microsoft’s Workplace pricing.
WPS stated it is 100% appropriate with Excel, that means it’s going to open all Excel paperwork appropriately, assist every thing they comprise, that means “you possibly can open and edit spreadsheets from others, after which save them proper from WPS Workplace figuring out others will have the ability to open them with none points.”
If you happen to’re involved about with the ability to discover sure options, or need to make certain one thing you utilize is supported in WPS Spreadsheets, take a look at the Spreadsheets assist matter on the WPS web site. I wasn’t capable of finding a handy chart of options like with OpenOffice and LibreOffice, however you must have the ability to discover what you are on the lookout for by looking out there.