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

Hi fishes,

My joining date mentioned in IBM Offer letter which I received just a while ago is second week of November, 2021. However, I have 90 days notice period. It also says to accept within 3 days and a clause is written that joining date can be revised only till 5 days. Will ibm revise my joining date ? I am very anxious it's too late so I cant even call recruiter.

Please suggest.

IBM started to drop the mail for join Slack etc. and the mail for laptop request for new hire .

What if I don't join on the last day or deny to join on last day ? Because still need to decide between two offers .

like

Do IBM has offices in Mumbai location??
More precisely for SAP practise in Airoli?? IBM

like

If anyone wish to re join IBM, what is the minimum gap one should have to take ?

like

Does Optum has a office in Panchkula, Haryana? Can we ask for a transfer to Panchkula office?

Optum Wipro Infosys Tata Consultancy Cognizant HCL Technologies

like

Do industry professionals involved in M&A sign to close and integration work long hours too or do they peace out at 6

likehelpful

Fishes, need some guidance.

What would ensue if I convice US talent recruitment team that I have US H1B visa and get my offer letter released, and then apply for US Visa?

Is this some sort of scam/crime?

Thoughts?

like

Can anyone join 2 companies at a time?

like

Hi fishes, need suggestion from your end.
YOE 3+
SAP Functional consultant
Which is better to join
PwC India or Infosys
Package are same.
Which is better in terms of WLB , Career growth, benefits? Hikes and bonus.

like

Signed up for a personal trainer! 2x/week strength training with her... to begin with!

like

How is sony india software for 15yrs exp abap developers and how is the pay, hikes..

Ive got a hedge fund research interview at an asset manager coming up. Spec is to contribute towards manager selection, research HF strategies, emphasis on both quantitative and qualitative research.

Anyone know what kind of skills they might be looking for? Particularly on the quant side as i have less experience there

like

Hi all!

Long time lurker, first time poster.

Have a pending application with Citi for a Real Estate Senior Risk Analyst AVP position, anyone have an idea as to what something like this would pay? Location is Buffalo NY area.

Thanks for your insite!

like

Hey anyone has advice on fixed income execution trader in a buy side firm? Sizable firm, good team, very low pay, okay wlb, been here for a year and working for 4 years in total, was sales/ small firm analyst before. Though trading is fun, but can’t think of executing orders for another 10 years. Trying to get on track of fixed income analyst - am doing some research in my spare time for my team now. What do you think of trader to analyst? Any good advice or same concerns? Appreciate any cmts!

Anyone at ZS willing to chat about a SIPA role? A recruiter reached out to me.

like

Hexaware is looking for API testing / Selenium automation professionals.

likehelpful

Any @capgemini fishes here to confirm current salary band for C and SC? Ideally HR Transformation and EE experience but just good to get some numbers and what leeway is there in negotiation?

Thank you

like

I've a question on what sections to put on a regular resume. I see some people are using consulting style resume for outside companies as well. Do you think it's a good idea to devide work experience by projets? Or is it better to have "projects highlights" separate from work experience.. something like: intro>functional expertise> project highlights>work experience>education?

like

Interested in pursuing a PhD in Econ (don’t have research experience or the math classes yet) what can I do to strengthen my app? Should I apply for a masters before phd? Graduated from a T20 undergrad with a finance major and good gpa, been working at D as an analyst for a year now

like

Additional Posts in Excel Genius

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

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

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

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

Post Photo
likehelpful

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

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

Would anyone be willing to teach me vlookup?

like

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

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

like

Anyone know what these badges are?

Post Photo
likefunny

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

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

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

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

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

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

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

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

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