I would like to learn more about excel, if someone will let me pick there brain.

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

Maybe this can help along with the help of others.

Post Photo
likehelpful

Yourcfoguy.com/templates/everything-you-can-do-in-excel

LinkedIn Learning has a bunch of modules and courses. Start there and you can become an excel master in a couple weeks

likesmart

Hey there! I’m happy to field questions. I just started a YouTube channel and company to teach people excel.

likeupliftinghelpful

That's great Mario I need help with excel

like

Learn excel by using excel

like

Start from downloading 2 sample data sets on google > open them in two different excel sheets and then play with that data by using formulas like sum, sum ifs, look ups, pivot tables and u r half there already!! Goodluck

likehelpful

Let’s hear it

like

Check out these comical but useful Tik Tok tips https://www.tiktok.com/t/ZT8xqCNy7/ She is “the Chief Excel Officer”.

likehelpful

Related Posts

AA looking for a project coordinator role. Any advice for making the jump?

like

Feedback on this Alpine A110: don’t buy one for more than 40k€. Rather go for an F-Type, a Boxster or an M2.

+ Fun, agility, good sound
- Cheap interior & details, 4-cylinder, too expensive

Post Photo
like
like

Relocating to work in NYC, and looking for a place to live with an excellent school system. Willing to commute up to 2hrs. Any recommendations (cities, counties, zip codes, etc.) will be much appreciated.

Hi All,
I am bit confused currently. Please help me with genuine suggestions.I am currently working in TCS since 7 years and TCS was my first company. TCS is giving me 6.25lpa. Now I got an offer of 16lpa in CTS for Automation Testing role. But once I started talking to friends i got to know that one of my frnd has recently been fired from CTS last year due t unavailability of project. Now i am scared as I m single child of my parent and i have to pay emi and handle my household. Please suggest

like

The Status on Barclays portal is showing Offer Approved. In how much time should i expect the offer letter??

like

How did Barclays helped it's employees during COVID?? Did they fire anyone???

like

Opinions on AbleTo?

like

About to do my first interview for an in house job (coming from a midsize firm).
What are some questions typically asked, and good answers to those questions?
What are some good questions to ask?

like

Hi fishes,

I am trying to download my salary certificate from the alumni portal (2016) but the pdf is password protected. I tried entering my employee id but it is not working. Can somebody help me with the password format?
Thanks and miss infy a lot

like
like

Our company is shopping around for anti-virus and anti-malware solutions, and encountering companies who “will not redline.” We’ve tried 3 vendors, and the only one who redlined quoted 5x what others have quoted. Some of it has to do with how the biz team is presenting, but has anyone else run into this? I’ve not seen another industry where an outright refusal to redline exists, let alone one where negotiating legal terms costs 5x!

like

My team (People & Org Advisory) is hiring a Director, based in the Bay Area. Shoot me a note if you’re interested!

likesmart

Hi Fishes,
I will complete my Masters in Information Systems from Georgia State University this fall. Banking on my prior work experience of 5.5 years in SuccessFactors implementation (Deloitte USI), I am targeting similar kind of roles at Deloitte and PwC.
Interviewed with Deloitte for SCon position but the offer has not been released yet. PwC interview is scheduled next week.

Can you please help me with the latest pay range for Atlanta location?

like

Apartment hunting in LA… having a bit of sticker shock. did everything go up? Will it go down in the fall??

like

I recently became an Anaplan Certified Level 1 Model Builder and have been applying to a lot of roles. Does anyone have any recommendation on companies to apply to and a range that is suitable with that certification? So far I have applied to the the big four consulting firms and Fintech companies.

Any help would be greatly appreciated!

like

Are there any scrum masters out there willing to take me on as a mentee? I recently received my CSM, but I know that is not enough to get a job. I am looking for someone to show me the ropes and help me apply what I learned in the CSM course so I can start applying for jobs within the next 6 months. I am currently a business development consultant dealing with enterprise accounts. I want to stay in tech but I HAVE to get out of sales. It’s just not for me. Thank you in advance!

like

I have a family member who is having a hard time finding an entry level data analyst role. He knows Python, SQL, and is AWS certified. Anyone know anyone or willing to refer him?

like

Additional Posts in Excel Genius

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

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

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.

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

Would anyone be willing to teach me vlookup?

like

Anyone know what these badges are?

Post Photo
likefunny

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

like

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

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 am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

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

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

How do you fix microsoft excel cannot paste data error?

like

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

likehelpful

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

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

like

I’m helping my GF with excel and need help lol. She works at a hospital and is trying to make an excel schedule for doctors to reserve rooms. She wants drop downs for days of the week (column K) and also different drop down menus in column P for the reserved time slots.

Is it possible to do this with two sets of drop downs (days of week + time slots) and not use index match here? She could make 5 tables for each day of the week, but prefers one table that can be easily navigated by doctors.

Post Photo
like

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

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

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