tutorials

  1. D

    Where to acquire advanced - really advanced excel skills

    So I was introduced to excel 3 years ago. (I'm 18 btw). I just learned the sum function and was sooo amazed, and I built a complex "model" for my schools student grant allotment [i did it for fun, and they accepted it :), i caught on pretty quickly.. etc...] Then I watched excelisfun on...
  2. M

    Using Left in VBA

    Hi, I'd like to change the following code such that only the Left three characters of the Department value are taken. Left tutorials aren't helping me much. With ws .Cells(ERow, 1).Value = Me.ptmember.Value .Cells(ERow, 2).Value = Me.StudyRole.Value .Cells(ERow, 4).Value =...
  3. S

    How To Move Entire Row To Various Sheet Based On Cell Value In Excel?

    Hello everyone, all the tutorials I've search has the same result. Most tutorials shows you how to copy the Row from Sheet 1 to Sheet 2 only. Maybe I am not searching it properly? What I need is to COPY Row from Sheet 1 to Sheet 2 OR Sheet 3 OR Sheet 4 depending on the value on Column "M" Can...
  4. H

    Excel Power Query Tutorials

    I am new to Power Query and would appreciate it, if someone could recomend a few online tutorials as well as online training on this topic
  5. N

    Good idea? Maybe?

    Hello All, So I joined this forum back in 2016 and since then have learned SO MUCH INFORMATION that has helped me and now I am able to help others that were lie me before i joined here. It has been an awesome ride and I really enjoy it. With that being said I have been thinking about making a...
  6. S

    Macro beginner questions

    Hi, Over the last week I've been teaching myself to develop very simple macros with goals of becoming a master one day. My questions in red are: 1. can anyone recommend beginner tutorial sites similar to this one that I've been using https://www.homeandlearn.org/index.html? 2. Ultimately, I...
  7. C

    Userform from existing database

    Hi all I have an existing excel database which i'd like to 'maintain' with the help of a purpose made Userform. It contains 64 columns of fields (one of which being the record name), with a different row for each record. The database already consists of mainly drop down boxes, with a few free...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top