HDTutorial
EN

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How To Create An ID Card With Bar Codes In Excel [Employee Manager Pt. 11]

40,519 views November 10, 2019 1:40:34

Watch on YouTube
ChannelExcel For Freelancers

Chapters

Description from the creator

Employee manager in Excel — employee ID cards are about to generate automatically, complete with barcodes.

Creating employee ID cards by hand one at a time doesn't scale once your team grows past a few people. This training walks you through how to add automatic ID card generation, including scannable barcodes for each employee. You'll see exactly how the barcode and layout logic come together into one automated process.

👇 GET THE FREE FILES FOR THIS VIDEO:
excelforfreelancers.com/employee-manager-part-1…

🔥OWN 550+ TEMPLATES & WORKBOOKS IN ONE PACK👉 excelforfreelancers.com/ultimate-wkbk-pack-yt-d…

🆕 New Excel Add-In: 8 Productivity Tools In One Ribbon Tab 👉 excelforfreelancers.com/excel-productivity-suit…

📌 MASTER 1-CLICK REPORTS IN MY DASHBOARD MASTERCLASS 👉 excelforfreelancers.com/dashboard-masterclass-y…

😎 JOIN OUR ELITE MEMBERSHIP: PREMIUM TRAININGS, RESOURCES & COACHING 👉excelforfreelancers.com/elite-membership-yt-desc

🚀 GET YOUR OPERATIONS UNDER CONTROL — 3 Spots Open This Quarter👉 excelforfreelancers.com/business-transformation…

🛠 NEED THIS BUILT FOR YOUR BUSINESS OR NEEDS? Get Expert Customization Help 👉excelforfreelancers.com/CustomsJobs_YTDesc

🛒 Browse All Excel And AI Templates, Courses & Tools: excelforfreelancers.com/shop

⏱ TIMESTAMPS:
0:00 - Introduction
0:56 - Overview
5:35 - Conditional Formatting
12:54 - Sheet Before Right Click
15:35 - Right Click Call Events
19:57 - Go to Event Schedule
26:12 - Named Ranges Explanation
30:47 - Change Event
42:00 - Clear Filters
1:00:39 - Conditional Formatting
1:19:22 - Field Change Employee ID Card
1:24:06 - Create Text Box
1:38:16 - Sort By Name Employee

👥 JOIN OUR COMMUNITY: excelforfreelancers.com/EFFGroup
🔗 LinkedIn: linkedin.com/in/excelforfreelancers/
😎 Facebook: facebook.com/ExcelForFreelancers

About: I'm Randy Austin — Excel developer and business systems builder. I help business owners and entrepreneurs replace expensive software subscriptions with powerful, done-for-you Excel templates they can customize and own forever. New training every week.

#excel #exceltutorial #excelforfreelancers #employeemanager #hrmanagement

Thanks so much for your continued support,
Randy Austin

About this tutorial

Excel For Freelancers published this 1:40:34 video tutorial on November 10, 2019. It has been watched 40,519 times on YouTube.

Duration
1:40:34
Published
November 10, 2019
Views
40,519
Likes
517

Tags

Share

This tutorial in other languages