As a beginner in Excel I have few questions,
How to learn Excel ?
What type of Excel skills require to get into this field (as Intern) ?
How do I Crack interview ?

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

What field ? What interview? What do you currently do on a day to day with excel?

like

Learn the basics of formatting, pivot tables, basic formulas etc

YouTube is a great place to start. Large number of people offering their knowledge on excel (basic tutorials, specific formulas, etc). Pretty sure Microsoft has some free online stuff to look at as well. I'd stay away from programs that require payment, as I feel its not worth it (especially if excel isn't the only thing you'll be doing on a job)

Recently I’ve found that GitHub also have some good learning materials you can checkout

Related Posts

Is building a personal website using Wordpress a good way to stand out as a PM candidate (junior) or is it better to code it from scratch? - I have some coding knowledge but mostly concerned if hiring managers would care.

like

Only a few of the engineers I've met have been antisocial, and it seems like such people are represented fairly evenly across different careers. I'm not really sure why that misconception still exists

like

EY folks, anyone get their Invisalign covered by insurance?

like

Recommendations for a weekend in SF?

like

Hi All, I have an urgent query regarding TCS BGC process. My issue is that I have worked in X, Y and Z companies.
In X company I worked for 26months but my pf account is there for last 13months, before that my salary was very low so sometimes I got salary in hand or in pay cheque. I do have salary account statement for most of the months except 3-4 months in between my tenure. Will I face any issue for this?
Note: I do have good relationship with X company.
Please give your valuable suggestions.

like

Hi all! Can anyone share recordings of successful McK PEI stories?

likefunny

Looking to pivot into healthcare consulting. I come from a MHA background with a two year Administrative Fellowship following it. Any experience breaking into one of the top consulting firms with this type of background?

Any reputable universities in US that offers part time PhD - in management, business or public policy?

like

Need a letter of recommendation from someone outside my network.

Anyone in the world of willing to help me out?

like

Job referral- Eide Bailly is looking for remote bookkeepers, accountants & tax professionals. Let me know if you need a referral.

like

Just saw the bonus of this year would be paid on 11/13.
Im new to the company, if I haven't been notified that I'll get a bonus, does that mean I get nothing this year?

Does anyone know the timeline between the assessor interview and the confirmation interview? Had my assessor yesterday and wondering when I might hear if I'm continuing foward.

Hi i am currently working in Sopra Steria as a Senior Software Engineer. A new opening for ORACLE EBS Technical has opened. Let me know if any wants to apply. You can contact me at +91-9711867379
Sopra Steria

Post Photo

Never thought I’d say this, but virtual happy hours are WAY worse than hanging out with your team in a bar. At least in person you can circulate.

like

Recieved a call from infosys on interview for tomorrow .but they haven't scheduled the time. is it possibly canceled?

Any tips for how to maximize property damage insurance claim?

I'm 1st time landlord and my single tenant in Seattle unfortunately overdosed on cocaine+pills 5 days before found in kitchen. :( Extensive damage.

Seeking tips - ex. contractor validating damage was on highest cost cabinets & flooring, replace all tile/grout, contractors upbid damage value (within reason).

Too many are advising being bold w insurance companies we all pay for most our lives, but open to all advice.

like

What's the best way to stay productive throughout the day? I often hit an afternoon slump

like

What’s everyone’s take on Alteryx?

like

Additional Posts in Excel Genius

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

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

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

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

How do I change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

like

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

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

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

Post Photo
likehelpful

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

like

Would anyone be willing to teach me vlookup?

like

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

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

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

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

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

like

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

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

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

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