Any quick ways besides manual copying to add images of org charts (names, titles, managers, etc.) in to excel from ppt? Need to make them into pivots

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

Clarification: The org charts are images on slides in ppt and I just need to copy over the words (names, titles, managers…)

agreed. Certainly the original image creator had access to the data you’re after. Cut out the middleman (images in ppt) and go straight to HR for an excel-friendly export.
If you’re not permitted to have that data or the folks in HR don’t have a clue, try the folks who maintain Active Directory. They know how to give you an Excel-friendly data set.
But if you have my luck, you’ll be denied there as well. So then you will be stuck creating a table of your own, and 2 things are sure to follow:
1. Someone else will take credit for it, and
2. Your work will be appreciated and this manual and laborious task will be assigned to you for years to come.
Welcome to the club!

like

Related Posts

Do you think it’s fair to pay full price for a missed appointment? Long story short, I lost track of time by 30 minutes. By the time I realized I messaged her and she said she can’t extend the time due to other clients so I suggested we reschedule for next week. She’s now asking for full payment of $175. I tried to renegotiate so she brought it down to $115. Does this seem fair? Looking for other perspectives

like

Hello Fishes,

I'm looking for an opportunity in Automation.

YEO: 5.6

Can join in 40 days.

Skills set: Python, Robot Framework, Gitlab CI, Docker, Kubernetes, QA, Test Automation, Shell Scripting, Linux, Telecommunication

Contact: +91 9860638875

Thank you!

like

How did you get better with money? I'm fucking terrible with it and kind of always have. I don't want to hear tips from people who are natural good at it. Would love to hear stories of people going from bad to good. TC: $170k

like

Does ANYONE have a good on boarding practice? Tell me more. Ours is a nightmare.

likehelpful

Hi all, I switching from academia to the private biotechnology sector in Montreal, Canada. Anyone has an idea of the payscale I should expect/ask as a Molecular Biology PhD with 15 years research experience?

Thank you

like

I’ve been trying to get into The Walt Disney Company for years and can’t seem to make any progress. I’ve tried introducing myself and connecting with recruiters on LinkedIn and of course, applying to jobs on their site. Would anyone happen to have any words of advice for someone trying to transition from the ad industry into the entertainment industry?

like

April fools joke?

Post Photo
like

Does anyone have any experience working with or for JPI? If so, thoughts?

like

Hello, I am a healthcare professional looking to get into practice management. I have a background in physician compliance and a masters in healthcare administration. Any tips on how to get into practice management?

like

Has anyone had to reschedule their wedding last minute due to circumstances outside of their control? My wedding is in 32 days in Mexico and our last deposit is due on Tuesday (cont.)

likehelpful

For those that left PA for industry, then went back to PA - why did you decide to go back? How long did it take you to realize you wanted to go back to PA? Also, how did it impact your career progression?

like

Anyone use Carol's Daughter products before L'Oreal bought it? If so, do you still use the products now? Any noticeable difference in quality or benefits?

Favorite place to eat recently and price point? Can be as fancy as you want and say masa and per se haha. Looking for new spots to try soon!

like

Not sure how one sleeps if this is true.

Post Photo
like

Pretty quiet around here today. Looking forward to the evening/drunken hours when all the trenchant snark comes to life.

likefunny

Anyone from McKinsey’s Healthcare practice that would be willing to chat? Not looking for a referral per say, just interested in the work that goes on in the provider space. Many thanks in advance.

likehelpful

Hi All,
I have heard that taxation in Infosys is very weird and in hand salary is very less compare to others. Is there any issue with its salary structure.. please help me on this

like

Has anyone claimed relocation in JPMC Pune?
What kind of hotel do they provide for stay and for how many days?

Any Chicago 🐟 need a roommate? 26M

FTI Consulting or Health Advances ??? Having the hardest time ever trying to choose which offer to take

likehelpful

Additional Posts in Excel Genius

If you follow him on LinkedIn you probably already saw this! Lol 😆 but I totally resonate with the post... 🤣

Post Photo
funnylike

I have three lists. Each is a list of processes. Each list represents one hierarchy level. Is there an easy way to get from three separate lists to one list ordered like shown on the right?
Thanks for your help fish!

Post Photo
like

Has anyone encountered this error before? We can’t access a workpaper with 70% of the work done 😩😩

Post Photo
like

Can anyone help me with this pls? I created a graph using data above (not shown) but for some reason “technology” here appears three times. I want sectors to be grouped together. Is there any way to fix this?

Post Photo
like

Google Sheets vs Excel - pros? cons? differences?

likefunnysmarthelpful

Any recommend courses (coursera, edx, etc.) people would recommend for user with intermediate experience with excel?

like

Hey Geniuses! I apologize in advance if this question has been asked before, I'm new here and just trying to learn as much as i can. Does anyone know a great source to learn Macros for beginners. I would like to create one for work. I appreciate it

like

Hi! I have knowledge of pivot tables, vlook ups. But I'm rusty on if statements and would like more knowledge on excel formulas. I'm looking for excel classes to take online. Any suggestions?

like

Is Macabacus or any other add-in actually worth it for Excel & PPT? In LMM - MM M&A roles.

likehelpful

What are the most typical models you all build

likehelpful

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

like

What are your top Excel ninja tricks? Ones that few people know...

like

Just created my first macro! Super proud of myself! #humblebrag

likeuplifting

Our system is really lacking and we do a lot of work outside of it to track data. Currently I’m using Excel to track data from multiple resources, however, it’s so manual and prone to error. Any suggestions to keep the data clean when I have to pull info from multiple places? I’m constantly auditing and we won’t even look at getting a new system until next year :(

Ok, using excel is not a primary function for my role (this will be very obvious shortly...) So please be kind! On my sheet, in the first and third columns, I have lists of reference numbers. In the second column I have a client name. I already identified the duplicates in the first and third columns using conditional formatting.What I need to find now is column 2 value, whenever value in column 3 is identified as duplicate. Problem is, I have over 120k rows of data so I can't filter! Help!

like

A lot of the work at my new employer is quite redundant and can be automated via macros. What are some of the best resources to learn vba?

like

Tips on adjusting to Mac? I’ve figured lots of keyboard shortcuts but it’s just not the same 😪

like

I’ve toggled the “Show Formula” setting and it changes nothing. File format is xlsx, so that shouldn’t be the issue. Any ideas why these are showing the formula instead of the output?

Post Photo
like

I have a field in excel that represents the GSID, that I want to concatenate to create a link. Example field GSID is 123-west and the link needs to be www.website/123_west.html for some reason using concatenate with left & right formulas to switch - to _ results in the field throwing an error. Anyone knows of a way to make this work?

like

What is y'all's preferred clipping tool? One of my former companies had a great simple program that was only like $50 and worth every penny.
Snipping Tool just ain't cuttin' it (lol pun intended).

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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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