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

Used car prices starting to come down?

like

SAP SuccessFactors named a Leader in IDC MarketScape for Worldwide Modern Talent Acquisition 👏

#SAP #SuccessFactors #IDC #TalentAcquisition

Post Photo

How many days will it take for Wells Fargo to release the offer letter ?
I attended my interview and got shortlisted as well, I just got an email stating congratulations and send us list of documents !! After which When I try contacting the HR, he's not responding !! What do I do in such case !!
Kindly Advise...

like

Any good matress suggestions? I know this isn't the right forum but we all care for a good sleep so just wanted to get others thoughts

2H 2022 - Production Release Upgrade Commences!!
#SAP #SuccessFactors #HXM #ReleaseUpgrade

Post Photo

What is the best firm in NY for an associate interested in international tax planning (inbound and outbound), M&A, and transfer pricing?

likehelpful

Looking for senior Business Analyst for a technology consulting project (robotics process automation). Small fast paced team with great client, salary range 100-130k. CBP badge required (active is preferred, recent or equivalent clearance is OK too). DM me for details and job posting

like

Can someone explain the Marriott status process to me? I am one year away from hitting life time status but doesn’t look like I am going to hit the 75 nights this year to keep titanium. (Cont. below)

like

LA: after months of layoffs and salary reductions, we are back! Looking to hire a rockstar LA-based Project Manager at our small independent agency. Projects vary from photoshoots to retail to branding/strategy. Looking for mid to senior level. Diverse candidates encouraged to apply! PM me for details.

like

Has anyone been fired? How’d you bounce back? How did you approach it when applying for new jobs? I’m legitimately worried I’ll be fired and could use some advice.

like

$700 a month lease (tax-in, 39m/10k) R-Dynamic (380hp V6). Only first month and registration due up front. I can’t think of anything as good or better I can get for that much. Thoughts?

Post Photo
likesmart

About to get a home improvement loan. Any recommendations for a lender? Also looking for general advice. TIA!

like

Hey guys… I hope you all are fine and doing well. Can anyone please refer me for Salesfore developer position for total 3 years of experience and 2 years of relevant experience into Salesforce. Immediate Joiner. It would be a great help !
TIA !!

like

For writing samples in clerkship applications, can you edit/revise a final work product already submitted to the court? For instance, if there's a typo or something. Can more substantive edits be made to improve the work product?

like

At what time does appraisal happen at your workplace?

Is it 31st March, 01st April, mid April?

like

Does anyone have insights into recruiting at the Dubai office? Have things slowed down?

like

Justifying the Sheraton's painful bed to yourself because the Four Seasons don't recognize your loyalty

like

Deloitte fish: I’m an alum trying to do some retirement planning. I was an SM2 vested in the pension plan (I worked in DTTL for 7 years ending 2013) and want to find out what my actual benefits will be and at what age. I have no paperwork and 800-Deloitte does not seem to have a way to route me to the right people. Does anyone have a human contact or procedure that can help me get this info?

like

Any book recommendations about human psychology / thought processes?

like
like

Additional Posts in Excel Genius

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

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

like

Hey fishies, looking for some help with the below

I have 4 lots of data categories which are assigned a code in the adjacent cell
Eg:
Cell A2= 'xyz' Cell B2 = 'w1'
Cell C2= 'ghi' Cell D2 = 'x1'
Cell E2= 'plm' Cell F2 = 'y1'
Cell G2= 'mhn' Cell H2 = 'z1'

The combination of the 'W','X','Y' and 'Z' codes identity a specific trend
I am extracting data which includes multiple combinations of these codes. What is the best way to show frequency of the codes against the category it is assigned to

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

Our Data is only showing when something has changed, is there any way to make excel fill in the values?

Post Photo
like

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

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

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

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

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

Recently made a job switch and have been using a lot more excel. Any free resources to help build a solid foundation / fee based courses to help improve my skills?

like

How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

Post Photo
like

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

Would anyone be willing to teach me vlookup?

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

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 2-finger touchpad scroll not work on Excel sheets anymore? I used to be able to swipe quickly on my laptop's touchpad to navigate sheets but now it doesn't work. Based on the handful of posts I've read online about it, the problem seems unresolved. Has anyone dealt with the same issue and fixed it?

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

I am looking for a way to link my Salesforce data into excel so I can have the latest data at all times. Instead of the typical download of static data that by the time I am reporting the data has changed.

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