Rad sa guglovim tabelama
Ne bi bilo pametno reći da su Excel i Gugl tabele (Google Sheets) isti programi. Oni jesu za slične poslove, ali Microsoft Excel je sada veoma moćan alat za rad sa podacima. Moćni dodaci (Power Pivot, Power Query, Power BI itd.) povećavaju obim rada sa podacima do neslućenih razmera. Rad sa guglovim tabelama fje postao nezaobilazan za većinu korisnika obrade podataka u tabelama.
Skoro da ne postoji čovek u poslovnom svetu da pored fensi Apple iPhone telefona nema Android telefon ako je “pametni telefon” uopšte telefon.
U čemu je razlika?
Oba programa su namenjena radu sa podacima i u dobrom delu se preklapaju, to u stvari znači da mnoge poslove možete obaviti u jednom programu i preuzeti ga u drugi program radi dovržavanja rada, možda sa funkcijama koje nema u prvom programu. To može biti UNIQE, FILTER, GOOGLETRANSLATE itd. Upotrebom Gugl tabela ću se baviti u narednim postovima.
Sada ću samo navesti ono što je gotovo identično za oba programa: rad sa formulama, dijagrami, pivot tabele, uslovno formatiranje, makro naredbe, filteri, slajseri itd.
Za najveći broj korisnika to je više nego dovoljno.
Ono što bi moglo biti zanimljivo je svakako GOOGLETRANSLATE formula kao i veoma moćni SQL upiti upotrebom QUERY formule.[:en]It would not be wise to say that Excel and Google Sheets are the same programs. They are for similar jobs, but Microsoft Excel is now a very powerful tool for working with data. Powerful add-ons (Power Pivot, Power Query, Power BI, etc.) increase the volume of work with data to unprecedented proportions.
There is almost no person in the business world who, in addition to the fancy Apple iPhone, does not have an Android phone if the “smartphone” is a phone at all.
Where is the difference?
Both programs are designed to work with data and overlap in large part, which actually means that you can do many jobs in one program and download it to another program to complete the work, perhaps with functions that are not in the first program. It can be UNIQE, FILTER, GOOGLETRANSLATE, etc. I will deal with the use of Google spreadsheets in the following posts.
Now I will only list what is almost identical for both programs: working with formulas, diagrams, pivot tables, conditional formatting, macro commands, filters, slicers, etc.
For most users it is more than enough.[:]