How to Create a Smart Invoice in Excel: Codes, Automatic PDF and Sequential Numbering

Опубликовано: 21 Апрель 2026
на канале: Sergio Bazo | Herramientas Digitales
2,068
122

In this video you will discover how to set up a smart invoice format in Excel. Learn how to automate key tasks such as:
✔ Automatically display the customer's name when selecting their code.
✔ Assign products by simply choosing the corresponding code.
✔ Export the invoice to PDF with one click, delete the content and automatically increase the invoice number.

It's a complete solution to save time and avoid errors! It doesn't matter if you are an entrepreneur, an administrator or simply want to improve your Excel skills, this tutorial will be invaluable to you.

Subscribe for more content of this type and share this video with someone who needs to optimize their work in Excel. 🚀

If you have already subscribed to our paid Patreon, you can download the files to do this practice by clicking on the following link:
  / 120619545  

I invite you to follow our Excel courses. They are 100% practical.
Each video has its download material. These are the links for the playlists:

Basic Excel:
💻   • Curso GRATIS de EXCEL BÁSICO  

Intermediate Excel:
💻   • Curso GRATIS de EXCEL INTERMEDIO  

Advanced Excel:
💻   • Curso GRATIS de EXCEL AVANZADO  

Pivot tables:
💻   • ¡Aprende a diseñar TABLAS DINÁMICAS!  

Follow us on our social networks:

🔷Facebook support group:
  / lernencapacitaciones  

🔶Instagram:
  / profesergiobazo  

☑️Tiktok:
  / lernen.capacitaciones  

☑️X:
https://x.com/ProfeSergioBazo

✅Fanpage:
  / lernencapacitaciones  

✅Linkedin:
  / lernen-capacitaciones