1

all basic functions EXCEL

What are all the basic functions for working with data in Excel?

What are all the basic functions for working with data in Excel?

1 answer

  • Upvotes
  • Date ascending
  • Date descending
Book a coaching with Vlad

97% Recommendation Rate

374 Meetings

5,822 Q&A Upvotes

USD 229 / Coaching

Hi,

Basics

  • Fast excel - throw away your mouse and put some tape on your touchpad. Do everything with your keyboard!
  • The main formulas (especially vlookup, column, etc)
  • Pivot tables
  • Nice formating
  • Modeling - you need at least to know how to structure your sheets (Inputs, outputs, sources, versions, etc)

Advanced skills include:

  • Financial modeling (making proforma statement)
  • Valuation of projects / companies

You should better be good with both if you don't want to have issues with your performance

Best!

Hi,

Basics

  • Fast excel - throw away your mouse and put some tape on your touchpad. Do everything with your keyboard!
  • The main formulas (especially vlookup, column, etc)
  • Pivot tables
  • Nice formating
  • Modeling - you need at least to know how to structure your sheets (Inputs, outputs, sources, versions, etc)

Advanced skills include:

  • Financial modeling (making proforma statement)
  • Valuation of projects / companies

You should better be good with both if you don't want to have issues with your performance

Best!

Related BootCamp article(s)

Interviewer-Led vs Candidate-Led cases

Case Interviews can be led by the candidate or by the interviewer: In Candidate-led cases the main challenge is the structure. In Interviewer-led cases the main challenge is to adapt quickly

Related case(s)

Bain case: Asian lubricants producer

Solved 112.6k times
Bain case: Asian lubricants producer LubricantsCo, a very successful Asian premium producer of lubricants in their native region, would like to further increase their revenue and profit. The product range ranges from lubricants in the automotive sector (e.g. motor and gear oil) to industrial applications (e.g. fats, heavy-duty oils). According to preliminary examinations, further growth potentials in the Asian core market are rather limited. Thus LubricantsCo would like to investigate options to internationalize in the passenger car business – also outside the premium segment which is given priority. Therefore your consulting firm was instructed to elaborate a market entry strategy for the European market.  
4.7 5 27815
| Rating: (4.7 / 5.0)

LubricantsCo, a very successful Asian premium producer of lubricants in their native region, would like to further increase their revenue and profit. The product range ranges from lubricants in the automotive sector (e.g. motor and gear oil) to industrial applications (e.g. fats, heavy-duty oils). ... Open whole case

Deloitte Consulting case: Footloose

Solved 60.2k times
Deloitte Consulting case: Footloose Duraflex is a German footwear company with annual men’s footwear sales of approximately €1 b. They have always relied on the boot market for the majority of their volume. In this market they compete with three other major competitors. In the fall of 2019, Badger – one of Duraflex’s competitiors – launched a new line of aggressively priced work boots. The strong success of this line has caused Duraflex’s management to re-evaluate their position in work boots. With limited additional resources, the management must now decide if they should focus their efforts on competing with Badger in the work boot sector, or allocate their resources on further strengthening their position with casual boots. The management team approached you and asked for your advice. In order to advise them on their future work boot strategy please prepare first some insights regarding market size and competitive landscape.
4.5 5 12803
| Rating: (4.5 / 5.0)

Duraflex is a German footwear company with annual men’s footwear sales of approximately €1 b. They have always relied on the boot market for the majority of their volume. In this market they compete with three other major competitors. In the fall of 2019, Badger – one of Duraflex’s competitiors – ... Open whole case

Bain Case: Old Winery

Solved 45.9k times
Bain Case: Old Winery You have inherited the “Old Winery” from your grandfather, a winery which has been family owned for five generations and can be dated back to the 16th century. Half of the eleven hectares are used to grow white grapes, the other half to grow red grapes. They are grown in the conventional way, i.e. they are not organically farmed and certified. The vine stocks are in a good condition regarding age and care. Overall, only ¼ of the harvest is made into wine by the winery itself; the rest is sold. Your grandfather never wanted to change the image of the winery and left the managerial and administrative task to a young and energetic wine-maker. Due to the not so well-known brand , the demand for the “Old Winery” wine is currently rather low. You do not intent to run the winery operatively, given your limited knowledge of wine making, but find the idea of owning a winery exciting. Your plan is to give the winery some fresh impetus.
4.4 5 1199
| Rating: (4.4 / 5.0)

You have inherited the “Old Winery” from your grandfather, a winery which has been family owned for five generations and can be dated back to the 16th century. Half of the eleven hectares are used to grow white grapes, the other half to grow red grapes. They are grown in the conventional way, i.e. ... Open whole case

McKinsey Questions

Solved 34.4k times
McKinsey Questions Tell me of a situation where you had an opinion and no one seemed to agree with you. What was your goal when you decided to join university / work / clubs / a sports team? Did you have a goal that you were not able to reach? What did you do? What do you want to be remembered for and how are you achieving it? What is your typical way of dealing with conflict?
4.5 5 840
| Rating: (4.5 / 5.0) |
Difficulty: Intermediate | Style: Fit interview | Topics: Personal fit

Tell me of a situation where you had an opinion and no one seemed to agree with you. What was your goal when you decided to join university / work / clubs / a sports team? Did you have a goal that you were not able to reach? What did you do? What do you want to be remembered for and how are you ... Open whole case

BCG Questions

Solved 23.8k times
BCG Questions What arouses your interest when you are working / studying / doing another activity (from the CV)? Tell me of a time where you had no idea what you were doing. When did you use an uncommon approach to do something? Have you ever had responsibility for other people? Tell me of a situation where you were not the official leader.
4.5 5 203
| Rating: (4.5 / 5.0) |
Difficulty: Intermediate | Style: Fit interview | Topics: Personal fit

What arouses your interest when you are working / studying / doing another activity (from the CV)? Tell me of a time where you had no idea what you were doing. When did you use an uncommon approach to do something? Have you ever had responsibility for other people? Tell me of a situation where ... Open whole case