lifedesigner9
lifedesigner9
  • Видео 50
  • Просмотров 269 453

Видео

Combining Multiple Workbooks Into One (Simple VBA)
Просмотров 372Год назад
I am a dummy in VBA, can only do COPY & PASTE, but somehow managed to combine MANY workbooks into ONE workbook. On the other hand, you may also SORT based on the Worksheet Tabs in ascending order. Hope it's useful. Thanks to these references I have found on Website: ruclips.net/video/JiAYngRcN0s/видео.html www.exceljunction.com/combine-multiple-excel-workbooks-into-one-workbook/ www.automateexc...
Excel | Validation + IndexMatch & vLookup
Просмотров 3162 года назад
Excel | Validation IndexMatch & vLookup
How to Autofill Formulas in Excel Quickly
Просмотров 4242 года назад
How to Autofill Formulas in Excel Quickly
How to Autofill Formulas in Excel without Dragging | Using Shortcuts
Просмотров 76 тыс.2 года назад
How to Autofill Formulas in Excel without Dragging | Using Shortcuts
How to Autofill in Excel without Dragging | Using Fill Series
Просмотров 4,8 тыс.2 года назад
How to Autofill in Excel without Dragging | Using Fill Series
How to Add a Blank Row after each Subtotal | Excel 2019
Просмотров 9352 года назад
How to Add a Blank Row after each Subtotal | Excel 2019
How to Add a Blank Row after each category using Constant | Excel 2019
Просмотров 432 года назад
How to Add a Blank Row after each category using Constant | Excel 2019
ICDL Word 2019 | Q41 - Q69 | Diagnostic Test
Просмотров 6 тыс.3 года назад
ICDL Word 2019 | Q41 - Q69 | Diagnostic Test
ICDL Word 2019 | Q1 - Q20 | Diagnostic Test
Просмотров 8 тыс.3 года назад
ICDL Word 2019 | Q1 - Q20 | Diagnostic Test
ICDL Word 2019 | Q21 - Q40 | Diagnostic Test
Просмотров 6 тыс.3 года назад
ICDL Word 2019 | Q21 - Q40 | Diagnostic Test
ICDL Advanced Word 2019 | Q31 - Q40 | Diagnostic Test
Просмотров 4,4 тыс.3 года назад
ICDL Advanced Word 2019 | Q31 - Q40 | Diagnostic Test
ICDL Advanced Word 2019 | Q21 - Q30 | Diagnostic Test
Просмотров 4 тыс.3 года назад
ICDL Advanced Word 2019 | Q21 - Q30 | Diagnostic Test
ICDL Advanced Word 2019 | Q11 - Q20 | Diagnostic Test
Просмотров 5 тыс.3 года назад
ICDL Advanced Word 2019 | Q11 - Q20 | Diagnostic Test
ICDL Advanced Word 2019 | Q41 - Q47 | Diagnostic Test
Просмотров 2,7 тыс.3 года назад
ICDL Advanced Word 2019 | Q41 - Q47 | Diagnostic Test
ICDL Advanced Word 2019 | Q1 - Q10 | Diagnostic Test
Просмотров 9 тыс.3 года назад
ICDL Advanced Word 2019 | Q1 - Q10 | Diagnostic Test
ICDL Computer Essential | Q61 - Q82 | Diagnostic Test
Просмотров 3,8 тыс.3 года назад
ICDL Computer Essential | Q61 - Q82 | Diagnostic Test
ICDL Computer Essential | Q41 - Q60 | Diagnostic Test
Просмотров 3,8 тыс.3 года назад
ICDL Computer Essential | Q41 - Q60 | Diagnostic Test
ICDL Computer Essential | Q1 - Q20 | Diagnostic Test
Просмотров 8 тыс.3 года назад
ICDL Computer Essential | Q1 - Q20 | Diagnostic Test
ICDL Computer Essential | Q21 - Q40 | Diagnostic Test
Просмотров 3,7 тыс.3 года назад
ICDL Computer Essential | Q21 - Q40 | Diagnostic Test
ICDL Excel 2019 | Q26 - Q50 | Diagnostic Test
Просмотров 6 тыс.3 года назад
ICDL Excel 2019 | Q26 - Q50 | Diagnostic Test
ICDL Excel 2019 | Q1 - Q25 | Diagnostic Test
Просмотров 9 тыс.3 года назад
ICDL Excel 2019 | Q1 - Q25 | Diagnostic Test
ICDL Excel 2019 | Q51 - 73 | Diagnostic Test
Просмотров 4,5 тыс.3 года назад
ICDL Excel 2019 | Q51 - 73 | Diagnostic Test
ICDL Online Essential | Q50 - 76 | Diagnostic Test
Просмотров 3 тыс.3 года назад
ICDL Online Essential | Q50 - 76 | Diagnostic Test
ICDL Online Essential | Q26 - 50 | Diagnostic Test
Просмотров 3,2 тыс.3 года назад
ICDL Online Essential | Q26 - 50 | Diagnostic Test
ICDL Online Essential | Q1 - 25 | Diagnostic Test
Просмотров 6 тыс.3 года назад
ICDL Online Essential | Q1 - 25 | Diagnostic Test
ICDL Photoshop | Q1 - 20 | Diagnostic Test
Просмотров 1,1 тыс.3 года назад
ICDL Photoshop | Q1 - 20 | Diagnostic Test
ICDL Photoshop | Q21 - 40 | Diagnostic Test
Просмотров 1 тыс.3 года назад
ICDL Photoshop | Q21 - 40 | Diagnostic Test
ICDL Photoshop | Q41 - 62 | Diagnostic Test
Просмотров 5803 года назад
ICDL Photoshop | Q41 - 62 | Diagnostic Test
ICDL Digital Marketing | Q41 - 66 | Diagnostic Test
Просмотров 3,3 тыс.3 года назад
ICDL Digital Marketing | Q41 - 66 | Diagnostic Test

Комментарии

  • @GarrettBM
    @GarrettBM 3 дня назад

    Very helpful - thank you. 🙂

  • @trade4lifeee
    @trade4lifeee 14 дней назад

    I just impressed my girl thank you 😂

  • @panellhnies
    @panellhnies 25 дней назад

    Thanks !!!!!!

  • @a7xfan778
    @a7xfan778 26 дней назад

    Having some problems. I'm trying to auto fill division horizontally. But I need all cells divided by one cell. I have =b13/j2 but when I auto fill, it goes c13/k2. I need the 2nd cell to.remain j2

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

    thanks for this useful method.

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

    Ok thank i ve understood

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

    It doesn't work to me

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

    Hi,Please where did you get vba code text from ?

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

      Its in my above content actually www.exceljunction.com/combine-multiple-excel-workbooks-into-one-workbook/#google_vignette www.automateexcel.com/vba/sort-tabs/ Hope it helps. :)

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

    thanks man you really helped meeee (i have a competition on this and this si exactly what i was looking for :) )

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

    One of the most important video

  • @LubnaNaz-b2p
    @LubnaNaz-b2p 3 месяца назад

    please can you upload icdl advance database diagnostic?

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

    Thanks a lot! I spent so much time trying to drag down the formula into the other cells and this trick really helped me!

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

    Thank you, this saves a lot of time

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

    Quick and easy😊

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

    Thanks buddy ot worked

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

    Awesome

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

    just fucking talk if you are going to make a video

  • @fornow-hf4hy
    @fornow-hf4hy 7 месяцев назад

    🙏🏽audio would be nice

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

    5:24 in this question, you didn't stop recording using the macro. it wasn't asked in the question, so that wouldn't make the answer wrong? i'm asking, just in case this question pops up in my exam tomorrow.

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

      Hi Darren, you have to stop recording macro before you save your file or go to the next question, or else it will pose an issue and continue to record. hope it helps. Thank you.

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

    did he pass

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

    OK finally, the required elegant solution that I knew must exist out there somewhere. Thanks.

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

    tqsm. u saved me a lot of time. appreciated much 😀

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

      You are most welcome. I'm happy to hear it helps.😄

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

    Hello sir How can we put headings in those blank rows ??

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

    Thank you

  • @LubnaNaz-b2p
    @LubnaNaz-b2p 9 месяцев назад

    Thanks for these videos, can you upload of diagnostic of Advance Access?

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

    Thanks 😍

  • @wagonwalk
    @wagonwalk 10 месяцев назад

    Thank you, so easy. This is a life saver.

  • @starfeesh8937
    @starfeesh8937 10 месяцев назад

    Crtl+D is save tab as favorite. Is there a way to go around that?

  • @RaydeanScerri
    @RaydeanScerri Год назад

    thank you so much. do you have the one for teamwork module please ?

  • @greengrassofhome
    @greengrassofhome Год назад

    What are you doing with the IF function at 3:15, please? It seems like you are adding an 'S' before and after the K and another one before and after the N? What is that and why?

    • @lifedesigner9787
      @lifedesigner9787 Год назад

      Hi, actually that is not an 'S', it's a dollar sign $. In excel, everytime you do auto fill, what happen is the formula will automatically eg. Multiply by K2, then K3, then K4, which those are empty cells. In this case, later you will get errors and wrong answers.therefore , if you go back to 'K2' and 'N2', you need to lock both by adding $ sign to LOCK it. Eg. $K means lock column, $2 means lock the row. You can try not to lock ($) first, then you autofill and drag down, after wards you take a look at the formula, you will understand why I fixed $. Hope it helps..thank you. Keep going. :)

    • @lifedesigner9787
      @lifedesigner9787 Год назад

      @greengrassofhome so sorry, you can refer to my answer on the next comment. :)

  • @Mr.Nobody_69
    @Mr.Nobody_69 Год назад

    Shouldn't question number 36 be people with visual impairments? PS: Awesome videos really useful thank you.

  • @ien3a182
    @ien3a182 Год назад

    thanks

  • @ahmedm.alfadhel272
    @ahmedm.alfadhel272 Год назад

    excllento

  • @iambloopy
    @iambloopy Год назад

    Thank you you’re amazing

  • @saketh712
    @saketh712 Год назад

    what did u do at 0:14 ?

    • @lifedesigner9787
      @lifedesigner9787 Год назад

      I highlight C4, then on my keyboard I press function key F4 (First row of keyboard), it is a shortcut to lock the column $C and row $4 cell. In case F4 is unable to work, then you have to press FN and F4 together to achieve that. Hope it helps.

  • @petrjezek3547
    @petrjezek3547 Год назад

    24 is wrong

    • @lifedesigner9787
      @lifedesigner9787 Год назад

      Hi,I just checked, it is right. Probably you can highlight to me what is the mistake? Thanks so much.

  • @phuongbui1156
    @phuongbui1156 Год назад

    Can you try some test questions?Can you try some test questions?

  • @josephzammit6485
    @josephzammit6485 Год назад

    Thank you for providing these videos.

  • @johnnyma9926
    @johnnyma9926 Год назад

    bro play minecraft

  • @HUT228
    @HUT228 Год назад

    Hey I have a opinion pls, The Q17 that the answer I think is not that file, you need to press your mouse into the icon that above the other icon and next to the icon "New Folder".

    • @HUT228
      @HUT228 Год назад

      Pls this make you reply

    • @lifedesigner9787
      @lifedesigner9787 Год назад

      Hi, thanks for bringing this up😊..no worries, this is one of the correct answers too. Meaning when you 'right click' on winword.exe, the create shortcut menu will come out. 😊

    • @HUT228
      @HUT228 Год назад

      @@lifedesigner9787 Oh year, Thanks for your reply!

    • @lifedesigner9787
      @lifedesigner9787 Год назад

      @@HUT228 You are most welcome. :)

    • @johnnyma9926
      @johnnyma9926 Год назад

      duma day la anh hoang 6³ phai k ha

  • @sbnerji12555
    @sbnerji12555 Год назад

    Thanks 😊👍

  • @cariejustineestrellado5240
    @cariejustineestrellado5240 Год назад

    how about going horizontally? do you have tricks?

  • @edrielgonzagatv5059
    @edrielgonzagatv5059 Год назад

    SHOULD REMOVE THE BACKGROUND MUSIC IS ANNOYING

  • @treadsoftlyonmyheart
    @treadsoftlyonmyheart Год назад

    Thank you so much!

  • @edjones4544
    @edjones4544 Год назад

    Hi there, thanks for this. Are all these answers completely correct? Just have a question on protecting the cells and only certain cells. Otherwise this seems straight forward.

    • @lifedesigner9787
      @lifedesigner9787 Год назад

      Hi Jones, yes the diagnostic test answers are correct. I understand what you meant. For test, you need to follow their instructions, so like what you have mentioned, if they asked you to protect certain range you have to follow. So no worries. Hope it helps. :)

  • @Dansk55
    @Dansk55 Год назад

    Very easy to follow. Thanks much

  • @cabaasyare701
    @cabaasyare701 Год назад

    ICDL IT SECURITY PLEASE

  • @Iamshomarid
    @Iamshomarid Год назад

    The goat of all goats 🎉

  • @nelsonhuezo5385
    @nelsonhuezo5385 Год назад

    GOATT

  • @tracymcc8447
    @tracymcc8447 2 года назад

    Best tutorial video for the ICDL series. Thank you very much!