Want to enjoy the benefits of new Excel file format and having many files in old file format?
This video showing how you could get it done easily with VBA.
#Exce #Excesifu #Macro
Download eBook: The 5 Magic to Master Business Data
? https://5-secrets-biz-data.mailerpage.com
Connect to me in LinkedIn
https://www.linkedin.com/in/excelsifu
Like our FB
https://www.facebook.com/WhyExcel/
Music: https://www.bensound.com
...
https://www.youtube.com/watch?v=UwxJVUGm7Bk
This video is demonstrating how easy letters could be generated from Microsoft Excel. The context shown is preparing PKPB letter for staff to have inter-state travel.
#ExcelProject
#ExcelSifu
#PKPB
Connect to me in LinkedIn
https://www.linkedin.com/in/excelsifu
Like our FB
https://www.facebook.com/WhyExcel/
...
https://www.youtube.com/watch?v=WB_HTYtr2jo
This video is to show you how #Excel could easily compare two files easily. This strategy could be used in comparing sales, production, budget, quality control & etc.
Connect to me in LinkedIn
https://www.linkedin.com/in/excelsifu
Like our FB
https://www.facebook.com/WhyExcel/
...
https://www.youtube.com/watch?v=f5wZ8tZXbK4
With 3 simple steps, you could create a specific items from a specific #Excel data into #GoogleCalendar.
Formula used in step 3
=HYPERLINK("https://calendar.google.com/calendar/render?action=TEMPLATE&text="&[@[Event Title]]&"&location="&[@Location]&"&dates="&TEXT([@From],"yyyymmddThhmmss")&"/"&TEXT([@To],"yyyymmddThhmmss")&"&details="&[@Details],"Add")
Connect to me in LinkedIn
https://www.linkedin.com/in/excelsifu
Like our FB
https://www.facebook.com/WhyExcel/
...
https://www.youtube.com/watch?v=p55EF21YCtI
Mr. Patrick asked on what formula is available for him to automatically generate quotation number, where it will restart at every year.
...
https://www.youtube.com/watch?v=JT9Pmh5Orag
Special thanks to Mr. Jega on the encouraging words.
Connect to me in LinkedIn
https://www.linkedin.com/in/excelsifu
Like our FB
https://www.facebook.com/WhyExcel/
...
https://www.youtube.com/watch?v=ejHXyGLB0OI
Connect to me in LinkedIn
https://www.linkedin.com/in/excelsifu
Like our FB
https://www.facebook.com/WhyExcel/
...
https://www.youtube.com/watch?v=0vT_iMevPgY
Download eBook: The 5 Magic to Master Business Data
? https://5-secrets-biz-data.mailerpage.com
Follow Me in Odyess
? https://odysee.com/@ExcelSifu
Join Me in Odyess
? https://odysee.com/$/invite/HuxeoXKaUnv7eyTNkiYmNxUamL7rJjhT
Connect to me in LinkedIn
https://www.linkedin.com/in/excelsifu
Like our Facebook
https://www.facebook.com/WhyExcel/
Hash Tag
#ExcelSifu #MicrosoftExcel
...
https://www.youtube.com/watch?v=lovBrGWkywo