#exceltip — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #exceltip, aggregated by home.social.
-
In an often used spreadsheet I kept ending up at row 1,048,576 so after about the 100th time I put the text “endstop" in cells that I'd likely be jumping past (⌘⬇️ on macOS) now I end up nearby instead of a million rows away and my scroll bar still moves reasonably.
-
In an often used spreadsheet I kept ending up at row 1,048,576 so after about the 100th time I put the text “endstop" in cells that I'd likely be jumping past (⌘⬇️ on macOS) now I end up nearby instead of a million rows away and my scroll bar still moves reasonably.
-
In an often used spreadsheet I kept ending up at row 1,048,576 so after about the 100th time I put the text “endstop" in cells that I'd likely be jumping past (⌘⬇️ on macOS) now I end up nearby instead of a million rows away and my scroll bar still moves reasonably.
-
In an often used spreadsheet I kept ending up at row 1,048,576 so after about the 100th time I put the text “endstop" in cells that I'd likely be jumping past (⌘⬇️ on macOS) now I end up nearby instead of a million rows away and my scroll bar still moves reasonably.
-
How to sort data with code in VBA - S1 EP19 P1 #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel
-
How to sort data with code in VBA - S1 EP19 P1 #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel
-
How to sort data with code in VBA - S1 EP19 P1 #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel
-
How to Write And Edit a macro in VBA .S1 EP18 P9 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel
-
How to Write And Edit a macro in VBA .S1 EP18 P9 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel
-
How to Write And Edit a macro in VBA .S1 EP18 P9 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel
-
How to write First Code in Vba Excel S1 EP18 P8 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel
-
How to write First Code in Vba Excel S1 EP18 P8 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel
-
How to write First Code in Vba Excel S1 EP18 P8 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel
-
What is a Subroutine comment and a Basic Syntax in VBA Explained S1 EP18 P7 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel
-
What is a Subroutine comment and a Basic Syntax in VBA Explained S1 EP18 P7 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel
-
What is a Subroutine comment and a Basic Syntax in VBA Explained S1 EP18 P7 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel
-
How to Refer to a cell in VBA Code S1 EP18 P6 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel
-
How to Refer to a cell in VBA Code S1 EP18 P6 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel
-
How to Refer to a cell in VBA Code S1 EP18 P6 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel
-
How to Write and change Values in Excel with Code S1 EP18 P5 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel
-
How to Write and change Values in Excel with Code S1 EP18 P5 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel
-
How to Write and change Values in Excel with Code S1 EP18 P5 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel
-
How to save your Macro in Your Macro Library and Reuse- S1 EP18 P4 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel
-
How to save your Macro in Your Macro Library and Reuse- S1 EP18 P4 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel
-
How to save your Macro in Your Macro Library and Reuse- S1 EP18 P4 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel
-
Selecting and Formatting Cells using VBA in Excel - EP18 P3 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries
-
Selecting and Formatting Cells using VBA in Excel - EP18 P3 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries
-
Selecting and Formatting Cells using VBA in Excel - EP18 P3 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries
-
S1 EP18 P2 How to Enable the Developer Tab in excel #excel #microsoftexcel #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries
-
S1 EP18 P2 How to Enable the Developer Tab in excel #excel #microsoftexcel #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries
-
S1 EP18 P2 How to Enable the Developer Tab in excel #excel #microsoftexcel #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries
-
S1 EP17 P9 Standard Mathematical Operations in Power Query Editor Explained #excel #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltips #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #spreadsheethacks #datasplit
-
S1 EP17 P9 Standard Mathematical Operations in Power Query Editor Explained #excel #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltips #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #spreadsheethacks #datasplit
-
S1 EP17 P9 Standard Mathematical Operations in Power Query Editor Explained #excel #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltips #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #spreadsheethacks #datasplit
-
S1 EP17 P8 View Section in Power Query Editor Explained #excel #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltips #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #spreadsheethacks #datasplit
-
S1 EP17 P8 View Section in Power Query Editor Explained #excel #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltips #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #spreadsheethacks #datasplit
-
S1 EP17 P8 View Section in Power Query Editor Explained #excel #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltips #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #spreadsheethacks #datasplit
-
Calculate work hours with this trick! #excel #exceltip #exceltrick
Make sure to save this post for future reference! 21-Day Free Excel Training! source
https://quadexcel.com/wp/calculate-work-hours-with-this-trick-excel-exceltip-exceltrick/
-
Warum ich das schreibe? Ich wurde gefragt, ob es eine Lösung gibt, unser Backoffice möchte die Liste der Mitarbeitenden sortieren, das Jahr sei unerheblich, wichtig sei nur, dass wir den Geburtstag nicht verpassen.
Es gibt eine Lösung. Wir müssen eine zusätzliche Spalte einfügen, mit folgender Formel:
=MONAT(Geburtsdatum)*100+TAG(Geburtsdatum)
Geburtsdatum ist natürlich gleich der Zelle, in der das Geburtsdatum eingetragen wurde. Jetzt nur nach der neuen Spalte sortieren
-
Warum ich das schreibe? Ich wurde gefragt, ob es eine Lösung gibt, unser Backoffice möchte die Liste der Mitarbeitenden sortieren, das Jahr sei unerheblich, wichtig sei nur, dass wir den Geburtstag nicht verpassen.
Es gibt eine Lösung. Wir müssen eine zusätzliche Spalte einfügen, mit folgender Formel:
=MONAT(Geburtsdatum)*100+TAG(Geburtsdatum)
Geburtsdatum ist natürlich gleich der Zelle, in der das Geburtsdatum eingetragen wurde. Jetzt nur nach der neuen Spalte sortieren
-
Excel kann nicht nach Datum sortieren, wenn es um Monat, Tag geht und das Jahr unerheblich ist. Wenn Ihr ein Datum in Excel seht, ist das eine Formatierung, nicht aber der Wert, mit den Excel rechnet. Beispiel: Der heutige Tag hat den Wert:
44886
Letztes Jahr Dezember ist der Wert kleiner, nächstes Jahr Januar höher.
Wenn wir also aufsteigend, absteigend sortieren, geht es immer nur absolut mit dem Jahr, niemals aber nach Monat, Tag.
-
Excel kann nicht nach Datum sortieren, wenn es um Monat, Tag geht und das Jahr unerheblich ist. Wenn Ihr ein Datum in Excel seht, ist das eine Formatierung, nicht aber der Wert, mit den Excel rechnet. Beispiel: Der heutige Tag hat den Wert:
44886
Letztes Jahr Dezember ist der Wert kleiner, nächstes Jahr Januar höher.
Wenn wir also aufsteigend, absteigend sortieren, geht es immer nur absolut mit dem Jahr, niemals aber nach Monat, Tag.
