GNU/Linux.chWie alt bist du?Die Berechnung des Alters ist nicht trivial. Es gibt mehrere Lösungen, die sich voneinander unterscheiden.
#excel
22 posts21 participants1 post today
I can't believe it. Microsoft seem to have removed the DD/MM/YY[YY] format for dates in Excel. I've been mostly using LibreOffice, is this a new bug in excel?
#excel #microsoft #windoze
#FreeOffice 2024 ist ein vollständig ausgestattetes Officepaket von #Softmaker und #kostenlos für #Windows #Mac & #Linux Kompatibel mit #Microsoft #Office #Word > #Textmaker #Excel > #Planmaker #PowerPoint > #Presentations www.freeoffice.com/de Forum: forum.softmaker.de #Unplugtrump #GoEuropean
Автоматизация сбора данных: как подтянуть курсы валютных пар ЦБ РФ
Во время расчёта доходности торговли валютными парами или акциями pre-IPO , для расчетов NPV и других финансовых показателей всегда нужны актуальные курсы валютных пар. Долгое время открывать сайт Центробанка РФ (ЦБ РФ) и копировать валютные курсы в Excel курсы ЦБ РФ становится лень – и тут на помощь приходят Excel и VBA. Наипростейшее решение – сделать в Excel выпадающий список с выбором валюты и написать макрос, который сам подтянет нужный курс с сайта ЦБ РФ . Тогда я смогу просто выбрать, например, USD или EUR , и таблица сама подставит актуальный курс в расчет. Звучит классно, пора делать.
ХабрАвтоматизация сбора данных: как подтянуть курсы валютных пар ЦБ РФПри расчёте доходности приобретения валютных пар и акций pre-IPO всегда нужны актуальные курсы валютных пар. Постоянно открывать сайт Центробанка РФ (ЦБ РФ) и копировать валютные курсы в Excel курсы...
![Task Excel Vs SQL VS Python Excel Load Data file Open File SELECT FROM table_nane; Python (Pandas) B10, SELECT Columns table Use column Letters read_csv("file.c Short df(df[ column'] Data SELECT colunnl, colunn2 100] Sort Aggregate ORDER Pivot Table DESC; colu GROUP Average Mean dept; =AVERAGE(B2:B100) aggo B100) Remove VG(salary) Data salary' Renove FROM nean( Join Tables sun() DISTINCT colunn table; LODKUP XLOOHUP FROM =B2 column JOIN ,drop_duplicates() df2, salary, salary*Đ. Manually 'bonus'] Missing Data colunn FROM table; IF(ISBLANK(A2), "N/A", Export File Save NULL, COALESCEO inplace=True) Visualization Insert or Charts SSMS) df.dropnaC) Not native; use f.to_csv("output. ,index=False) .plot(kind=" 'bar'), natplotLib](https://files.mastodon.social/cache/preview_cards/images/140/090/163/original/df732e503ecbf78e.jpg "Task Excel Vs SQL VS Python Excel Load Data file Open File SELECT FROM table_nane; Python (Pandas) B10, SELECT Columns table Use column Letters read_csv(\"file.c Short df(df[ column'] Data SELECT colunnl, colunn2 100] Sort Aggregate ORDER Pivot Table DESC; colu GROUP Average Mean dept; =AVERAGE(B2:B100) aggo B100) Remove VG(salary) Data salary' Renove FROM nean( Join Tables sun() DISTINCT colunn table; LODKUP XLOOHUP FROM =B2 column JOIN ,drop_duplicates() df2, salary, salary*Đ. Manually 'bonus'] Missing Data colunn FROM table; IF(ISBLANK(A2), \"N/A\", Export File Save NULL, COALESCEO inplace=True) Visualization Insert or Charts SSMS) df.dropnaC) Not native; use f.to_csv(\"output. ,index=False) .plot(kind=\" 'bar'), natplotLib")
www.facebook.comTask Excel Vs SQL VS Python Excel Load Data file Open File SELECT FROM table_nane; Python (Pandas) B10, SELECT Columns table Use column Letters read_csv("file.c Short df(df[ column'] Data SELECT colunnl, colunn2 100] Sort Aggregate ORDER Pivot Table DESC; colu GROUP Average Mean dept; =AVERAGE(B2:B100) aggo B100) Remove VG(salary) Data salary' Renove FROM nean( Join Tables sun() DISTINCT colunn table; LODKUP XLOOHUP FROM =B2 column JOIN ,drop_duplicates() df2, salary, salary*Đ. Manually 'bonus'] Missing Data colunn FROM table; IF(ISBLANK(A2), "N/A", Export File Save NULL, COALESCEO inplace=True) Visualization Insert or Charts SSMS) df.dropnaC) Not native; use f.to_csv("output. ,index=False) .plot(kind=" 'bar'), natplotLibDifference between Excel vs SQL vs Python✅
A free replacement for Microsoft Excel with many functions.
European MadeEuropean Made - Libre Office Calc, the Excel replacement you can count onOne of the most used software programs in the world is Excel by Microsoft. And for good reasons, it's a spreadsheet powerhouse with great features. Unfortu
¿Listo para dar el siguiente paso con Power Query? 
En esta segunda parte, veremos cómo empezar a usar esta increíble herramienta y por qué te ayudará a trabajar más rápido y mejor en Excel.
Te permite: 
Importar datos de diferentes fuentes. Organizar información de forma sencilla. crear tareas repetitivas.
Es solo el comienzo, pero ya estás en el camino correcto.
Sigue la serie y aprende paso a paso cómo dominar Power Query. 
#Excel #PowerQuery #Datos #Productividad
Does anyone know if it is possible to create a corolation chart in #Excel? I want to be able to agrogate some data that I've calculated in my head and be able to determine the average of different variables which I would use to get a clearer average for how many times an event occurs within a certain period of time. Sorry I have to be so vague,but this data is highly classified... at least to me and the person this data is meant for and I don't want a trace of it getting out.
butterfly symbol in MS Word #computer #shortcutkeys #butterfly
butterfly symbol in MS Word #computer #shortcutkeys #keyboard #excel #typing #butterfly #search #symbols #logo #office ... source
https://quadexcel.com/wp/butterfly-symbol-in-ms-word-computer-shortcutkeys-butterfly-2/
QuadExcel.com · butterfly symbol in MS Word #computer #shortcutkeys #butterfly - QuadExcel.combutterfly symbol in MS Word #computer #shortcutkeys #keyboard #excel #typing #butterfly #search #symbols #logo #office ... source
If you live in #Excel and haven't heard of #MonkeyTools, check it out. It's a productivity add-in for Excel. The free version contains most features, and it only manipulates native functionality, so other users will still be able to open your workbooks without issue: https://monkeytools.ca
Monkey ToolsWhat is Monkey Tools?Monkey Tools is an Excel add-in which will help you build better Data Models, faster. Our Free version contains a ton of useful tools, but you'll be truly amazed at how much productivity you can gain with our Pro version. If you use Power Query or Power Pivot, you need to explore this add-in today!
Outdated spreadsheets were slowing critical decisions about which courses needed support or room to grow.
We built a system powered by real-time data. The result? Stronger programs & better opportunities for students. 
How they moved beyond #Excel: https://loom.ly/WrjeFOI
loom.lyFrom Spreadsheet Overload to Strategic ClarityMove beyond Excel — one institution embraced reliable, secure, and flexible decision-making to drive student success.
Excel Interview Questions Count Hours Minutes Seconds of Day in Excel #excel #microsoftexcel #excel
Excel Interview Questions Count Hours Minutes Seconds of Day in Excel #excel #microsoftexcel #excel YEARFRAC Formula in ... source
QuadExcel.com · Excel Interview Questions Count Hours Minutes Seconds of Day in Excel #excel #microsoftexcel #excel - QuadExcel.comExcel Interview Questions Count Hours Minutes Seconds of Day in Excel #excel #microsoftexcel #excel YEARFRAC Formula in ... source
Il existe des alternatives crédibles à la suite #Microsoft #office comme par exemple la suite #libreoffice
Voici un article pour vous aider à vous y retrouver si vous êtes un utilisateur historique de #word #excel et autres
Lien de téléchargement libreoffice :
https://fr.libreoffice.org/download/telecharger-libreoffice/
ZDNET · LibreOffice : comment le faire ressembler davantage à Microsoft Office - ZDNETSi vous utilisez la suite bureautique de Microsoft depuis des années et que vous souhaitez passer à OpenOffice, voici la façon de rendre son interface utilisateur plus familière afin de faciliter la transition.
The Microsoft-Dilemma - #Europe as a #Software Colony (43min)
https://kolektiva.media/w/cbb9f78a-9705-41f6-b7a3-e869e1a0e7f2 (or
https://www.youtube.com/watch?v=duaYLW7LQvg if you don't mind YT using/stealing your data)
This is how the #EU is paying a secret number of Millions to #Microsoft in order to stay less secure, more dependend, less self-empowered, and more corrupt.
And this was known even before the US went totally crazy, risking our future big time.
So let's change and take back control using #FOSS software and open standards for true competition and actually according to our own rules for a change.
My brother needs a spreadsheet program secure enough to use for patient data.
Excel is MS and works like shit on Linux.
LibreCalc has terrible UI (so by brother says).
Google Sheet is Google and is not secure enough.
Suggestions? =)
¿Manejas datos en Excel? Entonces necesitas conocer Power Query.
Lo que hoy haces en horas, con Power Query lo harás en minutos. 
¿No sabes qué es Power Query? Es la herramienta que cambiará tu forma de trabajar con Excel para siempre. Este es solo el comienzo. Prepárate para nuestra serie de videos donde aprenderás a dominar cada uno de sus comandos y a transformar tus datos como un experto. ¡Síguenos y aprende a dominar Power Query! #Excel #PowerQuery #Productividad
Introducing value tokens in Microsoft #Excel
https://www.elevenforum.com/t/introducing-value-tokens-in-microsoft-excel.34727/
