Excel Tipps und Tricks

Lernpfad Datenanalyse mit Excel: Wissen Schritt für Schritt aufbauen

10. April 2024/in Tipps & Tricks/von Dieter Neoral

Sie wollen gezielt Wissen zum Thema Datenanalyse in Excel erwerben? Dann sind Sie bei dieser Kurskombination genau richtig!

Wie kann man Arbeitsstunden in Excel über die Zeit-Funktionen berechnen?

26. März 2024/in Tipps & Tricks/von Dieter Neoral

Zeitberechnungen in Excel sind kein Hexenwerk – dennoch gibt es Stolpersteine zu beachten!

Berechnung der Lohn- und Einkommensteuer für Österreich in Excel

24. Januar 2023/in Tipps & Tricks/von Dieter Neoral

Nützliche Excel Array-Funktionen in Office 365 – Funktion =ZUFALLSMATRIX(), =SEQUENZ()

23. Dezember 2022/in Tipps & Tricks/von Ismail Murtazaliev

Ab der Version Office 365 bietet Excel sehr interessante Array-Funktionen an. In diesem Blogbeitrag stellen wir Ihnen 2 weitere Funktionen vor.

Nützliche Excel Array-Funktionen in Office 365 – Teil 1

23. September 2022/in Tipps & Tricks/von Ismail Murtazaliev

Ab der Version Office 365 bietet Excel sehr interessante Array-Funktionen an. In diesem Blogbeitrag stellen wir Ihnen 3 dieser Funktionen vor.

img.wp-smiley,img.emoji{display:inline !important;border:none !important;box-shadow:none !important;height:1em !important;width:1em !important;margin:0 .07em !important;vertical-align:-.1em !important;background:none !important;padding:0 !important;}.safe-svg-cover{text-align:center;}.safe-svg-cover .safe-svg-inside{display:inline-block;max-width:100%;}.safe-svg-cover svg{height:100%;max-height:100%;max-width:100%;width:100%;}.wp-site-blocks > .alignleft{float:left;margin-right:2em;}.wp-site-blocks > .alignright{float:right;margin-left:2em;}.wp-site-blocks > .aligncenter{justify-content:center;margin-left:auto;margin-right:auto;}body .is-layout-flow > .alignleft{float:left;margin-inline-start:0;margin-inline-end:2em;}body .is-layout-flow > .alignright{float:right;margin-inline-start:2em;margin-inline-end:0;}body .is-layout-flow > .aligncenter{margin-left:auto !important;margin-right:auto !important;}body .is-layout-constrained > .alignleft{float:left;margin-inline-start:0;margin-inline-end:2em;}body .is-layout-constrained > .alignright{float:right;margin-inline-start:2em;margin-inline-end:0;}body .is-layout-constrained > .aligncenter{margin-left:auto !important;margin-right:auto !important;}body .is-layout-constrained > :where(:not(.alignleft):not(.alignright):not(.alignfull)){max-width:var(--wp--style--global--content-size);margin-left:auto !important;margin-right:auto !important;}body .is-layout-constrained > .alignwide{max-width:var(--wp--style--global--wide-size);}body .is-layout-flex{display:flex;}body .is-layout-flex{flex-wrap:wrap;align-items:center;}body .is-layout-flex > *{margin:0;}body .is-layout-grid{display:grid;}body .is-layout-grid > *{margin:0;}.wp-element-button,.wp-block-button__link{background-color:#32373c;border-width:0;color:#fff;font-family:inherit;font-size:inherit;line-height:inherit;padding:calc(.667em + 2px) calc(1.333em + 2px);text-decoration:none;}.has-black-color{color:var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-color{color:var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-color{color:var(--wp--preset--color--white) !important;}.has-pale-pink-color{color:var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-color{color:var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-color{color:var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-color{color:var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-color{color:var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-color{color:var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-color{color:var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-color{color:var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-color{color:var(--wp--preset--color--vivid-purple) !important;}.has-metallic-red-color{color:var(--wp--preset--color--metallic-red) !important;}.has-maximum-yellow-red-color{color:var(--wp--preset--color--maximum-yellow-red) !important;}.has-yellow-sun-color{color:var(--wp--preset--color--yellow-sun) !important;}.has-palm-leaf-color{color:var(--wp--preset--color--palm-leaf) !important;}.has-aero-color{color:var(--wp--preset--color--aero) !important;}.has-old-lavender-color{color:var(--wp--preset--color--old-lavender) !important;}.has-steel-teal-color{color:var(--wp--preset--color--steel-teal) !important;}.has-raspberry-pink-color{color:var(--wp--preset--color--raspberry-pink) !important;}.has-medium-turquoise-color{color:var(--wp--preset--color--medium-turquoise) !important;}.has-black-background-color{background-color:var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-background-color{background-color:var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-background-color{background-color:var(--wp--preset--color--white) !important;}.has-pale-pink-background-color{background-color:var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-background-color{background-color:var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-background-color{background-color:var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-background-color{background-color:var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-background-color{background-color:var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-background-color{background-color:var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-background-color{background-color:var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-background-color{background-color:var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-background-color{background-color:var(--wp--preset--color--vivid-purple) !important;}.has-metallic-red-background-color{background-color:var(--wp--preset--color--metallic-red) !important;}.has-maximum-yellow-red-background-color{background-color:var(--wp--preset--color--maximum-yellow-red) !important;}.has-yellow-sun-background-color{background-color:var(--wp--preset--color--yellow-sun) !important;}.has-palm-leaf-background-color{background-color:var(--wp--preset--color--palm-leaf) !important;}.has-aero-background-color{background-color:var(--wp--preset--color--aero) !important;}.has-old-lavender-background-color{background-color:var(--wp--preset--color--old-lavender) !important;}.has-steel-teal-background-color{background-color:var(--wp--preset--color--steel-teal) !important;}.has-raspberry-pink-background-color{background-color:var(--wp--preset--color--raspberry-pink) !important;}.has-medium-turquoise-background-color{background-color:var(--wp--preset--color--medium-turquoise) !important;}.has-black-border-color{border-color:var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-border-color{border-color:var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-border-color{border-color:var(--wp--preset--color--white) !important;}.has-pale-pink-border-color{border-color:var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-border-color{border-color:var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-border-color{border-color:var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-border-color{border-color:var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-border-color{border-color:var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-border-color{border-color:var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-border-color{border-color:var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-border-color{border-color:var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-border-color{border-color:var(--wp--preset--color--vivid-purple) !important;}.has-metallic-red-border-color{border-color:var(--wp--preset--color--metallic-red) !important;}.has-maximum-yellow-red-border-color{border-color:var(--wp--preset--color--maximum-yellow-red) !important;}.has-yellow-sun-border-color{border-color:var(--wp--preset--color--yellow-sun) !important;}.has-palm-leaf-border-color{border-color:var(--wp--preset--color--palm-leaf) !important;}.has-aero-border-color{border-color:var(--wp--preset--color--aero) !important;}.has-old-lavender-border-color{border-color:var(--wp--preset--color--old-lavender) !important;}.has-steel-teal-border-color{border-color:var(--wp--preset--color--steel-teal) !important;}.has-raspberry-pink-border-color{border-color:var(--wp--preset--color--raspberry-pink) !important;}.has-medium-turquoise-border-color{border-color:var(--wp--preset--color--medium-turquoise) !important;}.has-vivid-cyan-blue-to-vivid-purple-gradient-background{background:var(--wp--preset--gradient--vivid-cyan-blue-to-vivid-purple) !important;}.has-light-green-cyan-to-vivid-green-cyan-gradient-background{background:var(--wp--preset--gradient--light-green-cyan-to-vivid-green-cyan) !important;}.has-luminous-vivid-amber-to-luminous-vivid-orange-gradient-background{background:var(--wp--preset--gradient--luminous-vivid-amber-to-luminous-vivid-orange) !important;}.has-luminous-vivid-orange-to-vivid-red-gradient-background{background:var(--wp--preset--gradient--luminous-vivid-orange-to-vivid-red) !important;}.has-very-light-gray-to-cyan-bluish-gray-gradient-background{background:var(--wp--preset--gradient--very-light-gray-to-cyan-bluish-gray) !important;}.has-cool-to-warm-spectrum-gradient-background{background:var(--wp--preset--gradient--cool-to-warm-spectrum) !important;}.has-blush-light-purple-gradient-background{background:var(--wp--preset--gradient--blush-light-purple) !important;}.has-blush-bordeaux-gradient-background{background:var(--wp--preset--gradient--blush-bordeaux) !important;}.has-luminous-dusk-gradient-background{background:var(--wp--preset--gradient--luminous-dusk) !important;}.has-pale-ocean-gradient-background{background:var(--wp--preset--gradient--pale-ocean) !important;}.has-electric-grass-gradient-background{background:var(--wp--preset--gradient--electric-grass) !important;}.has-midnight-gradient-background{background:var(--wp--preset--gradient--midnight) !important;}.has-small-font-size{font-size:var(--wp--preset--font-size--small) !important;}.has-medium-font-size{font-size:var(--wp--preset--font-size--medium) !important;}.has-large-font-size{font-size:var(--wp--preset--font-size--large) !important;}.has-x-large-font-size{font-size:var(--wp--preset--font-size--x-large) !important;}.wp-block-navigation a:where(:not(.wp-element-button)){color:inherit;}.wp-block-pullquote{font-size:1.5em;line-height:1.6;}#top #header_main > .container,#top #header_main > .container .main_menu .av-main-nav > li > a,#top #header_main #menu-item-shop .cart_dropdown_link{height:85px;line-height:85px;}.html_top_nav_header .av-logo-container{height:85px;}.av_font_icon.av-av_font_icon-be3a12d5e655f0fe97ebc6ae6d9e5776{color:#ffc20e !important;border-color:#ffc20e !important;}.av_font_icon.av-av_font_icon-be3a12d5e655f0fe97ebc6ae6d9e5776 .av-icon-char{font-size:20px;line-height:20px;}