Excel Interview Questions for the Financial Analyst

Поділитися
Вставка
  • Опубліковано 28 вер 2024

КОМЕНТАРІ • 45

  • @jono4944
    @jono4944 2 роки тому +24

    as a grad breaking into the analyst space, you are honestly a hero, thank you so much!

  • @yvonnesaula9775
    @yvonnesaula9775 2 роки тому +3

    Thank you for the video .In my last interview i was required to use the sumif formula to get my revenue and design a profit and loss statement.Using the sumif formula was really a challenge for me.

  • @Renatofsa355
    @Renatofsa355 2 роки тому +4

    I would have highlighted the missing EBITDA value in the last company.

  • @inbracedefeat
    @inbracedefeat 2 роки тому +18

    On the final task, I think there are mistakes on cells C14, C18, C19, C20, E13, and E15 due to formatting mistakes. There should be two decimals on every cell (23.30 not 23.3). Seems small but as an analyst I am always grilled on details like this. Blank cells on D17 and E8 should be lised as 0 or - to indicate that it wasn't forgotten about. Should be 12 mistakes total.

    • @llehctimd
      @llehctimd Рік тому

      I agree, but I'd add B1 (space needed between words) and B12 (07 vs 7) as well

  • @el_chapo_ibn_john_al_drakowski
    @el_chapo_ibn_john_al_drakowski 2 роки тому +6

    Hi there, the link in the description shows an empty spreadsheet. Could you kindly update the spreadsheet or upload the correct file. Thank you.

  • @Bestafghanboy
    @Bestafghanboy 5 місяців тому

    Thank you for the useful stuff. Your explanation and examples are simple and effective.

  • @cavedshukla4778
    @cavedshukla4778 2 роки тому +3

    Can't open the dropbox file

  • @prachisharma444
    @prachisharma444 2 роки тому +2

    This was really helpful! 😁

  • @rishigupta2342
    @rishigupta2342 2 роки тому

    Thanks a lot.Could you make more such excel video?

  • @melvinholmes8862
    @melvinholmes8862 Рік тому

    I’m in a situation where I’m almost done with my degree but because I chose to do one of those pay as you go schools I can’t get my degree till it’s paid but I do get a completion letter. My question to is can I land an entry level position while I’m still paying off my degree?

  • @willm7994
    @willm7994 2 роки тому

    Good video can you please supply the dataset please ?

  • @J2LO
    @J2LO Рік тому

    More pls❤

  • @Perfectsound88
    @Perfectsound88 2 роки тому

    The practice file is empty.

  • @biazidbostame1059
    @biazidbostame1059 2 роки тому

    Link in the description is an empty spreadsheet.

  • @palwashakhan7
    @palwashakhan7 2 роки тому

    Which app do you use for recording?

  • @businessmindedwolf730
    @businessmindedwolf730 2 роки тому

    You looking beautiful ❤️

  • @MetalBreakdown
    @MetalBreakdown Рік тому +9

    I got my job as a financial analyst. This helped so much, thank you from the bottom of my heart.

  • @hamidmghazi
    @hamidmghazi 2 роки тому +6

    Would've been nice if you made the file available for practice

  • @suryapraveen8917
    @suryapraveen8917 2 роки тому +4

    How to get the spreadsheet for practice?

  • @darkpool906
    @darkpool906 2 роки тому +4

    DCF, WACC, company valuation + terminal value, LBO, VBA, pivot table

  • @davidalvarado3455
    @davidalvarado3455 2 роки тому +2

    Hi, the MS Excel file I find in the link is not the one you are using in the video, and it's almost empty. :(

  • @joeweissbach8390
    @joeweissbach8390 2 роки тому +10

    On the last task, can you please explain why having a blank cell for EBITDA (D17) is not considered a mistake?

    • @profbfc
      @profbfc 2 роки тому +4

      it is a mistake imo, there has to be a figure there even if it is 0

  • @Bhavikakumar5423
    @Bhavikakumar5423 2 роки тому +4

    Please make a video on how to be sure what role you want choose for a career in finance . Though, thank you so much for sharing your knowledge.

    • @BrainyFinance
      @BrainyFinance  2 роки тому +2

      That's a great one, will be published very soon :)

  • @jixuansun1257
    @jixuansun1257 3 місяці тому

    Can we use xlookup in teh first sheet ?

  • @aaroacademy
    @aaroacademy 2 роки тому

    Thank you for this Presentation. Much appreciated.

  • @brandoncollins2193
    @brandoncollins2193 2 роки тому

    I have never understood something better. You explain in a perfect way. Can I marry you?

  • @saulatalikhan5448
    @saulatalikhan5448 2 роки тому

    Hey I just want to have some more info relating to how to read bunch of accounting data. Can you please help in this?

  • @jcmtmusic6297
    @jcmtmusic6297 Рік тому

    Great video, have you got the spreadsheet file anywhere available for download?

  • @abdulrahmanomer7925
    @abdulrahmanomer7925 Рік тому

    Is The FMVA Certificate enough ?

  • @MuhammadAhmad-ou4jj
    @MuhammadAhmad-ou4jj Рік тому

    u are so cute and professional at the same time

  • @nadirbaig156
    @nadirbaig156 Рік тому

    I want to marry with you 💖 you agree

  • @ludovicivan7679
    @ludovicivan7679 2 роки тому

    Super concrete I like it

  • @mukeshpanth6405
    @mukeshpanth6405 2 роки тому

    How can I get this datasets

  • @ziyadmkd5537
    @ziyadmkd5537 2 роки тому

    Pretty cool channel

  • @maricelagutierrez4194
    @maricelagutierrez4194 2 роки тому

    Best video!

  • @barb4645
    @barb4645 2 роки тому

    Fabulous and impressive too. Thanks

  • @brunocaruso1082
    @brunocaruso1082 2 роки тому +1

    This is aninterview for kids no financial analyst. 🤣🤣🤣

    • @Perfectsound88
      @Perfectsound88 2 роки тому +1

      Can you post an interview video for Financial analysts then please?

  • @nasirulhaque8554
    @nasirulhaque8554 2 роки тому

    Hi, I hope you are doing well. Where do you work at?