howENGINEERSdoit!
howENGINEERSdoit!
  • Видео 955
  • Просмотров 10 328 090
How to Auto-Format Power BI CSVs in Excel with VBA|Excel VBA Magic
Thanks for watching! If you have any queries, projects, training needs, or consulting needs related to:
1. PowerBI dashboards and reports, Excel Dashboard and Reports, CATIA Modeling
2. PMP/RMP/SP/Six Sigma Green Belt, ISO 9001:2015 Lead Auditor Certification
Feel free to contact me at catia.pro.user@gmail.com.
Enjoy the video? If you'd like to support the channel, you can use the "Super Thanks" feature to send a monetary donation directly through RUclips. Your support helps me create more valuable content-thank you!
Script used in the video:
Sub FormatCSV()
Dim ws As Worksheet
Set ws = ActiveSheet ' Use the currently active sheet
' Check if the sheet contains data before proceeding
If ws.UsedR...
Просмотров: 124

Видео

How to Check If a Sheet Is Referenced Before Deleting in Excel - Avoid Costly Mistakes!
Просмотров 53Месяц назад
Thanks for watching! If you have any queries, projects, training needs, or consulting needs related to: 1. PowerBI dashboards and reports, Excel Dashboard and Reports, CATIA Modeling 2. PMP/RMP/SP/Six Sigma Green Belt, ISO 9001:2015 Lead Auditor Certification Feel free to contact me at catia.pro.user@gmail.com. Enjoy the video? If you'd like to support the channel, you can use the "Super Thanks...
How to fix #REF! error in Excel easily|Best fix video till date for #REF! error
Просмотров 69Месяц назад
Thanks for watching! If you have any queries, projects, training needs, or consulting needs related to: 1. PowerBI dashboards and reports, Excel Dashboard and Reports, CATIA Modeling 2. PMP/RMP/SP/Six Sigma Green Belt, ISO 9001:2015 Lead Auditor Certification Feel free to contact me at catia.pro.user@gmail.com. Enjoy the video? If you'd like to support the channel, you can use the "Super Thanks...
xlookup not working| Formulas not working in Excel| How to fix
Просмотров 101Месяц назад
Thanks for watching! If you have any queries, projects, training needs, or consulting needs related to: 1. PowerBI dashboards and reports, Excel Dashboard and Reports, CATIA Modeling 2. PMP/RMP/SP/Six Sigma Green Belt, ISO 9001:2015 Lead Auditor Certification Feel free to contact me at catia.pro.user@gmail.com. Enjoy the video? If you'd like to support the channel, you can use the "Super Thanks...
Unlock the Power of Excel: Mastering the Filter Function! 📊💡
Просмотров 4455 месяцев назад
Thanks for watching! If you have any queries, projects, training needs, or consulting needs related to: 1. PowerBI dashboards and reports, Excel Dashboard and Reports, CATIA Modeling 2. PMP/RMP/SP/Six Sigma Green Belt, ISO 9001:2015 Lead Auditor Certification Feel free to contact me at catia.pro.user@gmail.com. Enjoy the video? If you'd like to support the channel, you can use the "Super Thanks...
How to Paste to Filtered Cells in Excel - Excel Hacks
Просмотров 1945 месяцев назад
Thanks for watching! If you have any queries, projects, training needs, or consulting needs related to: 1. PowerBI dashboards and reports, Excel Dashboard and Reports, CATIA Modeling 2. PMP/RMP/SP/Six Sigma Green Belt, ISO 9001:2015 Lead Auditor Certification Feel free to contact me at catia.pro.user@gmail.com. Enjoy the video? If you'd like to support the channel, you can use the "Super Thanks...
Dynamic range for Pivot tables using formula & named ranges|Dynamic data source for Pivot table
Просмотров 3,9 тыс.Год назад
Thanks for watching! If you have any queries, projects, training needs, or consulting needs related to: 1. PowerBI dashboards and reports, Excel Dashboard and Reports, CATIA Modeling 2. PMP/RMP/SP/Six Sigma Green Belt, ISO 9001:2015 Lead Auditor Certification Feel free to contact me at catia.pro.user@gmail.com. Enjoy the video? If you'd like to support the channel, you can use the "Super Thanks...
Create dynamic hyperlink to sheets in MS Excel|Quick & Cool Excel tips
Просмотров 6 тыс.Год назад
Thanks for watching! If you have any queries, projects, training needs, or consulting needs related to: 1. PowerBI dashboards and reports, Excel Dashboard and Reports, CATIA Modeling 2. PMP/RMP/SP/Six Sigma Green Belt, ISO 9001:2015 Lead Auditor Certification Feel free to contact me at catia.pro.user@gmail.com. Enjoy the video? If you'd like to support the channel, you can use the "Super Thanks...
What is EAC in PMP? How to calculate Estimate at completion (EAC) in PMP?
Просмотров 9102 года назад
Thanks for watching! If you have any queries, projects, training needs, or consulting needs related to: 1. PowerBI dashboards and reports, Excel Dashboard and Reports, CATIA Modeling 2. PMP/RMP/SP/Six Sigma Green Belt, ISO 9001:2015 Lead Auditor Certification Feel free to contact me at catia.pro.user@gmail.com. Enjoy the video? If you'd like to support the channel, you can use the "Super Thanks...
Passed PMP® exam in Jul 2021|Tips,Tricks & Recommendations|Above target on all domains!
Просмотров 2,9 тыс.3 года назад
Thanks for watching! If you have any queries, projects, training needs, or consulting needs related to: 1. PowerBI dashboards and reports, Excel Dashboard and Reports, CATIA Modeling 2. PMP/RMP/SP/Six Sigma Green Belt, ISO 9001:2015 Lead Auditor Certification Feel free to contact me at catia.pro.user@gmail.com. Enjoy the video? If you'd like to support the channel, you can use the "Super Thanks...
Fix/Improve TV performance in 4 mins!
Просмотров 3503 года назад
Thanks for watching! If you have any queries, projects, training needs, or consulting needs related to: 1. PowerBI dashboards and reports, Excel Dashboard and Reports, CATIA Modeling 2. PMP/RMP/SP/Six Sigma Green Belt, ISO 9001:2015 Lead Auditor Certification Feel free to contact me at catia.pro.user@gmail.com. Enjoy the video? If you'd like to support the channel, you can use the "Super Thanks...
Unable to change date format in Excel|Imported data date formatted as text Issue|How to Fix in 2 min
Просмотров 12 тыс.3 года назад
Thanks for watching! If you have any queries, projects, training needs, or consulting needs related to: 1. PowerBI dashboards and reports, Excel Dashboard and Reports, CATIA Modeling 2. PMP/RMP/SP/Six Sigma Green Belt, ISO 9001:2015 Lead Auditor Certification Feel free to contact me at catia.pro.user@gmail.com. Enjoy the video? If you'd like to support the channel, you can use the "Super Thanks...
Create DYNAMIC CHART in 3 mins!|Super Excel Trick
Просмотров 5393 года назад
Thanks for watching! If you have any queries, projects, training needs, or consulting needs related to: 1. PowerBI dashboards and reports, Excel Dashboard and Reports, CATIA Modeling 2. PMP/RMP/SP/Six Sigma Green Belt, ISO 9001:2015 Lead Auditor Certification Feel free to contact me at catia.pro.user@gmail.com. Enjoy the video? If you'd like to support the channel, you can use the "Super Thanks...
All about Dynamic Comparison Chart in Excel|Excel tips & tricks
Просмотров 1,2 тыс.3 года назад
Thanks for watching! If you have any queries, projects, training needs, or consulting needs related to: 1. PowerBI dashboards and reports, Excel Dashboard and Reports, CATIA Modeling 2. PMP/RMP/SP/Six Sigma Green Belt, ISO 9001:2015 Lead Auditor Certification Feel free to contact me at catia.pro.user@gmail.com. Enjoy the video? If you'd like to support the channel, you can use the "Super Thanks...
All about the INDIRECT function in Excel|Excel tips & Tricks
Просмотров 4 тыс.3 года назад
Thanks for watching! If you have any queries, projects, training needs, or consulting needs related to: 1. PowerBI dashboards and reports, Excel Dashboard and Reports, CATIA Modeling 2. PMP/RMP/SP/Six Sigma Green Belt, ISO 9001:2015 Lead Auditor Certification Feel free to contact me at catia.pro.user@gmail.com. Enjoy the video? If you'd like to support the channel, you can use the "Super Thanks...
Dynamic Range in Chart using OFFSET & Name Manager in 2 mins
Просмотров 2,6 тыс.3 года назад
Dynamic Range in Chart using OFFSET & Name Manager in 2 mins
Dynamic Dashboard-Formating the Dynamic Chart|Excel Tips & Tricks|P6
Просмотров 1533 года назад
Dynamic Dashboard-Formating the Dynamic Chart|Excel Tips & Tricks|P6
Dynamic Dashboard-Dynamic Chart title using IF and CELL function|Excel Tips & Tricks|P5
Просмотров 1943 года назад
Dynamic Dashboard-Dynamic Chart title using IF and CELL function|Excel Tips & Tricks|P5
Dynamic Dashboard-Linking Chart with Names Manager for Dynamic Chart Range|Excel Tips & Tricks|P4
Просмотров 2463 года назад
Dynamic Dashboard-Linking Chart with Names Manager for Dynamic Chart Range|Excel Tips & Tricks|P4
Dynamic Dashboard-Dynamic range for Chart using ADDRESS function|Excel Tips & Tricks|P3
Просмотров 1903 года назад
Dynamic Dashboard-Dynamic range for Chart using ADDRESS function|Excel Tips & Tricks|P3
Dynamic Dashboard-Create & Link slicers to Pivots|Excel Tips & Tricks|P2
Просмотров 1303 года назад
Dynamic Dashboard-Create & Link slicers to Pivots|Excel Tips & Tricks|P2
Dynamic Dashboard-Creation of section wise Pivot|Excel Tips & Tricks|P1
Просмотров 1703 года назад
Dynamic Dashboard-Creation of section wise Pivot|Excel Tips & Tricks|P1
How to add third axis in Excel chart|Tertiary/Additional axis|Excel tips & Tricks
Просмотров 17 тыс.3 года назад
How to add third axis in Excel chart|Tertiary/Additional axis|Excel tips & Tricks
How to create dynamic dashboard using Pivot|Excel tips and tricks
Просмотров 3733 года назад
How to create dynamic dashboard using Pivot|Excel tips and tricks
How to create simple dynamic dashboard using sumifs,countifs in Excel|Excel tips & Tricks
Просмотров 9963 года назад
How to create simple dynamic dashboard using sumifs,countifs in Excel|Excel tips & Tricks
How to delete any Pivot table in Excel easy way|Excel tips and Tricks
Просмотров 23 тыс.3 года назад
How to delete any Pivot table in Excel easy way|Excel tips and Tricks
How to remove accent from Names in excel at once|Excel Tips & Tricks
Просмотров 32 тыс.3 года назад
How to remove accent from Names in excel at once|Excel Tips & Tricks
How to filter merged cells in excel|Filter not working for merged cell in Excel
Просмотров 118 тыс.3 года назад
How to filter merged cells in excel|Filter not working for merged cell in Excel
"Contacts from your read only accounts cannot be deleted"-How Fix-Delete duplicate Android
Просмотров 48 тыс.4 года назад
"Contacts from your read only accounts cannot be deleted"-How Fix-Delete duplicate Android
Top 5 interesting things to do at your home which will improve your quality of life
Просмотров 7124 года назад
Top 5 interesting things to do at your home which will improve your quality of life

Комментарии

  • @familienviig2207
    @familienviig2207 6 часов назад

    Too har to see the fomulas

  • @All_in_one3452
    @All_in_one3452 День назад

    is this possible default msg while opening catia without clicking anything

  • @KumuduDissanayake-eq8bm
    @KumuduDissanayake-eq8bm 10 дней назад

    This is so helpful 🤗

  • @abhinav5071
    @abhinav5071 11 дней назад

    How to make configuration in assembly eg. Cylinder open or close

  • @sportchrono6835
    @sportchrono6835 16 дней назад

    Can you send me the formula please

  • @monishshaji6014
    @monishshaji6014 17 дней назад

    Very important for me thanks very much

  • @miebakakoroma3180
    @miebakakoroma3180 20 дней назад

    thnk u sir. am overwhelmed 😊

  • @dothevinh6612
    @dothevinh6612 Месяц назад

    great clip

  • @ChristopherGalina
    @ChristopherGalina Месяц назад

    Very helpful, thanks!

  • @jr_lin_ym
    @jr_lin_ym Месяц назад

    THANK YOU...I WANT TO RID THE PIN FOR A LONG TIME AND IT MAKES ME ANNOY WHEN EVER I OPEN THE PHONE.

  • @shweyee2695
    @shweyee2695 Месяц назад

    Thanks a lot mate. I subscribed

  • @TheTranspoter3
    @TheTranspoter3 Месяц назад

    What if we want new item in that column . What is solution for adding new item to the list will it be filtered ?

  • @maggidishashank1847
    @maggidishashank1847 2 месяца назад

    Hiiii bro, I have one doubt, I want to save the file in one folder assembly, by using save management created another folder same assembly in another folder I had changed the assembly parts, it will effect original file assembly?

  • @vincentyap3188
    @vincentyap3188 2 месяца назад

    no need to do all these just turn off your pc when it is off turn on your monitor when line appear must be the monitor no others thing, because everything is off cannot be the grahic card, driver etc however mine is a desk top with a monitor connect to the cpu

  • @syaduddingrr3154
    @syaduddingrr3154 2 месяца назад

    hey i got some problem, when i'm doing advanced machine at setup macro management i can't see my 'current macro toolbox' for example .. i want to do add ramping motion,add motion perpendicular and else.. this tool box are small and i can't choose it.. can you help me?

  • @aishwaryajoseph49
    @aishwaryajoseph49 2 месяца назад

    Oh my goodness! You have no idea how much this video helped me! in the right time. God bless you

  • @Rd-yj5jj
    @Rd-yj5jj 3 месяца назад

    thanku

  • @YeshitaReddy
    @YeshitaReddy 3 месяца назад

    Sir , even though I followed all the steps I am not able to get the profile and operations tools could you please help sir

  • @bojackson4125
    @bojackson4125 3 месяца назад

    The attempt at sounding western in this video made it unwatchable for me.

  • @OtocinclusAffinis
    @OtocinclusAffinis 3 месяца назад

    How do I force it to produce multiple single segments instead of composite tolerance?

  • @cocosparadise7561
    @cocosparadise7561 3 месяца назад

    Kuch bhi waste info

  • @flampe2815
    @flampe2815 3 месяца назад

    Du bist einfach ein geiler Typ!

  • @yamigaruza1159
    @yamigaruza1159 3 месяца назад

    Thank you so much for this tutorial!

  • @jnunyabizio5169
    @jnunyabizio5169 4 месяца назад

    I can't follow this. I hate my life

  • @sandipansaha1296
    @sandipansaha1296 4 месяца назад

    From few days, I'm seeing thin black horizontal lines on my hp laptop screen, the lines become prominent in colors like violet and red and in other colors these lines can barely be seen.. I've put the refresh rate to 40 from 60 and now the lines are there but a bit less prominent.. I've tried pressing edges but lines are still there..and also updated my nividia graphics driver and display drivers..what can be a fix..can it be a loose cable connection or a problem with the lcd panel...thanks..

  • @jdescario
    @jdescario 4 месяца назад

    Lifesaver!!

  • @uttamkumar-lr4zu
    @uttamkumar-lr4zu 4 месяца назад

    Very nice sir

  • @aaroneipejohn5715
    @aaroneipejohn5715 4 месяца назад

    Could you help me in converting a cylindrical part made in part design to be unfolded in generative Sheetmetal workbench please?

  • @sebadg7
    @sebadg7 5 месяцев назад

    Very useful thanks

  • @davidmertes6308
    @davidmertes6308 5 месяцев назад

    Is there an option to change the numbers in the Assembly ?

  • @avevae3ddesigner84
    @avevae3ddesigner84 5 месяцев назад

    Thanks lot of time save

  • @abzdabzorba6578
    @abzdabzorba6578 5 месяцев назад

    Dude slow down, I can barely see what you're doing, why this hurry!

    • @howENGINEERSdoit
      @howENGINEERSdoit 5 месяцев назад

      It's a quick tip and people like fast content nowadays. Moreover there is an option on RUclips itself to slowdown the video if required. Thanks for your feedback! Happy learning

  • @lovecastle7154
    @lovecastle7154 5 месяцев назад

    I think you can also do this with alt+semicolon once the column is selected

  • @blunderville
    @blunderville 5 месяцев назад

    Use the delete button on the keyboard

  • @yamenmoner6203
    @yamenmoner6203 6 месяцев назад

    good work mohamad

  • @karlschuneman7960
    @karlschuneman7960 6 месяцев назад

    That didn't work.

  • @brajeshparmar7731
    @brajeshparmar7731 6 месяцев назад

    Thanks brother.

  • @miguelbanon2476
    @miguelbanon2476 6 месяцев назад

    Very useful! ;)

  • @Nictroxic
    @Nictroxic 6 месяцев назад

    thank you! worked like a charm

  • @SHITIA-R1863
    @SHITIA-R1863 7 месяцев назад

    CATIA is shit, NX is the best.

  • @caddesign3303
    @caddesign3303 7 месяцев назад

    ruclips.net/video/-jkq5i31ijw/видео.htmlsi=2g55ZABIUmdHOmgj

  • @skotodushegubka
    @skotodushegubka 7 месяцев назад

    CATIA sucks

  • @Guancho8719
    @Guancho8719 8 месяцев назад

    Thank you

  • @rajkumarindia9284
    @rajkumarindia9284 8 месяцев назад

    Thx' great. It worked for my j2 samsung.

  • @maskoff7123
    @maskoff7123 8 месяцев назад

    Bhai plz make one complete video..

  • @SureshKumar-ou1eh
    @SureshKumar-ou1eh 8 месяцев назад

    can you plese provide 2d drafting fdf pls!

  • @rochellejanewski9587
    @rochellejanewski9587 9 месяцев назад

    Thank you for helping me solve my problem. I would never have figured this out on my own. You made it so easy to fix!

  • @tuna9444
    @tuna9444 9 месяцев назад

    My Dell laptop is 9 years old and if it is open all the way there are vertical lines moving rapidly, but when I only leave it about 7 inches open it is okay. It's hard to type and see when it's open so narrow as this. Anybody got a clue what might be wrong with this laptop I would appreciate any help. Thanks.

  • @AmitKumar-se4gc
    @AmitKumar-se4gc 9 месяцев назад

    May u please make video on Catia assembly from scratch?

  • @AmitKumar-se4gc
    @AmitKumar-se4gc 9 месяцев назад

    where do i find assembly tutorial ?