Forum

Notifications
Clear all

data analysis

2 Posts
2 Users
0 Reactions
145 Views
(@carlstiller)
Posts: 3
Active Member
Topic starter
 

Hi forum

I would be very interested to learn 1 thing.
 
What skill or skills would be the most important one in order to becomes highly efficient or skilled within "data analysis" using Excel? (example: formatting, formulas, function, setting target for analysis etc etc).
 
Much applies for any type of input and have a great week-end!
 

All the best, Carl Stiller

 
Posted : 02/05/2022 11:53 am
(@catalinb)
Posts: 1937
Member Admin
 

Hi Carl,

I suggest:

Power Query, if data needs to be reorganized (usually it does, in order to get a specific report, you need to design the data structure)

Pivot tables,

Power Pivot Tables.

There is also a dashboard course that will clarify many things, including formatting, formulas, for regular charts. https://www.myonlinetraininghub.com/excel-dashboard-course

 
Posted : 04/05/2022 11:02 pm
Share: