Hello,
Can someone recommend me a good excel intermediate class? I want to learn about functions and making dash boards for my data analysis.

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

Functions: “Excel Tips and Tricks” on Amazon
Dashboards: search “excel dashboard” on Youtube

like

Thank you

like

Install copilot, the AI plugin for excel and word.

Also you tube and even tik tok has tons of really good tutorials.

I made a killer dashboard last year from watching YouTube, and I’m just getting familiar with copilot. It’s a game changer.

like

Awesome thanks for the tip and I will download the AI. Then let you know how it works for me

Related Posts

Made my first few options trades.

first lesson I learned- take profits ASAP! calls went from +100% to -20%.

like

Looking for a 1BR in Chelsea/Flatiron/West Village/Union Square. Any recs on buildings? Ideally <$4500

like

We are hiring! Great work/life balance and exposure. PM me if you want a referral.

likefunny

What are your biggest red flags when dating someone new?

likefunny

Hi All,
Whats is the CTC for new joiner Senior associate 1??

like

I work for a tech company that pays 100k tc plus 50,000 stock options. I have great work life balance, work 4 days per week on a 32 hour schedule plus it’s remote. Lately, I’ve been feeling like the compensation is on the lower end and just wanted to see if it’s in line with industry standards

Doing a budget travel to London for 4 days. Took a London pass for 3 days. Any other must dos while I'm there that can fall within my budget backpacking trip?

like
like

Is Toronto as boring and quiet as this bowl ?

funnylike

What’s a fair expectation for my first raise? Publicly traded co with ~2500 employees. I’ve been doing litigation with the company for almost 3 yrs and have only had a 2% cost of living raise so far. Graduated in 2014. Base comp is $127.5k in the Philly area. I see salaries all over the place in this site and it’s hard to tell whether mine is competitive.

like

I just get paid in production company lunches

like

Are Uber/Lyft drivers reluctant to drive from DC (Logan) to BWI?

Is there any way to get around the coinbase fee when buying crypto?

like

Thoughts on 36mm Rolex datejust? Too small? M

like

Sorry if this has been asked before but anyone have recommendations for brands that typically have a thiner profile? I’m shopping around for a piece in the $1k-$2k range (willing to buy pre owned).

I know this is probably asked a thousand times already: do you think in person GMAT classes are worth it..? Kaplan vs. Manhattan vs. other recommendations?

like

Novartis is providing permanent WFH, is this true?

I am looking for a 5-7 year commercial lease in zip code 60654, to commence in August or September 2023.

About 3000-3500 of space, consisting of one big space about 1,200 SQ ft, two smaller rooms, and a couple small offices. Being ADA compliant is important.

I love to work directly with the landlord if possible.

If you know of any availability ease let me know.

likefunny

For all those that have taken on a trainee to team up: what do you think is a fair split?

like

I am struggling to spend the time to study for the PHR. I have everything I need, but I feel exhausted from the work week every weekend. I’m looking to take it in August.. help? What do I do?

like

Additional Posts in Excel Genius

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.

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

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

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

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

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

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

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

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)

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

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

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

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

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

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

like

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

likehelpful

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

like

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

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