Excel Forum

data analysis

Carl Stiller

Active Member

Members

Forum Posts: 3

Member Since:
October 20, 2020

Offline

May 2, 2022 - 1:53 am

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

Catalin Bombea

Iasi, Romania

Admin

Forum Posts: 1810

Member Since:
November 8, 2013

Offline

May 4, 2022 - 1:02 pm

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.myonlinetraininghu.....ard-course

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online: Riny van Eekelen, Malcolm Seymour, Dieneba NDIAYE, Wesley Burchnall, Brett Dryland

Guest(s) 9

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 871

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

Jessica Stewart: 204

A.Maurizio: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

Brett Dryland

Saeed Aldousari

Bhuwan Devkota

Kathryn Patton

Maria Conatser

Jefferson Granemann

Glen Coulthard

Nikki Fox

Rachele Dickie

Raj Mattoo

Forum Stats:

Groups: 3

Forums: 24

Topics: 6221

Posts: 27290

Member Stats:

Guest Posters: 49

Members: 31912

Moderators: 3

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Velouria, Riny van Eekelen