What exactly can Excel do that LibreOffice Calc cannot do?

Asked by Last Modified  

3 Answers

+2 Basic Excel Advanced Excel

Follow 3
Answer

Please enter your answer

Microsoft Excel and LibreOffice Calc are comparable. Calc may not be as user-friendly as Excel, but in a lot of ways, it is notably more capable as it's oriented towards a complete set of features over ease of use. In fact, the compatibility between the two is rather high, but with a slightly different...
read more
Microsoft Excel and LibreOffice Calc are comparable. Calc may not be as user-friendly as Excel, but in a lot of ways, it is notably more capable as it's oriented towards a complete set of features over ease of use. In fact, the compatibility between the two is rather high, but with a slightly different user interface. These days Excel on-line creates files in the Open Document Format, should you not have installed a compatible version of Excel on your computer. There are, of course, differences for advanced users, but in terms of the apps doing the same thing differently, they are similar. LibreOffice cannot do MS Visual Basic but has its own version of Basic read less
Comments
Dislike Bookmark

Tutor

For the most part, Calc and Excel work the same way. If you're a light spreadsheet user, you probably won't notice much difference between the two. Both can do basic calculations, handle light math, and organize tables in a variety of ways. However, if you use a lot of Excel macros and programming, then...
read more
For the most part, Calc and Excel work the same way. If you're a light spreadsheet user, you probably won't notice much difference between the two. Both can do basic calculations, handle light math, and organize tables in a variety of ways. However, if you use a lot of Excel macros and programming, then you're going to struggle with Calc. The reason is that Calc has its own macro language and it's not always compatible with Excel's VBA format. This means if you're trying to switch over to Calc from Excel, you may need to redo a lot of your macros. That said, Calc macros do translate well to Excel—just not the other way around—so if you're just sending off your own spreadsheets to other people, Calc may suffice.The Bottom Line If you're new to spreadsheets or just a light user, Calc gets the job done. However, if you're working in an environment where you're sharing a lot of macros then you're best off sticking with Excel. Both of them are easy to get started with, support the same file formats, and offer a pretty close selection of features. Let me know if you have more questions. read less
Comments
Dislike Bookmark

Training Centre

MS-Excel is not the only spreadsheet application available. As you mentioend Calc is also spreadsheet application. But what make MS-Excel is famous and most used tool is:a) Handling complex calculations and data - Calc is for ligher userb) Power Pivotc) Interface to different database i.e. BI, MySQL,...
read more
MS-Excel is not the only spreadsheet application available. As you mentioend Calc is also spreadsheet application. But what make MS-Excel is famous and most used tool is:a) Handling complex calculations and data - Calc is for ligher userb) Power Pivotc) Interface to different database i.e. BI, MySQL, SQL & etc.And lots more. read less
Comments
Dislike Bookmark

View 1 more Answers

Related Questions

How can we convert date into days for any year?
Enter the DATE Select the cell with the returned date. Click the Home tab. Click Format Cells: Number in the Number group.
Sensoph
0 0
View Comments9
How can I learn MS Excel from the beginning to the advanced level, online?
you can take online or home tution training. from basic excel level to advanced excel.
Saisree
0 0
View Comments5
Make A Excel Software Challenge: To Track Time Records To Enhance Daily Output Of Staff
Through Time Sheets
Bikram Jeet
0 0
View Comments7
What are the top excel functions management consultants use?
there are more than 600 functions inbuilt in excel, with or without a add on. most consultants turn towards kudos its much simpler and GUI friendly as they wont have time to write complicated functions....
Md
0 0
View Comments6
Can you make a Software Base On Excel, that records Automatic Billing Information Just Like A POS System. Suppose our Customer requires following: An Excel Software for POS, with following functionalities: It should have an "Open List" for capturing product related information. It should have automatic bill numbering It should have Printable bill It should have a customer database form and recording It should take not more than 30 minutes of training to learn and operate Can you make that? How much time will it take to you to make it completely?
Maybe yes! I'll require a bit more information to deep dive in it.
Bikram Jeet
0 0
View Comments9

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

Excel Tip: VLOOKUP formula limitations
1. Vlookup is not case-sensitive 2. If Lookup value has duplicates in the lookup column, then it returns 1st found value 3. Vlookup cannot pull values which are on the left side from Lookup column 4....

Karthik Dale

0 0
View Comments0
Hidden Gems of MS Excel - Data Validation - Circle Invalid Data
Q) You apply Data Validation to a range of Cells. e.g. You apply Data Validation Drop-down List of 5 Indian Cities: Indore, Lucknow, Mumbai, New Delhi, Pune, to a range of Cells What if invalid data...

Ankur Sharma

3 1
View Comments0
VBA Function -
Using FORMAT Function in VBA we can modify the format of Numbers, Dates, Times & String. Syntax: FORMAT(expression, format, , ) 1. Formatting "Numbers" using FORMAT function in VBA SUB Format_Numbers() MsgBox...

Naga Satyanarayana Anantapalli

0 0
View Comments0
Vlookup is old, use Index Match function
Vlookup function has the below limitations. 1. The lookup range should always be on the right-hand side of the vlookup value. This is the biggest limitation. 2. If supposedly you need to look up a value...

Ayush Agarwal

0 0
View Comments0
PowerPivot For Excel
PowerPivot is an add-in for Microsoft Excel 2010 that enables you to import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous...

Itech Analytic Solutions

0 0
View Comments0

Recommended Articles

Why Should you Learn Microsoft Office

Microsoft Office is a very popular tool amongst students and C-Suite. Today, approximately 1.2 billion people across 140 countries use the office programme. It is used at home, schools and offices on a daily basis for organizing, handling and presenting data and information. Microsoft Office Suite offers programs that can...

Read full article >

What is Applications Engineering all about?

Applications engineering is a hot trend in the current IT market.  An applications engineer is responsible for designing and application of technology products relating to various aspects of computing. To accomplish this, he/she has to work collaboratively with the company’s manufacturing, marketing, sales, and customer...

Read full article >

Why Should you Become an IT Consultant

Information technology consultancy or Information technology consulting is a specialized field in which one can set their focus on providing advisory services to business firms on finding ways to use innovations in information technology to further their business and meet the objectives of the business. Not only does...

Read full article >

Learn Microsoft Excel

Microsoft Excel is an electronic spreadsheet tool which is commonly used for financial and statistical data processing. It has been developed by Microsoft and forms a major component of the widely used Microsoft Office. From individual users to the top IT companies, Excel is used worldwide. Excel is one of the most important...

Read full article >

Find Microsoft Excel Training classes near you
Microsoft Excel Training classes in Delhi
Microsoft Excel Training classes in Bangalore
Microsoft Excel Training classes in Mumbai
Microsoft Excel Training classes in Hyderabad
Microsoft Excel Training classes in Pune
Microsoft Excel Training classes in Chennai
Microsoft Excel Training classes in Gurgaon
Microsoft Excel Training classes in Kolkata
Microsoft Excel Training classes in Noida
Microsoft Excel Training classes in Ghaziabad

Looking for Microsoft Excel Training classes?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you