5 EXCEL TRICKS, DIE DU KENNEN MUSST

Digitale Profis June 1, 2023
Video Thumbnail
Digitale Profis Logo

Digitale Profis

@digitaleprofis

About

Hey, wir sind Johannes Ruof und Timothy Meixner! Wir sind studierte (und leidenschaftliche ;)) Informatiker und haben in der Vergangenheit mit Unternehmen wie Udemy, Google Deutschland und LinkedIn zusammengearbeitet. Auf unserem Kanal gibt es alles zu Künstlicher Intelligenz. Egal, ob ChatGPT, Microsoft Copilot oder Google Gemini. Außerdem gibt es wöchentlich ein KI-News-Update und hilfreiche Tutorials zu beliebten KI-Tools. Es ist für alle etwas dabei und alle sind willkommen. Wenn Du Vorschläge für uns hast, zu welchen Themen wir Videos produzieren sollen, dann schreib uns einfach in den Kommentaren! Wir freuen uns darauf, mit Euch in die spannende Welt der Künstlichen Intelligenz einzutauchen. Liebe Grüße Johannes & Timothy Impressum - Angaben gemäß § 5 TMG: Meixner & Ruof UG (haftungsbeschränkt) Dahlienweg 19 73760 Ostfildern Vertreten durch: Johannes Ruof Timothy Meixner Umsatzsteuer-ID: Umsatzsteuer-Identifikationsnummer gemäß §27a Umsatzsteuergesetz: DE321128110

Video Description

Microsoft Excel ist ein unglaublich komplexes Programm und vor allem für Neulinge ist es meistens schwer, so richtig effektiv damit zu arbeiten, da vieles tief in irgendwelchen Menüs vergraben ist und man oft gar nicht weiß, wo man suchen soll. In diesem Video zeige ich Dir ein paar meiner besten Tipps und Tricks für Excel, damit die Arbeit leichter und schneller von der Hand geht, unter Anderem Datenschnitte, Berichtfilterseiten und wie man Excel selbst denken lässt. Videoinhalt: 00:00 Intro 00:19 Mehrere Spalten und Zeilen einfügen 01:53 Mit Datenschnitten filtern 04:19 Excel selbst denken lassen 05:44 Berichtfilterseiten verwenden 07:18 Mehrere Arbeitsblätter auf einmal bearbeiten 09:02 Outro Videovorschläge, Feedback und Kritik kannst Du uns jederzeit in den Kommentaren mitteilen!

Excel Mastery Essentials

AI-recommended products based on this video

Loading...
Piano Keyboard Stickers for 88/61/54/49/37 Key, Bold Large Letter Piano Stickers for Learning, Removable Piano Keyboard Letters, Notes Label for Beginners and Kids, Multicolor

Piano Keyboard Stickers for 88/61/54/49/37 Key, Bold Large Letter Piano Stickers for Learning, Removable Piano Keyboard Letters, Notes Label for Beginners and Kids, Multicolor

(14,029)
$6.99
FREE delivery Thu, Sep 4 on $35 of items shipped by Amazon
6K+ bought in past month
Loading...
CERAKOTE® Ceramic Headlight Restoration Kit – Guaranteed To Last As Long As You Own Your Vehicle – Brings Headlights Back to Like New Condition - No Power Tools Required - 10 Wipe Kit
Best Seller

CERAKOTE® Ceramic Headlight Restoration Kit – Guaranteed To Last As Long As You Own Your Vehicle – Brings Headlights Back to Like New Condition - No Power Tools Required - 10 Wipe Kit

(58,346)
$17.95
FREE delivery Sun, Sep 21 on $35 of items shipped by Amazon
30K+ bought in past month
Loading...
Macally Small Wired Keyboard for Mac and Windows - 78 Scissor Switch Keys Compatible Apple Keyboard - USB Mini Keyboard That Saves Space and Looks Great - Plug and Play Wired Mac Keyboard - Aluminum

Macally Small Wired Keyboard for Mac and Windows - 78 Scissor Switch Keys Compatible Apple Keyboard - USB Mini Keyboard That Saves Space and Looks Great - Plug and Play Wired Mac Keyboard - Aluminum

(4,883)
27.99
PrimeFREE delivery Saturday, June 14 on orders shipped by Amazon over $35
200+ bought in past month
Loading...
Wireless Gaming Headset for PS5, PS4, PC, Mac, Switch, 2.4GHz Gaming Headsets with Bluetooth 5.4, Hidden ENC Noise Canceling Mic, 35H Battery, 3D Spatial Sound, 3.5mm Wired - Black

Wireless Gaming Headset for PS5, PS4, PC, Mac, Switch, 2.4GHz Gaming Headsets with Bluetooth 5.4, Hidden ENC Noise Canceling Mic, 35H Battery, 3D Spatial Sound, 3.5mm Wired - Black

(132)
$14.99
FREE delivery Jul 2 - 6 on $35 of items shipped by Amazon
2K+ bought in past month
Loading...
UGREEN USB C to USB Hub with 4 USB 3.0, Powered USB C Splitter for Laptop, MacBook Pro, Mac mini M4, iMac, iPad Pro, Chromebook, Dell XPS, Galaxy S23, and More, 0.5FT

UGREEN USB C to USB Hub with 4 USB 3.0, Powered USB C Splitter for Laptop, MacBook Pro, Mac mini M4, iMac, iPad Pro, Chromebook, Dell XPS, Galaxy S23, and More, 0.5FT

(12,070)
9.99
PrimeFREE delivery Saturday, June 14 on orders shipped by Amazon over $35
400+ bought in past month
Loading...
Wireless Bluetooth Mouse for Apple iPad iPhone MacBook Android Samsung Tablet Phone Dual-Mode Rechargeable 2.4G Portable Computer Mice for Windows Laptop Notebook PC Mac Desktop USB Receiver (Black)

Wireless Bluetooth Mouse for Apple iPad iPhone MacBook Android Samsung Tablet Phone Dual-Mode Rechargeable 2.4G Portable Computer Mice for Windows Laptop Notebook PC Mac Desktop USB Receiver (Black)

(1,960)
9.99
PrimeFREE delivery Saturday, June 14 on orders shipped by Amazon over $35
500+ bought in past month
Loading...
MESSAGENES Customizable Facebook QR NFC Sticker | Boost Followers | Reusable QR | 1 Rectangular Unit | Premium Quality | Ideal for Business, Showcase, Store, Wall or Window

MESSAGENES Customizable Facebook QR NFC Sticker | Boost Followers | Reusable QR | 1 Rectangular Unit | Premium Quality | Ideal for Business, Showcase, Store, Wall or Window

(22)
$12.72
FREE delivery Fri, Oct 10 on $35 of items shipped by Amazon
Loading...
MESSAGENES Customizable Facebook QR NFC Sticker | Boost Followers | Reusable QR | 1 Unit | Premium Quality | Ideal for Business, Showcase, Store, Wall or Window

MESSAGENES Customizable Facebook QR NFC Sticker | Boost Followers | Reusable QR | 1 Unit | Premium Quality | Ideal for Business, Showcase, Store, Wall or Window

(71)
$11.12
FREE delivery Fri, Oct 10 on $35 of items shipped by Amazon
Loading...
Lenovo 15.6" Laptop, Intel 10-Core i7-13620H (Beat Ultra 7 255U), 40GB DDR4 RAM, 2TB PCIe SSD, WiFi 6, Bluetooth 5.2, FHD Computer for Business & Student, RJ45, Type-C, HDMI, Windows 11 Pro, Wendbo

Lenovo 15.6" Laptop, Intel 10-Core i7-13620H (Beat Ultra 7 255U), 40GB DDR4 RAM, 2TB PCIe SSD, WiFi 6, Bluetooth 5.2, FHD Computer for Business & Student, RJ45, Type-C, HDMI, Windows 11 Pro, Wendbo

(11)
$899.00
FREE delivery Jun 18 - 23
Loading...
GMKtec Mini PC N97 Preinstalled Windows 11 Pro, G5 Micro Desktop Computer, 12th Gen Intel Alder Lake N97 (up to 3.60GHz) 12GB DDR5 256GB Hard Drive for Business, School, Office

GMKtec Mini PC N97 Preinstalled Windows 11 Pro, G5 Micro Desktop Computer, 12th Gen Intel Alder Lake N97 (up to 3.60GHz) 12GB DDR5 256GB Hard Drive for Business, School, Office

(1,018)
143.99
PrimeFREE delivery Saturday, June 14
1K+ bought in past month
Loading...
Temdan for Travel Essentials,3 in 2 USB C Cable for Apple Watch Charger/iPhone 16 Charger/Lightning,Multi Charging Cable Cord,Camping Essentials,Portable Designed for iWatch Series &iPhone 16-12-4FT Global Recycled Standard

Temdan for Travel Essentials,3 in 2 USB C Cable for Apple Watch Charger/iPhone 16 Charger/Lightning,Multi Charging Cable Cord,Camping Essentials,Portable Designed for iWatch Series &iPhone 16-12-4FT Global Recycled Standard

(2,378)
$8.49
FREE delivery Sat, Aug 9 on $35 of items shipped by Amazon
10K+ bought in past month
Loading...
PULIDIKI Car Cleaning Gel Car Clean Putty, Universal Car Interior Cleaner Slime, Perfect Cleaning Kit Supplies, Auto Detailing Tools Accessories, Dust Remover Gifts for Men Women
Best Seller

PULIDIKI Car Cleaning Gel Car Clean Putty, Universal Car Interior Cleaner Slime, Perfect Cleaning Kit Supplies, Auto Detailing Tools Accessories, Dust Remover Gifts for Men Women

(95,477)
$6.99
PrimeFREE delivery Sun, Sep 21 on $35 of items shipped by Amazon
20K+ bought in past month
Loading...
Garbage Disposal Cleaner Deodorizer Tablets - 24 Pack, New Powerful XL Foaming Tablet - Fresh Citrus Foam Sink Garburator Disposer Freshener, Natural Kitchen Drain Cleaning Care - 1 Year Supply
Best Seller

Garbage Disposal Cleaner Deodorizer Tablets - 24 Pack, New Powerful XL Foaming Tablet - Fresh Citrus Foam Sink Garburator Disposer Freshener, Natural Kitchen Drain Cleaning Care - 1 Year Supply

(9,454)
$15.09
FREE delivery Sun, Jun 22 on $35 of items shipped by Amazon
100K+ bought in past month
Loading...
FIXSMITH Microfiber Cleaning Cloth - Pack of 24, Multi-Functional Cleaning Towels, Size: 12 x 16 in, Highly Absorbent Cleaning Rags, Lint-Free, Streak-Free Cleaning Cloths for Car Kitchen Home Office

FIXSMITH Microfiber Cleaning Cloth - Pack of 24, Multi-Functional Cleaning Towels, Size: 12 x 16 in, Highly Absorbent Cleaning Rags, Lint-Free, Streak-Free Cleaning Cloths for Car Kitchen Home Office

(17,084)
12.99
PrimeFREE delivery Saturday, June 14 on orders shipped by Amazon over $35
300+ bought in past month
Loading...
Airbrush Kit with Air Tank Compressor 2 Dual-Action Gravity Airbrush with 0.2mm 0.3mm 0.5mm Nozzle Air Compressor with Airbrush Coloring Tool Cleaning Brush for Model Paint Hobby Craft

Airbrush Kit with Air Tank Compressor 2 Dual-Action Gravity Airbrush with 0.2mm 0.3mm 0.5mm Nozzle Air Compressor with Airbrush Coloring Tool Cleaning Brush for Model Paint Hobby Craft

(32)
116.75
PrimeFREE delivery Saturday, June 14