Thank you so much po sir! You save me huhu kasi una ko ginagawa iniisa isa ko talaga siya copy and paste kaya buong ko ginawa yung 256 na certificates. Nung natapos na ako naconvert ko na siya in pdf don ko napansin na mali pala yung format na ginawa ko dapat pala naka capitalize lahat ng names. Kaya maraming salamat!!!!
Hello Sir Louie thank you for the tutorial video and the new learning. I followed your tutorial with 7 variables considered and it works except for the average grade. The average grade in the generated certificates would not appear as desired. I set the average grade in 2 decimal places in excel but in the generated certificates it would appear in different decimal places. Do you have idea how to set it so that it will appear in 2 decimal places? Thank you...
hello po! kindly check the decimal format in MS Excel. It should be rounded of to two decimal places (used the ROUND formula/function). If you just used the adjust decimal places button (increase/decimal buttons) it will still show the actual decimal places when transferred to MS Word
Thank you for imparting good tips in preparing various certificates. May i know what will be the process if aside from nanes i still need to include number of modules being evaluated for 2 semesters and add QR code. Thank you again.
Hi Sir! Ask ko lang po. What if sa PowerPoint ako gumawa ng certificate layout, meron din bang mail merge dun? I used PowerPoint para maconvert ko siya into jpeg format for virtual certificates.
ask ko lang po sir, paano po gawin yung certificate in 2 columns po para po sana di masyadong malaki sa bond paper po para sa mga participants na nag attend ng seminar. kumbaga po 2 certificate in 1 bond paper ganun po sana, half ng bond paper. paano po gawin sa ms word? SANA PO MA BASA NIYO TO PO, Thank you po.
@@SirLouieTV thanks po Sir, tamang tama po ito, I’m serving as a secretariat po kasi sa isang workshop and seminar ng mga Brgy. officials, 200+ participants din yun, thanks pp ulit
Very simple instruction for non technical individual like me...thank you for sharing ❤
Thank you sir. Nakagawa na ako ng mga certificates. God bless!!!
Thanks a lot. This is so easy to follow.
Very useful po talaga nitong video mo sir, Salamat po!!!!
thank you po sir, mas dali ko pong naintindihan.
sheesh anlaking tulong po neto especially for national and other big events hosted by some random college students hahaha salamat po
Thank you so much po sir! You save me huhu kasi una ko ginagawa iniisa isa ko talaga siya copy and paste kaya buong ko ginawa yung 256 na certificates. Nung natapos na ako naconvert ko na siya in pdf don ko napansin na mali pala yung format na ginawa ko dapat pala naka capitalize lahat ng names. Kaya maraming salamat!!!!
Thank you po sa tutorial ninyo, Sir! Bagong tuklas na karunungan! ❤️❤️❤️
thansk for sharing,a great help for me
thank po sir, malaking tulong po itong share nyo
I am very glad that I stumbled upon your video
Galing working by following those steps
Thank you sir..malaking tulong po ito. Godbless po.
Thank you sir. Nagamit ko po ito and it really works 🙏🏻
Thank you very much for this, Teacher Louie! I had to refresh myself on how to use mail merge. This video helped a lot.
Ang galing sirrr salamat po
Thank po sir you help me a lot. You make my Work easier and Faster.
Hi sir thank you for this informative video ,this will very a big help for me and to my work. More videos and content like this po.GODBLESS PO🥰
Thank you sir😊 God bless po
Maraming salamat po sa tulong, gaya ko po ako lang mag isa lahat gumawa
Thank you sir this helps a lot
I love it.. easy steps.. well explained... i love it
Thank you very much po. This helped a lot.
hahaha ngayon ko lang nadiscover to. Very useful po, Sir. Thanks
thank you po sir!
thnk you sir..very informative po
Marami pong salamat!
Huge help, thank you so much for this video tutorial Sir!
Thank you sir! Pinaka madaling instruction!
salamat din po ng marami
Husay! New knowledge! Thanks sir!
thank you po!
Thank you, sir!
Thankyou Sir so helpful for us Teachers. This is what i really need. New subscriber here. Good job po.
Galing naman po. Salamat po master. Teacher vlogger din ako from deped R6
Thank you sir for this tutorial.
Thanks for this!
Great video, easy to understand with the English subtitle. Thank you
Galing mo sir. This is what I'm lookin' for. :)
Thank you po sir 😊
SUPER HELPFUL THANK YOU PO!!
Thank you po Sir Louie,stay safe and healthy
Thank you po sir! Well explained! 😊 God bless 🙏
Great! Thanks Sir Louie!
Salamat po!
Sir salamat sana madami pa kayo gawin na tagalog version, mas madali masundan
Thank you so much po for this ❤️
Thank you so much Sir Louie!
Thank you sir, I've learned a lot po sa inyong mga videos🥰
Salamat po..
Thank you .
Thank you po Sir Louie
Thanks Sir Louie
A blessed day! Paano po paggamit Publisher? for student ID
thank you po, sir for this content!! big help po for my subject na empowerment technologies. god bless po, sir and more contents and powers to come ^^
THANK YOU
thank you po..
Thank you sir
AAAHHH! THANK YOUUU!
thank you so much po! paano naman po yung may "his and her" sa certificate?
sir, pano po kung may idagdag "CPA license number. di po lahat ay CPA so yung iba wala CPA license number
Hello Sir Louie thank you for the tutorial video and the new learning. I followed your tutorial with 7 variables considered and it works except for the average grade. The average grade in the generated certificates would not appear as desired. I set the average grade in 2 decimal places in excel but in the generated certificates it would appear in different decimal places. Do you have idea how to set it so that it will appear in 2 decimal places? Thank you...
hello po! kindly check the decimal format in MS Excel. It should be rounded of to two decimal places (used the ROUND formula/function). If you just used the adjust decimal places button (increase/decimal buttons) it will still show the actual decimal places when transferred to MS Word
Thank you, sir. Pero pano din po kapag dalawa yung dapat ilagay sa cert? Yung name at tsaka yung LRN nila po?
Thank you for imparting good tips in preparing various certificates. May i know what will be the process if aside from nanes i still need to include number of modules being evaluated for 2 semesters and add QR code. Thank you again.
hi, how to save it individually to PDF file po?
Shout out po sa next vlog sir
hahaha thank you Ieroll!
Thank you po dito sir. Possible po ba na picture ng certificate na nakapng format ang gamitin layout ng cert?
Anu pong gamit nyo screen recording sir?
how about kung lagyan ng average or iba pang data
Hi Sir! Ask ko lang po. What if sa PowerPoint ako gumawa ng certificate layout, meron din bang mail merge dun? I used PowerPoint para maconvert ko siya into jpeg format for virtual certificates.
Sir san po nakakakita ng boarder ng mga cerificates..yun po simple lang.thank u sir..more power
Pwede mo ba iexport as individual jpeg file tas naka filename sa name ng cert recipient>?
Paano po yan maiisave individual file per each student
what if po 2 columns yung page sa word
Tnx sir
What if there are 2 fields?
thanks sir pa request naman po pag gawa ng i.d via ms word po
Ask lang po. Need po ba madami na copy ng bawat cert. Tapos automatic na papasok dun ung name?
Good day
automatic po ba to mag create ng certificates based sa number ng list?
Sir pwede po b yan gawin sa Phone?thanks
pwede din po ba yan sa power point
Sir alam nyopoba kung pano sa mobile ung ganyan
ty
ask ko lang po sir, paano po gawin yung certificate in 2 columns po para po sana di masyadong malaki sa bond paper po para sa mga participants na nag attend ng seminar. kumbaga po 2 certificate in 1 bond paper ganun po sana, half ng bond paper. paano po gawin sa ms word? SANA PO MA BASA NIYO TO PO, Thank you po.
Same question hehehe
Anong size niya. Sir
Isang page ng certificate layout lang po ba ang kailangan? Then siya na po ba bahalang magreproduce ng layout base sa bilang ng recipients?
yes po :)
@@SirLouieTV thanks po Sir, tamang tama po ito, I’m serving as a secretariat po kasi sa isang workshop and seminar ng mga Brgy. officials, 200+ participants din yun, thanks pp ulit
Paano po pag dalawang cert sa isang bondpaper? I tried already po pero yung isang cert lang na-iinput ng names po eh
Burahin niyo po yung extra na page
Pwd bng dalawa ang heading na ilalagay? For example ay may name and LRN?
yes po, pwede po
Lezgo
pwde ba ito sir sa Publisher?
Good day. Pano po isave ng individual pdf people
hello po! may mga websites po tayong owedeng puntahan to convert the PDF File to individual PDFs :) Example po ito: smallpdf.com/split-pdf
Pwede po ba ito sa ms publisher sir?
yes po, mayroon din pong Mail Merge sa MS Publisher :) same procedure lang din po
@@SirLouieTV thank you sir.. more power 👍😊
Is it available for all MS Word version?
yes po :) kahit yung mga lumang versions meron din nung Mail Merge :)
Saan po galing ang format ser tnx po
yan po yung dating layout po ng school namin sir :)
Thanks po sa tutorial malaking tulong talaga.
Thanks sir Louie