Excel & VBA mit Bernd Held

3:44

HOAI + Excel + E-Invoicing? Done in a few minutes!

Shared 4 days ago

272 views

1:50

Creating E-Invoices directly from Excel – How companies save hours every month!

Excel & VBA mit Bernd Held

Shared 1 week ago

6.8K views

6:10

Excel dashboard with pivot chart – directly in a UserForm – explained step by step

Excel & VBA mit Bernd Held

Shared 4 months ago

231 views

8:48

Why your Excel macro is too slow (Arrays solve this!)

Excel & VBA mit Bernd Held

Shared 4 months ago

262 views

4:29

E-invoicing in seconds – thanks to address and item database

Excel & VBA mit Bernd Held

Shared 5 months ago

170 views

7:24

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

Excel & VBA mit Bernd Held

Shared 5 months ago

246 views

6:40

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

Excel & VBA mit Bernd Held

Shared 5 months ago

273 views

4:19

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

Excel & VBA mit Bernd Held

Shared 5 months ago

852 views

4:45

Video 462: Excel Search without Filter & Copy-Paste

Excel & VBA mit Bernd Held

Shared 5 months ago

219 views

4:30

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

Excel & VBA mit Bernd Held

Shared 7 months ago

227 views

4:32

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

Excel & VBA mit Bernd Held

Shared 7 months ago

247 views

8:19

Video 459: SQL-Power in Excel! 🤯

Excel & VBA mit Bernd Held

Shared 7 months ago

223 views

0:55

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

Excel & VBA mit Bernd Held

Shared 7 months ago

88 views

8:10

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

Excel & VBA mit Bernd Held

Shared 7 months ago

123 views

9:08

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

Excel & VBA mit Bernd Held

Shared 7 months ago

116 views

5:19

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

Excel & VBA mit Bernd Held

Shared 7 months ago

290 views

5:16

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

Excel & VBA mit Bernd Held

Shared 7 months ago

149 views

7:27

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

Excel & VBA mit Bernd Held

Shared 8 months ago

170 views

8:48

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

Excel & VBA mit Bernd Held

Shared 8 months ago

347 views

7:17

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

Excel & VBA mit Bernd Held

Shared 8 months ago

290 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 8 months ago

135 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 8 months ago

142 views

9:32

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

Excel & VBA mit Bernd Held

Shared 8 months ago

132 views

6:29

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

Excel & VBA mit Bernd Held

Shared 8 months ago

118 views

8:09

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

Excel & VBA mit Bernd Held

Shared 8 months ago

187 views

8:30

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

Excel & VBA mit Bernd Held

Shared 8 months ago

144 views

5:28

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

Excel & VBA mit Bernd Held

Shared 8 months ago

146 views

10:06

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

Excel & VBA mit Bernd Held

Shared 8 months ago

189 views

6:54

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

Excel & VBA mit Bernd Held

Shared 8 months ago

141 views

8:17

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

Excel & VBA mit Bernd Held

Shared 8 months ago

230 views

5:44

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

Excel & VBA mit Bernd Held

Shared 8 months ago

265 views

7:09

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

Excel & VBA mit Bernd Held

Shared 8 months ago

202 views

6:21

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

Excel & VBA mit Bernd Held

Shared 8 months ago

151 views

5:08

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

Excel & VBA mit Bernd Held

Shared 8 months ago

106 views

7:03

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

Excel & VBA mit Bernd Held

Shared 8 months ago

105 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 8 months ago

117 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 8 months ago

152 views

5:52

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

Excel & VBA mit Bernd Held

Shared 8 months ago

85 views

12:21

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

Excel & VBA mit Bernd Held

Shared 8 months ago

121 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 8 months ago

106 views

3:41

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

Excel & VBA mit Bernd Held

Shared 8 months ago

114 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 8 months ago

196 views

8:25

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

Excel & VBA mit Bernd Held

Shared 8 months ago

84 views

9:15

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

Excel & VBA mit Bernd Held

Shared 10 months ago

303 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 1 year ago

308 views

8:18

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

Excel & VBA mit Bernd Held

Shared 1 year ago

297 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 1 year ago

330 views

10:43

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

Excel & VBA mit Bernd Held

Shared 1 year ago

331 views

8:20

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

Excel & VBA mit Bernd Held

Shared 1 year ago

322 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 1 year ago

471 views

9:57

Video 421: Two ways to conditionally hide rows efficiently

Excel & VBA mit Bernd Held

Shared 1 year ago

326 views

6:05

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

Excel & VBA mit Bernd Held

Shared 1 year ago

390 views

7:44

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

Excel & VBA mit Bernd Held

Shared 1 year ago

711 views

9:40

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

Excel & VBA mit Bernd Held

Shared 1 year ago

2.6K views

7:15

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

Excel & VBA mit Bernd Held

Shared 1 year ago

232 views

10:57

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

Excel & VBA mit Bernd Held

Shared 1 year ago

555 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

705 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.6K 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

407 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

404 views