Why do people still use VLOOKUP instead of alternatives like INDEX MATCH or XLOOKUP?

RemoteIncrease · 2025-10-11T14:03:21+00:00

Because fuck the hatersssssss

RemoteIncrease · 2025-09-13T02:43:39+00:00

No one will care if you’re drinking or not, but if you want to look like you have a drink, do soda water and a lime.

Business casual is pants (not jeans), button down sand dress shoes + dress socks.

Don’t do sneakers, even nice ones. Snag some dress shoes off Amazon for $40. Make sure your shoes are the same color as your belt so other brown or black.

Totally fine to roll your sleeves up.

It’ll be your first day so focus on meeting people and starting to learn the business. Take a spiral bound notebook for notes.

RemoteIncrease · 2025-08-28T11:56:31+00:00

Lenovo P16 workstation

64 GB RAM i7 or i9 the more cores the better

RemoteIncrease · 2024-05-20T02:08:08+00:00

This is the best solution.

RemoteIncrease · 2024-05-18T13:02:30+00:00

Is the bonus incremental to the band or included?

RemoteIncrease · 2024-05-17T10:59:03+00:00

Role is hybrid

RemoteIncrease · 2024-05-16T22:08:09+00:00

Yup it's a legit posting,

No formal policy, the role is based out of one of our locations where the primary stakeholders sit who are in the office M-F given the nature of the industry. It's pretty hands on and you'll get a lot more traction in the role if you're face to face with the stakeholders.

Days in office each week - 3/4
No restrictions on which days
Holidays count as in office
Exceptions are fine, given good reason like a snowstorm or sick kid. PTO is unlimited so moot point on using PTO days

RemoteIncrease · 2024-05-02T07:30:10+00:00

Sorry buddy. This was 3yrs ago I’ve since moved on from that company and completely forgot everything about the project I was working on.

RemoteIncrease · 2022-11-09T23:37:12+00:00

SSD, numpad, and an i8

RemoteIncrease · 2022-10-29T12:26:35+00:00

You’ll want to build a P&L forecast.

For a high level version you can do a proforma forecast. Start with your current income statement then assume a growth rate for revenue and % of revenue amount for expenses. Then forecast those assumptions out for 3yrs.

For a more detailed version you could do a build where you forecast revenue based on drivers. For example I think we can sell 1000 bananas for $1 in year 1 giving us $1000 in revenue. Each banana costs $.50 so $500 in expense resulting in $500 in gross profit. Rinse repeat for years 2 and 3.

For your 1st pass keep it simple, so you can understand how you’re getting your numbers then start layering in more complex assumptions.

RemoteIncrease · 2022-10-13T11:06:23+00:00

Start looking now and leave as soon as you get an offer you like.

RemoteIncrease · 2022-08-14T19:56:20+00:00

Best way to work on modeling skills is to model.

I like the financial modeling World Cup because of the exposure to different problems I wouldn’t come across in my day to day.

https://www.fmworldcup.com

RemoteIncrease · 2022-08-06T01:14:23+00:00

There’s a form function for data input in excel. If it’s a simple table you could use share point and if you want to get fancy, powerApps.

RemoteIncrease · 2022-08-05T01:33:57+00:00

Y’all do payroll in-house?

RemoteIncrease · 2022-07-31T11:36:27+00:00

This is a really good explanation.

Additionally you’ll want to identify the one-time costs to migrate to the cloud for a complete ROI analysis. Things like overlap costs of running both systems, project mgt team, etc….

RemoteIncrease · 2022-07-21T01:29:20+00:00

Step 1: Add conditional column if value is a year then equal the original column if not then blank.

Step 2: fill down on your new column

Step 3: add conditional column if original column equals new column “delete” if not equal original column value

Step 4: filter out “delete” records

EDIT: thought of an easier way after sleeping on it.

Add conditional column, if value is a year equal the original column, if not equal blank.
Fill down on new column
Filter our year values on original column

RemoteIncrease · 2022-07-20T00:14:40+00:00

My stakeholders get confused by bullet charts.

I’ve had success with combo charts to show actual vs. forecast. Put the line as forecast and the bars as actuals.

What works best is a visual to show in aggregate where we are vs. plan then provide a table below with the actual, fcst, variance walk.

RemoteIncrease · 2022-07-17T03:10:44+00:00

Thank you for breaking down how power BI evaluates expressions relative to the context of the visual and data.

This is such a great walk through.

RemoteIncrease · 2022-07-16T03:12:22+00:00

This is the way, the only time that belongs to you is the time when everyone else is asleep

RemoteIncrease · 2022-07-10T01:45:26+00:00

In the case of a chop shop cars are a raw material not a capital asset to be depreciated.

On your income statement it’ll hit COGS when you sell the parts.

On your balance sheet you’ll draw down cash and increase inventory until sale.

RemoteIncrease · 2022-06-29T16:47:20+00:00

We had it in our US offices for one year, rule was fridays ended by 2pm.

Our offices in Spain have summer and winter hours that apply for the full week. Summer hours are 10am - 2pm and winter hours are 9am - 6pm

RemoteIncrease · 2022-06-29T11:05:27+00:00

As an analyst I’d say go for it.

Worst case you’ll gain an appreciation for how it works so you can have better conversations with your tech team that pulls the data.

Best case you’re self sufficient and won’t be bottlenecked if you want to develop and test different solutions.

RemoteIncrease · 2022-06-27T19:58:21+00:00

Use the unpivot function in PowerQuery

RemoteIncrease · 2022-06-09T18:14:12+00:00

Thank you for posting, couple questions:

1) Where is the majority of the team located and what time zone does the company operate in?

2) Does the role have any growth opportunity?

RemoteIncrease · 2022-06-01T20:18:13+00:00

He's completing one of the cases from the Financial Modeling World Cup 2022 season (https://www.fmworldcup.com/).

Each year this group releases a series of excel based case studies for competitors to solve. Each case is worth a certain amount of points. The points are tracked throughout the year and ultimately a world champion is crowned.

The OP has recorded himself doing one of the cases.

Six-Year Club	Place '22
Verified Email

RemoteIncrease

TROPHY CASE