What are some of the unique use cases you have leveraged excel for?

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

Oh consulting-speak...

A non-consultant would say, “when have you used Excel for something not related to work?” Haha

funnylike

Playing Line Rider in school, someone had rebuilt it in VBA.

funny

I will start - i used it to help in my decision making process when purchasing a house. I had over 50 variables and a weighed framework that factored in the collective needs, wants, and likes of my spouse, and 3 other family members.

Would you be kind enough to share your model? :)

like

Related Posts

What is annual hike % at Acuity?

like

How is EY client in LTI? Role: .net core + Angular for my cousin . Iam surprised that Ey itself provides services and it is client for LTI. How is the work and learning in ey client project in LTI. Please reply.

like

McKinsey & Company Is McK expense policy the same worldwide or region dependant? McKinsey & Company

So considering the social and political climate we’re facing right now, is anyone else in this industry feeling like you’re the only conservative in a sea of blue?

likeupliftingfunny

Another salesman told a client their ad campaign would be ready next week. Today our supervisor told me to help him, but he has hardly even started the work. Is there any way for me to point this out without feeling like a jerk

like

Starting a new job at Applied Materials on Monday as a Manufacturing Engineer III. I’ve been out of college for 5 years and all of my work experience till now has been in R&D for start ups and small businesses . So not only is this a new experience for me going into such a large company but also a industry (semiconductors). Does anybody has tips or advices on what I should expect as a new hire and how I can set myself up for success? Thanks!

like

Daily filling Timesheet even on bench.. bad process. it shall be weekly or monthly..

like

Best barber shop in the West Village?

like

Is there a Gym facility in DTTI office in mumbai?

like

Currently I am in Deloitte India with(6.5yrs exp) 13Lac WFH Pune hometown
I am interviewing with SAP LABS India how much should I expect for banglore location (hybrid) will need to relocate
Would it be a good decision to relocate as I am staying with my family in pune?

like

Do we get early pay day, because Diwali? Is Talent that considerate? 🌝

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

I was just laid off. I feel lost, feeling both pumped up for the future but pained because I was a high performing, straight laced, and by the book team member. Looking for Muslim leaders who are recruiting. Extensive experience in strategy and implementation of Data and RPA technologies. PMP and RPA developer certified. SQL, R, Python, UiPath, Agile, waterfall.

like

Are BAs comparatively safer than Dev’s when it comes to layoffs?

like

Hi all,

I'm looking for a referral at Paypal for a Risk Management role, link to job and requisition ID available, I have the necessary experience and my current designation matches with the role. In dire need of a move, if anyone could help me out it would be a big favour.

Kindly DM for the details. TIA.

Hello all,
Looking for refferal for 2 roles in a good company.
1. Customer success engineer - cloud
2. Technical account manager - cloud

Yoe: 2
have various cloud certifications.

Please do let me know if there are any openings.

like

Hi everyone! How are you all doing?
I am looking for a switch to a Data Science/ ML role.
As of now, I am working as a Data Associate and my tech stack is: Python, SQL, Aws, kubernetes, docker. I have worked on creation of Novel scripts to parse medical data and optimization of existing data parsing scripts, ETL pipelines and Data Migration. YOE: 1year 2months.
Thanks.

like

SEIZING THE MEANS OF NUG-DUCTION!

DC IS ON THE TENDIE-TRAIN

Post Photo
funnylike

Accepted offer to join F500. Start in 2 weeks. Dream FAANG role reached out for interview. How do I handle this? They do not know I accepted industry offer. If I get through process and FAANG role makes me an offer they will see I have been at a new job (that I didn’t disclose) for a ~month in the background check, will this hurt me? How do I handle this..

like

I regret not applying to Harvard. I never thought I’d get into a top school and then got into wharton with a 100k fellowship - which changed my entire perspective. It sucks thinking “what if…”. I just didn’t have the confidence and thought wharton was a reach so why bother with H/S 🙃 hope this inspires someone to just shoot their shot - you never know

like

Additional Posts in Excel Genius

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

Looking to write a macro to rename a worksheet based off whatever is in cell A1... Anyone have any ideas? 🤓 👀

I have 6 months left until I start my first consulting job, I want to use (and improve) my Excel skills via volunteering, where should I look to find such opportunities? (UK)

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?

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

likehelpful

How to change a date field from 2002/01/15 to YYYY-MM-DD. The right click and date selection is not converting it for some reason. Even tried to do a custom field but it’s not changing :(

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

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

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

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

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

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

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

Hello. Quick question about formatting. I have an excel sheet with bunch of negative numbers, but some are percentage values and some are dollar values. Is there a way to make all of them have a parenthesis for being negative while keeping them still percentage and dollar value separately or do I have to target them separately?

like

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

Do you have to activate excel almost every time you use it- or is it just me?

like

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

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

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

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

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