Worth picking up power query? Have a couple of days on bench and thinking of taking up a course. Any folks here find value add in PQ?

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

Related Posts

And never forget it.

Post Photo
likefunny
like

The president of Nintendo America is named Bowser. Wat.

likehelpfulfunny

Do companies sometimes offer "gifts of appreciation" if you're not selected for a merit increase? My manager randomly called me to let me know I was chosen for the "gift" this year bc of my "hard work & dedication", except now I'm learning other colleagues are receiving actual merits.
I mean it's possible that I may receive a merit, but I feel like I won't considering my manager never brought it up & the dept update made it sound like those receiving it should know by now.
More details below ⬇️

like

Vettel you beauty ❤️

like

Any Business Analysts in CBS Service line here?
Are you happy with the quality of work that you are doing? Are you guys handling a single project at a time or multiple?

like

Vacation ideas for Thanksgiving? Six of us (ages 25 to 60) and everyone’s vaccinated. Thought about going to the Caribbean but I guess it’s the wet/hurricane season at that time. We’d be traveling from LA and Chicago and it’s only for a week if that helps. Any places you’ve enjoyed during late November?

like

Having an animal friend with cancer is not something easy. This year I have already had 24 animals that went to sleep in order to stop suffering. This is not easy for their families at all. It seems to me that the cancer stats in domestic animals are increasing, is this just me?

like

Dear all, currently I am working as a react developer I have one yr of experience in my current company,I need your suggestions I want to learn backend should I learn node js Or java spring boot. I have knowledge of core java Thank you @Tata Consultancy Infosys

like

Typical day for Credit risk business analyst BA4?
How is the work life? Management? Leadership? Office transport, canteen?

like

Anyone interested in taking a 2 day ice climbing clinic in Ouray Colorado in late March?

We are all sleep walkers (specifically in Europe) walking towards the second wave of corona virus cases and potential lock-downs even though we should all know better.
Change my mind!

like

I feel so guilty for not always modeling good health. Anybody else feel that way?

like

I have recovered from Corona Virus. Its 6 weeks now and I can tell you that the after effects are real. I have anxiety that I will never get over the fatigue, brain fog, inability to form sentences and words and headaches which make my work days very difficult to get thru.

like

Recommendations for an Alps ski resort between Zurich and Munich by car (Switz, Austria, Germany)? There are so many but looking for a developed village with lodging options and good lifts. Any faves?

like

Any suggestions for a doable road trip for 3/4 days from LA in late Jan / early Feb?

like

Hi how do we avail gym facilities in bosch

like

Hi All,, Has anyone joined UST - PTEC (equifax) company recently for pune or other locations? Can someone please provide review of the same. Thinking to join the same on 30th dec.

Please respond.

like
like

Additional Posts in Excel Genius

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

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

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

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

like

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

like

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

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

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

like

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

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)

Hey fishies, looking for some help with the below

I have 4 lots of data categories which are assigned a code in the adjacent cell
Eg:
Cell A2= 'xyz' Cell B2 = 'w1'
Cell C2= 'ghi' Cell D2 = 'x1'
Cell E2= 'plm' Cell F2 = 'y1'
Cell G2= 'mhn' Cell H2 = 'z1'

The combination of the 'W','X','Y' and 'Z' codes identity a specific trend
I am extracting data which includes multiple combinations of these codes. What is the best way to show frequency of the codes against the category it is assigned to

like

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

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

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

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.

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

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

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

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