Favorite way to use Excel that is complete overkill for the task or project?

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

I love to spend 6 hours automating a task I only need to do once or twice and would take less time manually because it's more fun than doing it manually

likesmart

Power Query

Also I spend more time on formatting than the actual project sometimes

like

I use it for writing SOPs and even books (one chapter per tab). I write outlines in it and break down regulatory references or story flow triggers (like intro/story/example/conclusion) one per row. Then I concatenate for a finished document draft.

It’s weird but I keep my writing organized this way.

like

Making data intense models I use once a quarter that need updates every quarter 😅

like

Related Posts

Got an offer from pwc in the data privacy role.
With 13.5 Lpa currently i’m at 12 and made switch on march.
Though my current company is an mnc but not that big and no work pressure is there, amazing work life balance. However, there is little to no learning and its very slow, the project is just starting and the client itself is not clear what they want. Do you think I should switch just because its a big 4. Please help me decide. Yoe -3.5

like

Amex,paypal,agilent, northern trust,jp Morgan which client is good for scrum master role 10 yoe in CTS?

like

What are benefits of working with a content strategist on a project?

What are strong must-have traits of a good content strategist?

Trying to build a case for my agency to hire our first CS!

like

I got this assignment project as part of my selection process. As per me POM, pom.xml, TestNg are used with Java program. Can someone pls help me understand if these can be achieved using python. If not pls help me understand how to achieve this task.
Thanks.

Post Photo

Hi Guys

Does anyone knows about Virtusa ? They are offering me considerably high offer compared to others but I am not sure as I don't know much about the company or anyone who works there ? Project is Legato Healthcare.

Any help will be appreciated.
Thanks in advance 🙏

YOE- 6
Skill - Dot Net Full Stack

like

Hi Team,

I joined Mindtree on 8th Feb and not got project and I was waiting for last 2 and half month. So, i gave interview outside (tech mahindra) and got selected. Almost 30-35% they said they will give and i am negotiating on it.

My main concern was shift and i have some health issues and unable to continue in night shift in Mindtree and tech mahindra its purely EMEA shift and per project team update.

Shall i switch to tech Mahindra?

I am a QA lead looking to break into google Spotify or meta as a program manager or project manager . Can someone please guide me on what does it entail to be a PM at these companies?

like

Digital strategist with tons of experience soup-to-nuts. At this for more years than I care to think. Any tips on finding opportunities client side? It’s only a matter of time before layoffs start

like
like

Is it possible to get a convenient location transfer in LTIMindtree? Or it can be decided only after the project allocation?

like

Is it hard to get into Salesforce? Big 4 consultant with 10 yoe, mostly in ERP/CRM implementation and program/project management, have Salesforce Admin cert but not much hands on experience due to mostly management exp, looking into Director TPM roles - should I apply? Or should I wait until I somehow gain more hands on SF experience?

like

Hey all, looking for a referral to Workday . Currently in the Bay Area and interested in an AE (or AM) role. Would love to leverage my 5+years of sales and account management experience in a client-facing role. Thanks!

like

Hi all,

I'm currently working in enhancement projects!

I had worked previously before in support project and a bit of development project also.

Can anyone help me how can I go about learning all .net related technologies and what should I focus on?

LA: after months of layoffs and salary reductions, we are back! Looking to hire a rockstar LA-based Project Manager at our small independent agency. Projects vary from photoshoots to retail to branding/strategy. Looking for mid to senior level. Diverse candidates encouraged to apply! PM me for details.

like

I have recently joined Wipro, in my offer letter my location is mentioned as Gurgaon and in PSP page under Project Allocation location is mentioned as Banglore, so what is my base location ?

like

Hi, any tips on leading/having a post mortem with a new client? Articles or first hand experience appreciated! Thank you!

Are all big 4s in India the same? Moved from US to India and the work in one of the Big4s for consulting is so bad!! Unstructured, lack of traction, superficial work done.. 🙄🙄 how does any work get done? The project didn’t achieve targets last yr and they’re still making same mistakes this year..🤦‍♂️

like

How is hexaware, pune? Project, job security, stability and office?
Skills : Java, angular
Yrs: 8
Offer: 25

like

More Posts

Just read in Robinhood Snacks that Peloton has their IPO this Thursday on NASDAQ. Can't believe I haven't heard anyone else talk about this yet.

like

What’s the LEK culture like at the London office? Saw a thread in the main consulting bowl (mostly US) and it got annihilated.

like

Hii sharks 🦈🦈🦈🦈

Can anyone of you please help in calculating how much will be my income tax per month(I am availing the Old tax regime)? Different IT calculators show different figures, not sure which is correct :(

And as for the interest amount in the Savings Account and Fixed Deposits, do both fall under "Income from Interest"? Or under "Other Income"? Or does Interest amount in Savings account fall under "Interest from Deposits - 80TTA"?

The figures are given in the screenshot 👇🏻

Post Photo
like

Hi Fishes please help

HR has provided 2 options -

13.5 fixed + 2 jb (1 in the first month & 1 after 1 year)

14 fixed + 1 jb

Is there any catch, what should I prefer?

Has anyone used or is currently using My Perspectives ELA curriculum from Savvas Learning Company? Our district is considering switching from iReady and I am looking for honest feedback. Thanks!

like

Hi all! I work in digital marketing / organic social. For those in organic social what platform do you use for scheduling posts, analytics, UGC, managing influencers etc? We currently use bizzare voice/curalate. I work for a national retail brand so we are posting 2x a day with tons of UGC and in house content. Your thoughts and opinion are appreciated with all platforms! :)

like

Any designers wanna help me out with my portfolio? Everything is done, I just need some feedback to know how to improve it. I'd be very happy if you could help out!

like

How is everyone approaching educating current and potential clients on the Secure Act?

like

Leaving PwC. What should I make sure to do before giving notice and during 2 weeks. All advice appreciated! Work in tax

like

Any recommendations on favorite under eye creams/gels for tired looking eyes?

like

Hi fishes,

I am a c++ developer primarily on linux and qnx. I wanted to get started with the Microsoft Foundation Class (MFC) c++ library used for windows application development.

I don't see options in udemy. Is there a popular YouTube playlist or any other material you would recommend?

like

I used to do outpatient surgery part time and flex to pay my bills. Now I'm out of a job! Has anyone
gotten unemployment? I have some questions.

like

First year staff and I think this job is making my depression come back. I find no meaning whatsoever in what I do and just want to cry every morning thinking of going to work.

like
smart

Koi kapda fit nahi ho raha wfh ke baad 🙁

uplifting

Cant open iBegin TCS portal, anyone else having this problem right now?

like

Hi All,

What is the advantage and disadvantage of working in SAP labs as external worker

like

Any experience working @ Chad Jones law?
I’m currently discontent with my income.
(3rd year. Salary=80k and no performance incentive. I brought in $1.4mm AFTER partners claimed over half of fees on my big cases.)
I see CJL offers an incentive+ base but I’m curious about that structure.
Any good or bad firm culture to speak of?
Is it impossible to actually earn a respectable incentive bonus?
Am I going to have some partner come cut me out of any cases where I might actually make a solid fee?

like

Additional Posts in Excel Genius

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

likehelpful

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

like

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

like

How do you fix microsoft excel cannot paste data error?

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

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

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

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

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

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

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

Any suggestions for a formula to calculate a running count of the number of incidences in a list? For example, in a list with A, B, C, B; I want to label A = 1, then the first B =1, and first C = 1, and then the second B = 2, etc. The list is in a column and there are thousands of names. TIA for your help!

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

Still don't have xlookup. #fomo

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

Would anyone be willing to teach me vlookup?

like

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

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

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

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