How to Add or Merge Data from Multiple Columns to New Column in Microsoft Excel Automatically for School ID Cards

How to Add or Merge Data from Multiple Columns to New Column in Microsoft Excel Automatically for School ID Cards

Solution/Software
In my previous video How to make school ID Cards in Coreldraw Using Macro ID Maker, I have used an excel data sheet to import data. But for some of my viewers, it was quite difficult to add image data as they have not added the complete path or image extension in the excel sheet. So in this video I have explained how they can add extension or complete path in an excel data sheet. In this video i have explained how you can easily merge two columns in a different column. Let's Find how to do it? Hope you have liked this post.
Read More
How to Install WACOM CTL-672/K0-CX Medium Size Pen Tablet – Download Driver

How to Install WACOM CTL-672/K0-CX Medium Size Pen Tablet – Download Driver

Solution/Software
Looking for a way to find " How to install WACOM CTL-672/K0-CX Medium Size driver to windows pc or laptop..." then in the below video you will find it in a very simple language. In this video I have provided you the download location for WACOM CTL-672/K0-CX Medium Size driver from the official Wacom website as well as alternate location from where you can download this driver. Download WACOM CTL-672/K0-CX Driver from Wacom Website: Download alternate Location.
Read More
Automatic School ID Card Making in CorelDraw using Macro

Automatic School ID Card Making in CorelDraw using Macro

CorelDraw
As you can see in the above screen shot of the ID Card Maker Software, which can be used with CorelDraw Vr X6 and X7. With this software it automates all the process of data insertion whether it is text or images on the cards. The only things you need is ready design of the id card in coreldraw and this piece of free software. (However you can always donate me if you want to appreciate my work). Below you can find all the process. 1. Add data file in txt format 2. Here it will show all the data fields exists in the file. 3 and 4 Move image and bar code data fields in respective position. 5. Generate remaining data fields except image fields using this button. 6.…
Read More
Coredraw X7 Id Card Maker Macro Data Merge with Barcode and Photograph

Coredraw X7 Id Card Maker Macro Data Merge with Barcode and Photograph

CorelDraw
CorelDraw is one of the best software to create and manage School Id card using data merge command. So guys if you ever have used CorelDraw to create School Id Card, then , I am sure you may have faced problem while adding pictures and barcode data to the photographs. As CorelDraw does not have support to add barcode data and pictures using print merge command. But in this post here you will download a macro for coreldarw which will solve all your problems regarding ID cards. This macro is an automation process which will add all required data from a txt file saved in tab delimited format. However this text file can also be copied and paste from excel file to Notepad and then save it into txt file.…
Read More
School ID card Maker Macro with Photo Inserting Feature for CorelDraw X6

School ID card Maker Macro with Photo Inserting Feature for CorelDraw X6

CorelDraw
Creating and Finishing School Id Cards in CorelDraw is not very easy as we know that we can use data merge command to insert text fields in the cards. But when it come to insert pictures, its where the mess start. CorelDraw does not support automatic placing of image or barcodes directly from the data base. Now here Id Card Maker Macro Comes in Place, with this tool you can place images or barcodes at the runtime bu pulling details from the database.... just go through this video and see how easy it is now to create a school id card. Download ID Card Maker Macro Tool To Learn more or download this tool CorelDarw X7 visit this link here: http://www.dtptips.com/coredraw-x7-id-card-maker-macro-data-merge-with-barcode-and-photograph/ For any problem suggestion or quries.. plz visit this…
Read More
Photoshop CC 2019 सीखे हिंदीं में : Crop Tool, Canvas Size and Image Size – Detailed Tutorial in Hindi

Photoshop CC 2019 सीखे हिंदीं में : Crop Tool, Canvas Size and Image Size – Detailed Tutorial in Hindi

Photoshop
For any document in Photoshop, there are two very important thing; Canvas Size and Image Size. Now in this video I have clearly explained both the concepts along with an additional tool called Crop Tool. So friends go through this video and learn the next step in the Photoshop CC 2019 Learning Series. Hope you will love this video too. Previous video in this series : Photoshop CC 2019 सीखे हिंदीं में - All about Move and Selection Tools: Full Detail Video in Hindi Next Video in this series: 04 Photoshop CC 2019: How to create or use Layers - फोटोशॉप सीखे हिंदी में For all the videos published about till date watch this Youtube Playlist.... More videos will be included in this once they are published
Read More
Photoshop CC 2019 सीखे हिंदीं में  – All about Move and Selection Tools: Full Detail Video in Hindi

Photoshop CC 2019 सीखे हिंदीं में – All about Move and Selection Tools: Full Detail Video in Hindi

Photoshop
So after that you know how to create a new document in Photoshop, and how you can use pan and zoom tool there, its time now to move with some advance learning. In this video you will find what are selection tools and how to use the move tool with the current selection or with the image. Move and selection tools are the basics of Photoshop and you are going to use this tools very often with in the software. So enjoy this video and share your thoughts here or at dtptips.com channel forum. Previous video in this series :" 01 Photoshop CC 2019: Learn Toolbars Properties, Panels, New Document, Zoom & Pan Tool - Hindi Video Next Video in this series: 03 Photoshop CC 2019: Crop Tool, Canvas Size…
Read More
Photoshop CC 2019 सीखे हिंदीं में  – विस्त्रित विवरण सभी टूल्स के बारे में

Photoshop CC 2019 सीखे हिंदीं में – विस्त्रित विवरण सभी टूल्स के बारे में

Photoshop
दोस्तों फोटोशॉप उन चुनिंदा सॉफ्टवर्स में से एक है जिस पर काम करने कई एक अपना ही मज़ा है| यदि आप फोटोशॉप सीखना चाहते हैं तो मैं यहाँ पर आपकी पूरी हेल्प करने को मौजूद हूँ| आप मेरी एक एक वीडियोस को ध्यान से देखिये और पाएंगे की यह कभी कभी भी इतना मुश्किल नहीं है जैसे की आप सोच रहे थे| बस आपको कुछ समय प्रैक्टिस करने की जरुरत है| Hello Friends Learning Photoshop is always like a fun for every new beginner. It has a lot of interesting features which are used to enhance any image or used to create stunning graphics. Now in this series created in Hindi I will explain every bit of information you may require to be a professional, so plz watch this video…
Read More
5 Amazing Set of Cool Colour Swatch Palettes for Indesign: Download and Install

5 Amazing Set of Cool Colour Swatch Palettes for Indesign: Download and Install

Indesign
Are you looking for colour swatches for Indesign... then today here in this post you can find some beatiful set of cool colour palettes. Just download them and Install... Vibrant Colour Palatte For Indesign To install the above colour swatches download and extract the swatch file from the link given here. Aqua Colour Theme To install the above colour swatches download and extract the swatch file from the link given here. Nature Colour Swatch Palette To install the above colour swatches download and extract the swatch file from the link given here. Desert Colour Swatch To install the above colour swatches download and extract the swatch file from the link given here. Baby Colour Swatches Palette To install the above colour swatches download and extract the swatch file from the…
Read More
How to Create, manage, and import swatches in InDesign

How to Create, manage, and import swatches in InDesign

Indesign
Friends I have searched the above term "How to Create, manage, and import swatches in InDesign" in google and found the following result from the adobe help site: Import selected swatches from a file Choose New Color Swatch from the Swatches panel menu. Choose Other Library from the Color Mode list, and then select the file from which you want to import swatches. Click Open. Select the swatches you want import. Click OK. But that was enough only if we have swatches ready to import in adobe Indesign. But in my case I was looking for a bundled set of swatches. But nowhere I was able to find that, that's why I decided to create a video how we can create a set of colour swatches so that we use…
Read More