How did you guys learn everything?

Initial E

New Member
Joined
Aug 28, 2012
Messages
18
I want to become very very knowledgeable in excel formulas and macros. I think I am very capable of calculating and performing most of the day to day type functions. However, I am weak when it comes to very complex and specific calculations. How did you guys become experts in everything that excel can do? What about macros?

Some advice would be appreciated to get me started. :)
 
I'm far from being an expert but besides reading which you must start immediately try making an excel with several basic codes

I have one with at least 30 basic-for me- codes such as
1.find last populated cell
2.find next empty column
3.Select specific range
4.Copy from to
and so on

Next thing i did was experiment on my own
 
Upvote 0

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Forum statistics

Threads
1,223,098
Messages
6,170,100
Members
452,301
Latest member
QualityAssurance

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
Back
Top