Brehs, I need to learn Microsoft excel ASAP

Scholar

Superstar
Joined
Dec 11, 2015
Messages
8,939
Reputation
795
Daps
24,345
Just got a job offer as a research analyst and we will be using Microsoft excel, haven't touched that shyt since college 2 years ago and I'm completely wiped clean of any knowledge from it. We won't be using complex excel stuff but just the basics (VLOOKUP, pivot tables, graphs from numerical data, etc)


Any websites or programs I can learn excel from
Were you able to learn in time ?
 

Macallik86

Superstar
Supporter
Joined
Dec 4, 2016
Messages
6,820
Reputation
1,622
Daps
22,487
FYI most people in the field just google stuff repeatedly until it syncs in.

Gotta step your VLOOKUP game up for sure though.
 

beenz

Rap Guerilla
Joined
May 1, 2012
Messages
83,294
Reputation
10,596
Daps
189,995
Reppin
The Chi (South Side)
Just got a job offer as a research analyst and we will be using Microsoft excel, haven't touched that shyt since college 2 years ago and I'm completely wiped clean of any knowledge from it. We won't be using complex excel stuff but just the basics (VLOOKUP, pivot tables, graphs from numerical data, etc)


Any websites or programs I can learn excel from

pivots are simple. it's just a simplified way of filtering data. vlookups can be tricky, but you can use youtube to get tutorials on that.

you should be able to figure out the graphing basics by simply using the wizard built into excel.
 

MarcMan

Superstar
Joined
Jan 16, 2015
Messages
2,572
Reputation
883
Daps
14,863
First, I cosign all of the people saying to search the web as practically anything you need to know can be found. But I would also add that people learn by doing. I would start by finding out something you want to do. That can be simplifying a process, forecasting a number, whatever. Then start building. As you run into issues look for a solution to your current problem. That way, you learn not only what you can do but the how it works and where it can applied and be useful.

As a final note, VLOOKUP and HLOOKUP are usually fine, but INDEX can save you a few headaches down the line with particularly complex workbooks.
 
Joined
Nov 17, 2016
Messages
1,538
Reputation
431
Daps
7,412
Reppin
Metro Atlanta
FYI most people in the field just google stuff repeatedly until it syncs in.

Gotta step your VLOOKUP game up for sure though.
Literally all I did in my last corporate analyst job. I had no idea what I was doing and Googled everything during the first 2-3 weeks. After a month, a lot of it became second nature.
 
Top