Anyone have a few go-to resources for data evaluation functions?

like
Posting as :
works at
You are currently posting as works at

Related Posts

What is salary of Software engineer in Berlin for 4 years of experience

As a Senior Java Developer with 7.5 yrs experience what would be the expected CTC at Amazon(SDE2) and Walmart(SDE2)?

like

Got an offer from Capgemini for 10LPA fixed and also I got an offer from HCL for 11LPA (includes variable pay but mentioned it will be paid monthly basis) , which one is good to join to develop my career growth. Having 4YOE in network security , vulnerability management and selected for the role of vulnerability management in both the firm's
Please suggest me.

like

Hi fishes, DM for referral.

Business Development Representative - Canada
Location: Canada - Canada - Remote
Function:: Marketing

Post Photo

Any thoughts on how to start writing a memoir or finding people to work with free? Also - how can we gain more speaker opportunities? And is it something specific and focused or can it be generally motivational?

like

Had an interview for an associate position at Citi. Interviewee was based in London and I’m in NYC. The only interview time that worked was 6am. I was barely functioning and feel like I truly messed up in my answers because I couldn’t not think clearly. I have another with the head of the division next week again at 6am (pre determined before this interview). It was also hard because the division’s core work is private enough that there was not much prep I could do beforehand. Tips?

Where is the lie

Post Photo
likefunny

I confess that I confessed to confessing about confessing.

like

What is car lease policy in SAP Labs ?

Is it applicable for all SAP Labs employees at all level ?

like

It appears J Crew is filing bankruptcy this weekend and brooks bros might not be too far behind. What are consultants going to wear when we eventually get back to work??

likefunny

Can anyone recommend a good place to get Botox in SF?

likefunny

Anyone here has taken the PMP certification ? Is it worth it over MBA and if you're managing projects in Advisory?

like

Did the NYSBA forget about re-takers? Is this a grave travesty and denial of Art 15 rights to those who are not being allowed to sit for the exam? What about their financial distress and their ability to retain and seek employment?

Post Photo
like

I lose FAR credit on 11/4 and only have 1 left (failed it in the last testing window). When's the latest I can take my last exam? If I sit for it on 11/3 and pass, then I'll be a CPA?

like

Hey everyone. I am thinking about leaving PwC for a role at small company with about 40 employees where I'll be working directly for the VP of finance. I'll be implementing netsuite, accounting and

like

What are exits for tech transfer? Have an opportunity, but idk if I want to work for university commercialization offices for the rest of my life

like

Any openings for VMware admin/windows server admin in kochi location?

How many days it usually takes for Full and final settlement in Capgemini? It's been 11 days after lwd but didn't receive any communication yet even after dropping mail to f&f team. Could someone help here pls.?

like

Hi Fishes,

I've got offer from Dunnhumby, Fractal and Gartner for the role of Data engineer. Which one should I go for?

Tech Stack - Python, PySpark, Azure Data Factory and Synapse analytics.
YOE - 2.2
Gartner - 16LPA
Dunnhumby - 15 fixed + 1.5 Joining bonus+ 10% variable
Fractal - 13.5 LPA

likehelpful

Additional Posts in Excel Genius

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

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

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

like

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

like

Would anyone be willing to teach me vlookup?

like

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

like

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

like

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

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

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

like

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

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

like

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

like

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

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