Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
30
Views
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
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