Has anyone tried out the python editor in excel yet? I’ve done a couple of things, but it seems a bit quirky still.

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

Related Posts

Friend lives in Moscow, Russia and friends with a Sr manager of multiple rolex ADs in the city. Apart from the usual DJs, literally the only thing they apparently have in the entire city is a single Submariner gold TT. Crazy. And here I was thinking that I can outfox the waitlists

likefunny

On a weekday, when can I slow down (respond in 30 mins instead of 5) or go to sleep? I’m sure it’ll depend on deal pace, but in general?

likehelpful

I joined Nagarro in the first week of September and still haven't received my ADP credentials. In the email it was mentioned I'll receive it on 1st October. 😒 Nagarro

like

How can I help our UX/UI people and developers become more familiar with conceptual advertising? One Show books? Hey Whipple, Squeeze This?

likefunny

anyone hear back about APMM program offers?

like

Hi All,
Whats is the CTC for new joiner Senior associate 1??

like

Are the UKI CCs been instructed to share the talent discussion outcomes (I.e. Feedback) with counselees by 30th Oct as our NA colleagues have?

Any firms/companies hiring in their privacy group? Looking for fully remote or TX

like

Hi Folks having YOE of 3.7 yrs in IT, any chance to move to any one of MBB

I have joined TCS as graduate trainee. I have been trained with Automation anywhere tool.i. am on bench.
I have knowledge of Html ,css, little bit of javascript and Java. What should I do or learn to grow in my tech career.

Any Bay Area peeps want to meet up next week? Going to be in town for work, but looking for a distraction.

like

Good idea to buy some more AAPL right now?

likehelpful

Any agency layoffs yet? (I obviously hope not. Just trying to get a sense of where agencies are sitting.)

like

Does anyone know the criteria used to determine who is selected to be laid off due to COVID?

like

How is VISA managing the upcoming economic slowdown? Any word of slowdown in hiring or hiring freeze? How did VISA manage employees during the Covid recession? Any layoffs occur then?

helpful

Is oracle still good to join these days? I haven’t heard good things of oracle.

like

Are people who joined in January not receiving any hikes this year at ac kolkata?

like

Has anyone gone from an agency to an in-house Programmatic team? If so what has your experience been?

like

Is it a bad idea to buy my first home given the current interest rates?!

like

Additional Posts in Excel Genius

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

like

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 set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

Would anyone be willing to teach me vlookup?

like

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

like

Anyone know what these badges are?

Post Photo
likefunny

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

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

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

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

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

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

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

like

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

like

How do you fix microsoft excel cannot paste data error?

like

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

I’m helping my GF with excel and need help lol. She works at a hospital and is trying to make an excel schedule for doctors to reserve rooms. She wants drop downs for days of the week (column K) and also different drop down menus in column P for the reserved time slots.

Is it possible to do this with two sets of drop downs (days of week + time slots) and not use index match here? She could make 5 tables for each day of the week, but prefers one table that can be easily navigated by doctors.

Post Photo
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

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

like

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

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