I am taking an excel course to learn how to be more proficient in Calc. For the most part things crossover relatively easy, but some do not. Since I am learning calc via excel courses I am looking for a reference or guide that that shows how to duplicate excel procedures in calc. Is there something like that available?
Thanks
Bill
Thanks to everyone who responded to my question. I think I may be trying to run before walking as far as learning this software. I will just keep watching videos, and following along with the procedures until I get more proficient.
Bill
1 Like
Take a look here in The Frugal Computer Guy’s Channel.
And in the Official Web site.
Hope it helps!
which ones?
I’m aware of 3 important differences:
- Excel has 3 data types: number, text and boolean plus formula result error whereas Calc’s booleans are formatted numbers. In Calc =TRUE()=1 => TRUE in Excel =TRUE()=1 => FALSE because TRUE is a different data type.
- Excel’s sheet separator is ! whereas Calc uses the point.
- For cell functions working differently, Calc has an Excel version of the respective function, for instance PERCENTILE.EXC which is used instead of PERCENTILE when you load some xls(x) document.
I am very new with spreadsheets, I have learned simple functions and layout stuff. I am going through a course on udemy.com and he brought up a window called “function arguments” which basically tells how the function works, proper syntax when entering and identifies errors. This is what I was specifically referring to in my post.
Thanks
Bill
This is the same in Calc and Excel.
=FUNCTION_NAME(arg1;arg2;arg3)
or
=FUNCTION_NAME(arg1,arg2,arg3)
The variant with the semicolon as argument separator always works in Calc. In Excel it works with certain language versions only.
The variant with the commas works if your decimal separator is not comma. In Excel the comma works with language versions where the decimal separator is not comma.
German Excel books teach the first variant because 3,14 is a decimal. English Excel books teach the second variant. In Calc you can switch the locale setting independently from the user interface.
So, if your tutorial is for English Excel, goto Tools>Options>LanguageSetting>Languages and make sure that the locale (2nd option) is English.
Maybe the Function Wizard (Ctrl+F2, or menu Insert - Function).