Hi all, did anyone managed a huge data set with contact list? I'm looking for a convenient template, that can be automated or implemented from excel into other data system

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

I worked with similar datasets in the past. Can you provide me details on what sort of a template you are looking for?

like

I'm looking for a template that allows me to record multiple periods from previous years, track the status of mail-outs, and apply various filters. I'm considering transitioning from Excel to a more modern method so that any updates or changes can be viewed and corrected by everyone simultaneously..

Hey don't have a ready template for this one, could help you with making one though?

helpful

Hey sure, messaged you

Related Posts

Moving to London in September - looking for a place to live! Any recommendations on neighborhoods?

like

Was there ever a resume that you have come across that made you want to hire the person before you even met them? What made it so unique?

like

Beside toastmasters, what are other ways to improve communication and public speaking skills? Books, podcasts...?

like

Any referrals of banking domain? I have experience for almost 6 years in TCS.

like

Looking for some encouragement. Has anyone here received an overall negative performance review or has been put on a development/performance plan and was able to turn things around for the better?

like

How many teachers are using Nearpod?

like

Hello Fishes,

I left capegemini on 4th of Feb and I still haven't got my relieving letter as well as experience letter. I'm trying to access my capegemini portal from
webvpn.capgemini.com but I'm not able to access that either. Please suggest me what should be done, my next employer is asking for relieving letter.

like

How come none of the Big 4 have a mascot?

like

A NY agency is asking me to work on site come September, I said of course. My true intentions? Working remotely from Florida for life. How would y’all handle this issue when pandemic is over (if it that ever happens)?

like

I have been working as a product support engineer in Bangalore for the last 2 years, I'm getting 6lk per annum and searching for a job with a decent salary,over all YOE 10 please suggest to me if there any openings in your circle.

Thanks

like

Im 21, recently got a project manager job in a big media group, I still have about one year to do in my degree. Where would you recommend I take my career next, what would be the logical next jobs I could explore in that field?

like

What is a comfortable salary outside of a large city for a married dude with 3 kids? 180?

like

 I heard a commercial on the radio for Verizon that said something to the effect that parents are now learning how to lesson plan. Are any of you off the hook for lesson planning? Just wondering because I’m over here busting my butt!

funnylikehelpful

So with a new Justice nomination coming, I assume there won’t be any complaining from the GOP if and when Democrats pack the court and get rid of the filibuster, right?

like

Hi guyz recently received offer from open text but when asked I told them that I have only 1 month notice period but actually I have 3 months notice period now ....I am bothered about loosing my offer if I say to open text requirement team about my notice period....any suggestion guyz

like

What does your startup do?

like

Okay so I’m somewhat new to the Advertising industry and was curious if hiring comes in waves? Seem like a lot of people are posting about how quiet hiring is rn.

like
like

Additional Posts in Excel Genius

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)

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 change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

like

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

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

likehelpful

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 am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

like

Still don't have xlookup. #fomo

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

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

likesmart

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

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

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

like

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

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

like

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

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

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