What exactly can Excel do that LibreOffice Calc cannot do?

Asked by Last Modified  

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

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

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

View 1 more Answers

Related Questions

How many days it will take to complete advance excel course?

The duration to complete any kind, of course, depends on your grasping power and the ability to learn the concepts quickly. Having said that, it usually takes about three to four weeks to learn the topics...
Amit
Hi I want to use conditional formatting for 4 cell and where they have - value too. So, I want anything in the range which are in - in a colour and positive in one single colour. How can that happen so can anyone please help me on it?
1. First you have to select the range of cells where you want to apply conditional formatting 2. You have to select conditional formatting from Home tab in Excel window 3. There will be many categories,...
Charan
What does the VLOOKUP in MS Excel function do?
Basically, VLOOKUP lets you search for specific information in your spreadsheet. For example, if you have a list of products with prices, you could search for the price of a specific item.
Nayana
1 0
5
Can a person learn advanced level MS Excel through YouTube videos?
You can learn MS Excel on Youtube. Whether you are a complete beginner or advanced user of Excel, there are several video tutorials available at every skill level. They teach you everything by making you...
Ramkumar
0 0
7
Which course can be related to MIS executives, Since I have past experience in data base related job I want to try for MIS profile. So kindly suggest me which course suits me for the same profile.
Hi, You can check our course - Analyse and Visualize with Excel. Excel is the most popular tools used by analyst and MIS manager for getting insights from data. Create powerful Dashboards to enable data driven decision making.
Martin

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

Ask a Question

Related Lessons

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...

Conditional formatting with formulas
Conditional formatting quickly formats information in a spreadsheet. But sometimes the biult in rules are not enough. Adding your own formula to a conditional formatting rule gives it a power to help you do custom things.


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...

Recommended Articles

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 >

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 >

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 >

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 >

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