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

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

Put your mouse out of reach and try to do everything with only the keyboard. When you get to something you don’t know how to do, google it.

There are lots of you tube videos for things like macros, index match, etc.

like

Haha loved this one

Wallstreetprep.com

like

Related Posts

Any rumour of an inflation based salary increase?

like

Can you guys advise me if a salary of 150 K CAD before tax is good for a 3 member family? It is in Quebec and we will be shifting from India to Canada with that.

like

I will be relocating out of state from NY to FL in December. My current role does not allow flexibility to work remote and our offices in FL have no tech roles for transfer. I have 5+ YOE as a product owner in M&E and looking to break into the Digital space as a PM. I’ve been applying and interviewing with no luck and multiple rejection as it seems hiring has slowed down. Anyone know of companies hiring? I would love to connect.

like

New here. Henloooo

Post Photo
like

JPMorgan Chase Hi,
Does my manager know which location I logged in from…on the monthly reports? Please advise.JPMorgan Chase

like

Kindly like my post, I need to get 11 likes to start activating chat feature, Thanks.!!

like

Anyone feel like your job sees you as "one of the good ones?" It hasn't explicitly been said, but I'm one of the only Black attorneys at the firm and I think my white colleagues and partners see me as an example of how Black folks "should be" cause I mind my business. Basically I feel like a token, and I don't know how to shift that idea while staying professional.

like

Waiting for God of War and for Bungie to grab Halo back from 343 Industries since Destiny has always been trash.
. . .S/O to Horizon Zero Dawn though.

Who is gonna tell donald about this? Tweet storm incoming...

Post Photo
likefunnyupliftinghelpful

FAANG is now MAMAA (Meta, Apple, Microsoft, Amazon and Alphabet)…Whoa Mama! As if there weren’t enough acronyms in our lives. Happy Friday All!!!

funnylike

Hi everyone. Need guidance on entering private equity sector. I am a CA and CS. Currently working at PwC SDC in assurance. Any guidance will be very much appreciated. Thanks!

like

Anyone have any killer quotes / resources / thoughts for framing the role of a creative brief to a client who has a tendency to get lost in details and soften language?

like

Hello. I currently work in-house as a Legal Operations Manager. I am working on a project to expand our network of law firms.

Any recommendations of boutique law firms in CA that have experience in commercial litigation for retail/fashion/apparel/home companies? Specifically consumer class action, unfair business practices, false advertising/17200, data privacy.

Thanks for your recommendations.

like

Anyone in IB/PE in Toronto? Would like to connect to learn more about the industry

like

For those of you with young children and a 2000 billable requirement, could you share what your typical daily schedule is like? Also do you have time to fit in exercise?

like

Anyone from Allied Benefits LLC know the salary for a Reimbursement Specialist?

like

How supportive are your companies when it comes to taking PTO for mental health days?

likesmart

Can some confirm me what is the take home salary after all the deductions? Company HCL

Post Photo
like

HCL Technologies
I team I joined HCl two days back, can I leave now I just got another offer from a product based organization. What will be the process or consequences if I just inform hiring hr that I am not going to continue

like

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

Additional Posts in Excel Genius

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

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

Does anyone know any shortcuts for the “Refresh All” button without having to always click Data->Refresh All every time I want to refresh the live data? For a Mac btw pls thanks!

Post Photo
like

Hey!

What are the less known skills in Excel worth learning which are also high in demand in the market?

PS: I am starting off on Fishbowl so please support with a ❤️.

like

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

Can anybody recommend any excel courses to take for financial analysis? Modeling, valuations, etc. Any direction would be helpful.@

likehelpful

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

Everyone: Excel is a smart app
Excel:

Post Photo
likefunny

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

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

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

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

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

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

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?

Would anyone be willing to teach me vlookup?

like

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

like

Anyone know why a SUMPRODUCT cell would return to zero?

The error said ‘inconsistent formula’... (cont’d)

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

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

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