Excel & VBA mit Bernd Held

8:48

Warum dein Excel-Makro zu langsam ist (Arrays lösen das!)

Shared 5 days ago

147 views

4:29

E-Rechnung in Sekunden – dank Adress- & Artikelstamm

Excel & VBA mit Bernd Held

Shared 1 week ago

88 views

7:24

E-invoicing with Excel – tried and tested templates instead of theory

Excel & VBA mit Bernd Held

Shared 3 weeks ago

129 views

6:40

Held-Invoice für eRechnungen mit Excel: Formate & Einstellungen erklärt

Excel & VBA mit Bernd Held

Shared 4 weeks ago

147 views

4:19

eRechnung mit Excel in der Praxis: So funktioniert es Schritt für Schritt

Excel & VBA mit Bernd Held

Shared 1 month ago

195 views

4:45

Video 462: Excel Search without Filter & Copy-Paste

Excel & VBA mit Bernd Held

Shared 1 month ago

180 views

4:30

Video 461: Filling empty cells in a table using an array - super fast!

Excel & VBA mit Bernd Held

Shared 2 months ago

214 views

4:32

Video 460: Excel VBA: Automatically copy formulas down! 🤯 3 ingenious methods

Excel & VBA mit Bernd Held

Shared 2 months ago

207 views

8:19

Video 459: SQL-Power in Excel! 🤯

Excel & VBA mit Bernd Held

Shared 2 months ago

191 views

0:55

Kein Excel, aber trotzdem gut: Wachtel schlüpft in unter 60 Sekunden! Faszinierender Moment 🐣✨

Excel & VBA mit Bernd Held

Shared 2 months ago

81 views

8:10

Video 458: International reporting made easy – country consolidation with a click!

Excel & VBA mit Bernd Held

Shared 3 months ago

112 views

9:08

Video 457: Excel Trick: Mini-Charts Directly in the Cell via Macro! 📊⚡ — Sparklines Explained

Excel & VBA mit Bernd Held

Shared 3 months ago

110 views

5:19

Video 456: Font size problem in Excel: Automatically set uniform ActiveX fonts using VBA

Excel & VBA mit Bernd Held

Shared 3 months ago

211 views

5:16

Video 455: Excel VBA: Automatically convert cell values into range names – clever & dynamic!

Excel & VBA mit Bernd Held

Shared 3 months ago

138 views

7:27

Video 454: Control Pivot Tables by Cell! Excel VBA Trick for Interactive Dashboards 🔁

Excel & VBA mit Bernd Held

Shared 3 months ago

161 views

8:48

Video 453: Just 1 line – but so much power! 💥 The best VBA one-liners

Excel & VBA mit Bernd Held

Shared 3 months ago

333 views

7:17

Video 452: Top Secret: Hidden VBA commands and hacks for Excel professionals

Excel & VBA mit Bernd Held

Shared 3 months ago

277 views

7:26

Video 451: Check named ranges in Excel at the touch of a button – a clever VBA tool for clean spr...

Excel & VBA mit Bernd Held

Shared 3 months ago

125 views

7:15

Video 450: Search engine in Excel – jump directly to the search result using VBA with a hyperlink!

Excel & VBA mit Bernd Held

Shared 3 months ago

124 views

9:32

Video 449: Excel Macro: Automatically merge monthly reports – data import made easy!

Excel & VBA mit Bernd Held

Shared 3 months ago

125 views

6:29

Video 448: Excel protects itself – automatically lock & highlight formulas! 🔒💛

Excel & VBA mit Bernd Held

Shared 3 months ago

113 views

8:09

Video 447: Excel automatically distributes data to new tables – with just one click!

Excel & VBA mit Bernd Held

Shared 3 months ago

173 views

8:30

Video 446: Excel automatically sends your PDFs via Outlook! ✉️⚙️

Excel & VBA mit Bernd Held

Shared 3 months ago

125 views

5:28

Video 445: All tables as PDFs – with just one click! ⚙️📄

Excel & VBA mit Bernd Held

Shared 3 months ago

124 views

10:06

Video 444: Perfect data flow in Excel – fully automated export & import! 🔁📊

Excel & VBA mit Bernd Held

Shared 3 months ago

179 views

6:54

Video 443: Excel talks to you! – Double-click & voice output in multiple languages with VBA

Excel & VBA mit Bernd Held

Shared 3 months ago

127 views

8:17

Video 442: Automatically create a table of contents for all worksheets – with just one click!

Excel & VBA mit Bernd Held

Shared 3 months ago

200 views

5:44

Video 441: Excel automatically monitors changes – log cell changes using VBA!

Excel & VBA mit Bernd Held

Shared 3 months ago

215 views

7:09

Video 440: Read Excel filters live – with your own user-defined function!

Excel & VBA mit Bernd Held

Shared 3 months ago

199 views

6:21

Video 439: Update prices automatically – with arrays & dictionaries in Excel VBA!

Excel & VBA mit Bernd Held

Shared 3 months ago

129 views

5:08

Video 438: Pivot drilldown at a professional level: Automatically generate sheets by region & month!

Excel & VBA mit Bernd Held

Shared 3 months ago

101 views

7:03

Video 437: Search like a pro: Automatically find and mark countries in text

Excel & VBA mit Bernd Held

Shared 3 months ago

101 views

6:59

Video 436: Clean up data at the touch of a button: Hide specific rows (values 1, 2 or 3) using ...

Excel & VBA mit Bernd Held

Shared 4 months ago

114 views

8:51

Video 435: Delete columns in a user-friendly way using UserForm – Multiple selection in Excel VBA

Excel & VBA mit Bernd Held

Shared 4 months ago

134 views

5:52

Video 434: Combine two columns uniquely – modern & classic: The best methods in Excel VBA

Excel & VBA mit Bernd Held

Shared 4 months ago

82 views

12:21

Video 433: Various techniques for transferring ranges and charts from Excel to PowerPoint

Excel & VBA mit Bernd Held

Shared 4 months ago

119 views

11:43

Video 432: Then and now - how new features in Office 365 make the use of macros obsolete!

Excel & VBA mit Bernd Held

Shared 4 months ago

102 views

3:41

Video 431: The flexible Christmas calendar without chocolate, but with keyboard shortcuts

Excel & VBA mit Bernd Held

Shared 4 months ago

112 views

8:03

Video 430: Then and now - how new features in Office 365 make the use of macros obsolete!

Excel & VBA mit Bernd Held

Shared 4 months ago

195 views

8:25

Video 429: Automatically filter data slices by sales – intelligent pivot control!

Excel & VBA mit Bernd Held

Shared 4 months ago

79 views

9:15

Video 428: Learn languages with Excel – program your own trainer with just a few lines

Excel & VBA mit Bernd Held

Shared 5 months ago

235 views

7:43

Video 427: Excel form with search function & data transfer with one click – it's that easy with VBA!

Excel & VBA mit Bernd Held

Shared 8 months ago

305 views

8:18

Video 426: Simple Excel input form with VBA without any frills

Excel & VBA mit Bernd Held

Shared 8 months ago

276 views

11:21

Video 425: Automatically create monthly reports, save them as PDFs, and send them directly by email

Excel & VBA mit Bernd Held

Shared 8 months ago

322 views

10:43

Video 424: Cell dropdown versus userform: single selection or multiple selection?

Excel & VBA mit Bernd Held

Shared 9 months ago

324 views

8:20

Video 423: No more manual reminders – Excel automatically sends emails to multiple recipients

Excel & VBA mit Bernd Held

Shared 9 months ago

312 views

6:34

Video 422: VLOOKUP & XLOOKUP using VBA: How to integrate functions into your macro without a loop!

Excel & VBA mit Bernd Held

Shared 10 months ago

443 views

9:57

Video 421: Zwei Varianten, um Zeilen performant bedingt auszublenden

Excel & VBA mit Bernd Held

Shared 10 months ago

310 views

6:05

Video 420: SQL-Power in Excel! Riesige Daten blitzschnell auswerten mit VBA 🚀

Excel & VBA mit Bernd Held

Shared 11 months ago

343 views

7:44

Video 419: Excel liest Daten aus geschlossenen Dateien – ohne sie zu öffnen! 🔥

Excel & VBA mit Bernd Held

Shared 1 year ago

590 views

9:40

Video 418: E-Rechnung in Excel erstellen – XRechnung & ZUGFeRD automatisch generieren 🚀

Excel & VBA mit Bernd Held

Shared 1 year ago

2K views

7:15

Video 417: Säulen mit Farben aus dem bedingten Format einfärben

Excel & VBA mit Bernd Held

Shared 1 year ago

189 views

10:57

Video 416: Recht nützlich - Kommentare auslesen, korrigieren und wieder einfügen

Excel & VBA mit Bernd Held

Shared 1 year ago

492 views

9:14

Video 415: E-Rechnungen aus Excel heraus per Knopfdruck in Visualisierungs-Tools öffnen und anzeigen

Excel & VBA mit Bernd Held

Shared 1 year ago

678 views

5:34

Video 414: Die flexible e-Rechnung in Excel mit Hilfe eines Mappings herstellen

Excel & VBA mit Bernd Held

Shared 1 year ago

1.5K views

9:26

Video 413: Gezieltes Copy & Paste: Gefüllte Zellen extrahieren und nahtlos in neue Tabellen einfügen

Excel & VBA mit Bernd Held

Shared 1 year ago

380 views

10:52

Video 412: Blitzschnelle automatische Analyse von Produktwerten mit SQL oder Pivot (ohne Schleifen!)

Excel & VBA mit Bernd Held

Shared 1 year ago

397 views

10:39

Video 411: Eindeutige Werte per Klick anzeigen – dynamische ComboBox & ListBox in Excel-VBA

Excel & VBA mit Bernd Held

Shared 1 year ago

337 views

13:00

Video 410: Datenverdichtung mit Arrays: Schnelle Filterung und Summierung für große Datenmengen

Excel & VBA mit Bernd Held

Shared 1 year ago

395 views

8:29

Video 409: Automatische eigene Ampelsymbole basierend auf Zellwerten in Excel

Excel & VBA mit Bernd Held

Shared 1 year ago

453 views