Sometimes I watch those insanely fast Excel competition videos and have a full-on existential crisis about my own skills. Anyone else?

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

If your boss is a boomer then you’re leaps and bounds ahead in excel to them. I once had to show my boomer boss how to copy a cell rather than manually entering in million dollar values lol.

funnylike

Yeah, but with a pause button, I can learn it. And I'm miles ahead of the coworker who merged a dozen cells instead of adjusting the column width.

funnylike

Imagine when you learn how to Center across selection

upliftingfunny

You are not alone!

No, why would I care about that lol

Yeah! I feel you @Media Manager. I feel my problem solving is not so good either looking at those competition vids.

U jus rnt pr0 wuts ur apm?

Related Posts

Hi im having 3 yoe having 2 offer 1.Nice x+2 variable+1Joining bonus 2.Bitwise x+2 fix which one i should join plesae suggest in term of job security and learning wise

like

What would be the designation offered in Atos Syntel for 11.6 years exp and ctc to be asked

Current ctc 20 lpa fixed
Domain SAP BODS etl

What sort of skills translate well post-LEK? Is it worth getting really sharp with Tableau and Alteryx?

like

Well, I believe that being an adult with ADHD and being a Tax Lawyer is not the best combination - currently, I feel exhausted

like

Moving into a new apartment after the holidays. How much should I tip my super and doorman upon my arrival?

like

🐠 - Recommendations for a small black shoulder/crossbody. Looking to spend between 2-3k.

like

In process of buying a house, both my surveyor and specialist damp contractor found damp under kitchen tiles (In the grout) & in skirting boards and up one wall. Sellers had work done initially in 2014 on the wall only(with garuntee) & their company has visited and assured there is no damp… what is next best course of action, get another damp specialist to examine independently of other reports? I don’t trust them….. (U.K. Victorian terrace, damp is in the kitchen extension built circa. 15 y/o)

like

Hello All,

I am temporarily moving to Hyderabad for the month of November 2022 and looking for a temporary stay for this period.
Please let me know if you have any suggestions or if you have a vacant room for this period.

Thanks

like

Any moms on here that absolutely love their company and feel 100% supported?

like

Could you all please suggest or share any tips/key things to prepare for an upcoming AWS Partner SA, Security phone interview. Already prepared for LPs. Thank you.

For someone earning 11 LPA fixed in India, is 50K Euros in Germany a good package?

Numbeo says it will be equivalent to my current salary, however tax deduction will be higher. Thoughts?

like

When do you predict the dip? I've been waiting for so long, but don't want to buy now. VTI seems inflated.

likefunny

Hi Fishes

What would be the in hand monthly salary of 12lpa?
Thanks in advance.

Does really Collaboration work or it's just a myth. Always hearing from Offshore manager is that take more ownership like from offshore we should be working 80% and only 20% will leave for onshore because of time difference..

Is it really a collaboration or simply a cold War between offshore and onshore ownership..

I’m at a point in my life that just want to quit and become a school counselor 🙄. I need to feel what I do can make a difference in something. Anyone has experience with such harsh transition? I always wanted to be come a psychologist

like

I work heavily in AWS and am looking to learn another cloud platform. I have zero knowledge of azure and gcp and would like input on which to learn. Azure would make sense since its the second largest in terms of market share, but GCP seems far more interesting and technically challenging with things like Kubernetes and BigQuery.

like

🥰 Good morning, here’s a Thought for Today: What can we do in our teaching practice to ensure that the term Antiracist does NOT become synonymous with anti white? 🤔

smartlike

Today a student told me "I don't like gay teachers". It hurt more than I thought it would because I've worked hard for a strong rapport with him. Anyone else have kids speak to you like this?

like

What is the manager range at KGS?

like

Additional Posts in Excel Genius

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

Would anyone be willing to teach me vlookup?

like

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

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

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

What’s the symbol that you can type in a cell so you can input a text, but that text would not appear in the spreadsheet? I want to describe the formula without using a text box, which uses more space.

The equivalent of this is in SQL, you can use the apostrophe in the beginning of and end of a text. That text will not affect the function of the query, but that text can be seen if you proofread the query.

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

Does 2-finger touchpad scroll not work on Excel sheets anymore? I used to be able to swipe quickly on my laptop's touchpad to navigate sheets but now it doesn't work. Based on the handful of posts I've read online about it, the problem seems unresolved. Has anyone dealt with the same issue and fixed it?

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?

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

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

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

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

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

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

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 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)

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

I’m trying to learn more about Excel functionality and there’s several simple functions that I don’t know, this is probably one. If I am color coding data, is there a way to automatically move those lines to the top or bottom of the spreadsheet once the color code for the line is made?

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

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