the most important things to learn in excel

4pbears

New Member
Joined
Dec 20, 2002
Messages
8
as a rookie to excel, i am curious where i should focus my time and effort in learning excel. by that i mean other than getting a good basic understanding of how excel works, what things in excel should i concentrate on learning. should i concentrate on charts, pivot tables, functions, etc.



Thanks.



Dave. P.
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

bandit_1981

Board Regular
Joined
Aug 17, 2005
Messages
201
This is just me but i find the hardest part is not recreating the wheel. Many times on a spreadsheet i will hop into VBA and make a function etc for a complex formula that excel could have done by itself if i knew the way it worked better. Learn the basic structures and try to make it work in excel first VBA second imo.
 

Joe Was

MrExcel MVP
Joined
Feb 19, 2002
Messages
7,539
For basic Excel, "Sheet Functions" [Concentrate on topics that you will use! Why study Finance functions when you will never use them?] then "Formatting" [Both Cell and Sheet; Making your application look good, be user friendly and efficent to use.] "VBA" [How to code basic Subs to advance Excel's funtionality.].
 

Watch MrExcel Video

Forum statistics

Threads
1,123,263
Messages
5,600,595
Members
414,391
Latest member
Pandurang

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