Pivot tables, nested formulas, conditional formatting. That's my bread and butter when it comes to Excel, and what I'd recommend beginners focus on. What about you?

Post Photo
likehelpful
Posting as :
works at
You are currently posting as works at

Conditional formatting, XLOOKUPs, VBA, and Macros

like

Use more tables and memorize shortcuts.

Related Posts

Which Mckinsey office in the Middle East is hiring? Does Dubai office still hire experienced hire now?

like

Hi All,

I had an offer as a business analyst in HDFC BANK and CAPGEMINI.May I know which is better in terms of WLB...
Yoe 14 year
HDFC 23 LPA
Capgemini 22LPa

like

Staying at a Hilton currently and have had tons of minor issues in the 3 days We’ve been here. Room wasn’t ready for 45min after check in time, AC did not work, maids did not clean room...continued

like

Did any one implement semantic search on custom domain data? if so what is the best model is to generate embeddings. I am using DPR but still looking for better model

like

If you’re a GSAPper who has left already for an externship, how do you get notified about your comp? An email?

like

How's technical work in cws engineering team in Goldman Sachs for java developer? And how's work life balance in that team?

like

Does Barclays UK provide onshore opportunity to analysts working in their Indian offices?

like

Is there any possibility to change the EY IN offered location after you join ?
Offered location is Chennai.
I am from Pune.
Please suggest if i can ask for a location change after a couple of quarters? Can I get a pune location?
Do EY IN assist in Changing the location of employees?

DOJ - 30th Jan 2023.

like
like

Where are there openings for a lead strategist / head of strategy at the moment? Not asking for a friend.

like

Any Sr. Data Engineers with Spark/Pyspark/AWS experience looking for FT opportunities?

We're currently hiring! Please comment or message if interested

like

KPMG GDC is hiring for below positions. DM me or comment below if interested.

Post Photo
like

Israel fish nyc?

like

Do you wear cowgirl or cowboy boots?

funny

Is there any stigma to saying no to an offer without another in hand? I landed an off-cycle offer at a decent fund but after thinking through, want to take a shot at some of my other funds as well

like

Anyone move over to a portco role at a more senior level? Positive or negative experience?

like
like

Any daycare recommendations in Charlotte (ideally somewhere between South End / Dilmore and South Park)?

Best NYC growth equity shops for WLB and career progression?

like

What does it mean if there’s a NEP at the firm who’s been there for a long time (20+ years), but never got promoted to EP? Never held leadership roles too. Does it usually mean EPs does not like the NEP enough to get promoted?

The NEP has a book of business, though no idea how much it brings in.

like

Additional Posts in Excel Genius

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

like

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

Anyone know what these badges are?

Post Photo
likefunny

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

like

Any book recommendations on excel modeling for real world business applications?

like

How do you fix microsoft excel cannot paste data error?

like

How do I compare two sheets to make sure they are identical?

like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

Hello all, hope you guys are having an amazing day!
I’m wondering if anyone has a good beginner friendly resource in linking SQL database to a Worksheet. Tips, in-depth tutorials, that good stuff

like

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

Would anyone be willing to teach me vlookup?

like

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

like

Still don't have xlookup. #fomo

like

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal