Any recommendations for excel classes or helpful courses I can take to round out my excel knowledge? Tired of bothering the ladies in accounting every time I need to make something.

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

If you're looking for formal but self-paced coursework, Coursera has some fantastic Excel courses and specializations.

like

Good to know, my company just added Corsera.

like

And if you want some mini lessons search for excel on insta or TikTok

like

LinkedIn

Not sure how knowledgeable you are, but the best way I find to learn is to search in YouTube when I have a specific problem to solve. Learning features you will never use can be overwhelming.

Related Posts

Curious what’s a fair salary in MA? Was just told that there is likely not going to be a chance for a raise during my upcoming performance review due to my salary already being “above average for the industry” based on my employer’s questionable research. I’ve been with the company 8.5 years & am the only one in my role, which they can’t operate without. I execute tasks from two investment advisors and two financial planners - they make the decisions of what should happen & I make it happen.

likehelpful

Hi
Got an offer from Infosys. Can you help me to figure out my take home salary from the attached screenshot.

Post Photo
like

Nielson - 27 fixed + 3 variable + 2 JB
Genesys - still negotiating on this
KPIT - 28 - Fixed
Genesys Telecommunications Laboratories Inc
Nielsen
KPIT
Which one is better? YOE 8 yrs 8 months

Good morning all I hope all is well. Just wanted to pick your brains with a question. Cloud Engineer Bootcamp vs Self Study for Certifications vs Getting a Masters in Cloud Computing. Say the person is currently a Help Desk Support staff.

I'm asking for a friend that posed the question to me so I wanted to get others perspectives.

Say the focus is AWS and the individual has a Bachelor's in Computer Science. Which do you recommend that they go into now?

Good idea to buy some more AAPL right now?

likehelpful

I had 50% in VT and 50% in individual stocks in my brokerage account but I just accepted a job from a Big 4 so I need to sell some of my individual stocks. I need to invest that amount in something else and I want to tell my portfolio a little bit towards something that’s a bit more risky for higher potential returns. Any suggestions on ETFs to look into?

like

Hello NYC fishes. If you pay your fares via OMNY for SBS bus, and there is no ticket to show if fare cops ask you for it. Apple Pay history won’t show up immediately after transaction (Chase), then what do you do?

like

What firms do higher variable comp? I’m familiar with A&M’s model, but curious if there are others. Figure if I’m busting it, might as well get compensated for it.

like

Do MBB pay a referral bonus if your referral gets hired?

like

Is it worth moving to Germany for 60,000 euros per annum job from a BIG4 with 16LPA INR ? I'm single not married yet.

like

Forcing me to use my standing desk

Post Photo
likefunnyuplifting

Welp, see yeah later KFC!

like

Okay, Audi C7 S6 or 2017 E43 and why?

like

Which would you pick:

Range Rover Classic (c. 1992)

OR

Hummer H1 (c. 2003)

like

Is Carvana legit? I've never seen any reviews just a hundred commercials. I could google this but wanted to know if anyone in here sold through them successfully. Thinking of selling my Benz E350, 2013. Let me know.

like

My AD coworker (not currently my partner) just got hired at a new agency and wants to bring me along as his writer. I'd love to join. He told the recruiter at that agency about me and sent my book. I also have another former coworker (creative) who put in a good word for me.

Should I reach out to the recruiter, too? Or is that overkill after two recos? I don't want to be bothersome. But I do want to show interest..

This all happened on Friday, if that matters. Thanks!

likehelpful

Just in case you don’t know

Post Photo
likefunny

Is it worth it to pay for your own certification ?

like

How high does L6 range typically go for Sr Program Manager roles? I am currently at ~250k TC and the position they were interviewing me for hand a max range of 200k TC. Is >300k TC possible?

like

Anyone have any experience of how technical an interview with Baringa Technology Transformation is? I have a delivery background, and specifically extensive experience in Testing and Agile Delivery but I would not say I am a deeply technical person so I'm a bit concerned about what to expect

like

Additional Posts in Excel Genius

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

like

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

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

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

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

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.

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!

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)

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

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

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

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

How long did it take you to become good at excel? Like fast?

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

Still don't have xlookup. #fomo

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

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

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

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