Not long ago, I showed a coworker a shortcut in Excel that cut their task time in half. Seeing their excitement reminded me how small tips can make a big difference. Sometimes the best part of knowing Excel isn’t what I can do with it, but what I can share.

What’s a tip or trick you’ve shared with someone that really made their day?

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

I helped my wife with a budget spreadsheet her school’s finance department gave her. The column which showed the annual budget (sum of the months) for each row was = B3+C3+D3…

Where to start with these people🤦‍♂️

likefunny

Haha 🤣 that cracked me up

like

You’re terrific for transferring that knowledge

Just doing my role to keeping excel alive 😂

I need more training on Excel for sure. Any “freebies”?

Related Posts

I’ve 3 years of sales experience in retail ( reached 90k over target) and 2 years of digital marketing experience, I love selling and building connections with people, I want to join a Saas company and work as a SDR but keeping getting rejected due to the fact that I’ve no saas selling experience. I love to learn! Is there any recommended courses or anything I can do to get my foot in the door?

I’m a native English and mandarin speaker based in Dublin, Ireland.

like

What's involved in a pension audit? Why am I being brought on as an extra team member just to do that for a month? Seen the same scenario multiple times now.

like

Is anyone working with OpenText Bangalore. How is the WLB, job security and general culture. Is it a good organization to join for a 9 YOE guy?

like

Why are they forcing everyone to work from office now? It was so good till now working from home

like

Going to Denver mid December, would like to drive up to the Rocky’s. What trail would you recommend for a day trip and wouldn’t be too difficult with weather conditions at that time? Is it possible?

I received an offer for $74k as underwriting analyst. Company is based out of DC. Is $74k a good offer? Or should I negotiate for more. 6 years in the industry. 5 as an account manager/underwriting assistant

like

And now.. let me take a selfie!

Post Photo
funnylike

For a top Producer of 3 years, is it appropriate to now ask for a raise in my base pay? Base was 42,500 when I started, but now inflation + 2 children later the base pay barely gets me by. Any thoughts are greatly appreciated!

like

How do you learn a project codebase quick and fast? Not getting much help from the team and most of the knowledge is tribal

I have given 3 rounds of interview in Infosys for a position in SAP in Mumbai location. They are scheduling one more round next week. I got automated calls and interviews were scheduled. Have no idea who should I check with to know the progress.
Is it normal process in Infosys ?

like

What tools do you use for quarterly brand trackers? I’d like to do a survey for my customers to measure brand sentiment. Are there better tools than Google Form?

like

Need advice! I accepted an offer mid Oct and just found out my new company opened a new role above me at the title I was asking for originally but was told I would move up when they were ready to build out the team. I am over qualified for my role now and already meet the exp of the new role above me. Very salty and feel like they are setting me up to feel stuck before I even start. What do I did?

like

CTR, contracts and department overhaul

our marketing dept is undergoing a complete overhaul. under old leadership, a $75k 12-mo contract was signed to a marketing group that handles our SEO, blog and everything Google Ads. All things I can and am in training to do. Current CTRs on G ads seem pitiful at no more than 0.75%. My meta ads coast around 4-6%. During this overhaul, would it be wise to not renew our contract, and negotiate for me to take over these roles and leverage a raise?

like

Feel free to ask any personal finance related questions here, from equity investment to CC offers. There’s nothing called silly questions, we have some excellent peers in the group to answer it.

like

Anyone looking for an AAE or Asst Media Planner? Have a friend w a Cornell degree looking to change careers and join our crazy industry

Are there any disadvantages of joining a C2H role purely on the basis of high CTC even though it is for a big client of the contractor company?

like

If money was not a criteria, what job would you do?

like

Three job interviews with a company, last one creating a marketing plan and presenting to marketing VP. I received good feedback from him. Three days later recruiter wants to give me a call and “give an update”. Schedules it after 2 days. This morning cancels last minute as they are having “internal discussions”. I’m really annoyed and tired. Thoughts?

like

I had to leave the US before my lease ended due to visa reasons and subleased the apartment. I will be returning to the US on L1A shortly after the sublease ends (but before the term of the lease expires), could that jeopardize my return on L1A?

Working in a start-up and love having an impact on the product. Things have been too chaotic tho. Thinking of recruiting for a big tech company but not sure if it's for me- anyone willing to chat?

Additional Posts in Excel Genius

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

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

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

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

like

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

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

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

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)

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

Anyone know what these badges are?

Post Photo
likefunny

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

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

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

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

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

like

Would anyone be willing to teach me vlookup?

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

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

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

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)

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