Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

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

Formatting best practice, turning off grid lines rather than whiting cells, 3D sums etc

like

Under formatting best practice worth really pushing clear standard format for input cells.

Pivot / vlookup / sumifs / pivot charts

likesmart

Thank you those are definitely on the list!

Index Match, think about adding Power BI as well

likesmart

I would say Power Query is probably more relevant than BI.

I'm holding a trng session on v/xlookup and filters. You can get very basic very easily.

like

https://support.microsoft.com/en-us/office/excel-video-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb

like

Related Posts

Any tax saving ninja technique??

like
like

Can anyone please refer me for below opening Nokia

Post Photo
like

I got dotnet lead oppertunity in luxoft banglore as remote from chennai,
Is luxoft has job safety? Anyone work there here?

like

In my company, we have a staff of customer support agents to resolve user concerns, but they prefer to complain on social media and never call the number we give them. Should we transfer the agents to the Social Media platforms or insistently try to get them to call us?

like

Recommendations for an Alps ski resort between Zurich and Munich by car (Switz, Austria, Germany)? There are so many but looking for a developed village with lodging options and good lifts. Any faves?

like

Looking for senior Salesforce developers/architects in the US! Joined my previous mentor in starting a new Salesforce practice. Company is based in SF but we’re ok with folks working remotely. Might require some travel once it’s safe again but not anytime soon. Good opportunity to be actively involved in building something from nothing

like

Does vois provide transportation to eon, Pune?
What is the radius? Will help in choosing relocation locality.
Thanks in advance.

like

I need to rent a car and drive from NY to PA. Any Cody effective recommendations?

like

Curious to know what you've seen as working to non working dollars split in Canadian agencies. Reference any specific brands (or categories) if you can. I'm used to seeing the conventional 15-20% split for non working (production dollars only, not including media budget, agency fees) but are those days gone now with the takeover of digital (vs traditional) ad placements?

like

I voted for third party in presidential election. Biden and Trump have both been accused of sexual assault and inappropriate touching.

likefunny

Thank you Fishbowl - 👁 ❤️ 🐠

like

What’s all the hype about safemoon?

like

How are you using Machine Learning and AI at your agency? Internally or in projects?

Let me let in on a secret, customer supoort reps are just humans. PERIOD! Rant is over.

like

Hi guys,
Can anyone refer me for a product role in intuit ?

Thanks !!

Can anyone at Intuit give me referral for SDE Intern role?
I have good hold on DSA

like

I have a confession to make.

likehelpfulfunny

Additional Posts in Excel Genius

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)

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

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

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

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

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

Anyone know what these badges are?

Post Photo
likefunny

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

like

Would anyone be willing to teach me vlookup?

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

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

like

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

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

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

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

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

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

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

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

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