Related Posts
Hi Amazonians,
I am looking for guidance.
I am going to start interview process with Amazon next week. Probably all rounds will be done in 1-2 day time frame.
How/what should I prepare for interview?
Am clueless on what kind of ds & algo questions, system design questions are asked in Amazon interviews.
My techstack: javascript developer- react+Angular.
1. Pls guide me on what/how to prepare?
2. Also, will the interview be solely on da & algo and javascript; or on Js frameworks?
Amazon
Experience with vestas data analyst interview ?
More Posts
Hi All,
Any update on WFH continuity?
All the lions 🙌
Additional Posts in Excel Genius
What are the most typical models you all build
New to Fishbowl?
unlock all discussions on Fishbowl.
If you have already selected the column/range, Ctrl+Enter when you are typing the formula (instead of just Enter) or Ctrl+D when you have already typed and pressed Enter. Both are safe to use on filtered ranges.
I’m not aware of shortcuts that work when you *haven’t* selected the range you want your formula to be in.
1) go to the cell which has the formula
2) Shift+Ctrl + down arrow will select all the cells of that table to which you want to apply the formula (if no table then it will go all the way down)
3) after selecting the cells (step2) you want to apply the formula -> just hit F2 (it will show you the formula)
4) CTRL+ Enter
Was going to comment this as well!!! F2, control and enter
Double click bottom right of cell
double click the bottom right corner if it’s next to another column wi the data in it?
And without double clicking
And only using 1 hand. Why?
Double click the bottom right corner of the cell
Ctrl + arrow keys to navigate the end of the column, ctrl + shift + up arrow to select the column, alt > h > fi > d
Coach
Look in to flash fill. I don’t use it but think it is what you are looking for
Coach
1. CTRL+C on formula
2. ALT>A>C (clear filters)
3. Move to closer full column (no blanks)
4. CTRL+down
5. Move back to target column
6. CTRL+SHIFT+up x2, then down 1 time
7. CTRL+ALT+V > only formulas
8. Enter
Flash full using your keyboard and ALT keys, assuming you’re not a sociopath and use Windows.
Ctrl D / Ctrl R. If you don’t have Macabacus or similar, it will only work if the cells are highlighted. With Macabacus, it goes to the end of the table.
Convert the range to a table. When you punch in the formula it fills the entire column auto-magically.
Double click the bottom right corner of the cell, but I don’t recommend this, especially if you’re trying to copy a formula on filtered data, as it will overwrite cells which are filtered out. Because of this I recommend copy, ctrl+down arrow (or left then down if you have other data in columns you want to get to the bottom of), then ctrl+up arrow and paste.
Crtl + D