EXCEL FOR BEGINNERS, Auditors & Accountants

แชร์
ฝัง
  • เผยแพร่เมื่อ 24 พ.ย. 2024

ความคิดเห็น • 267

  • @VVrealities
    @VVrealities ปีที่แล้ว +9

    Lol I used to watch u when I was 22...now I'm 29. It took me 8 years to complete my accounting degree. I'm back here again. God bless u. I now have a job..I graduated last year. Thank you for everything

  • @fr33man80
    @fr33man80 6 ปีที่แล้ว +26

    You explain this so much quicker and clearly than my professor. Thank you and I fully support you if you want to keep making videos like this. Its helpful

    • @WithStephie
      @WithStephie  6 ปีที่แล้ว +3

      Wow thank you so much!! 💗

  • @SimplyMente
    @SimplyMente 4 ปีที่แล้ว +13

    Class of 2020...waiting to graduate virtually 🤣🤣🤣🤣... But decided am going to leave quarantine with all skills for my accounting job... Nice video... Have learnt alot

  • @manny_the_creative9678
    @manny_the_creative9678 3 ปีที่แล้ว +5

    Finally a video that actually goes step by step and makes sense. Thank you for the Tutorial 😇

  • @TheKrystolMethod
    @TheKrystolMethod 7 หลายเดือนก่อน +1

    I know you did this 5 years ago but this is so helpful as I'm not that good with excel. Normally with me using Excel I just have to keep track of what's already been started

  • @carlobambi9035
    @carlobambi9035 3 ปีที่แล้ว

    This video of you showing tips and tricks in excel deserves a big fat like. Loving this type of content!

  • @jenniferbrat
    @jenniferbrat 4 ปีที่แล้ว +9

    i’m a newly admitted accounting student and wanted to start teaching myself excel. i took a computer class before, but we didn’t go too in depth on excel and i know that’s where pretty much all accounting data goes. i thought i knew a pretty decent amount about excel, but i was so wrong! my jaw dropped when i found out that i could freeze headers at 5:26 😭 thank you so much for this video! so very helpful!!

  • @mariosrizk
    @mariosrizk 3 ปีที่แล้ว

    i am so thankful for this i am Financial Analyst and i really need allot of Excel advance and shortcuts please do stop teach us :) your so much help!!!!! highly appreciated

  • @nevermore_ind
    @nevermore_ind 9 หลายเดือนก่อน

    I wish I had such a beautiful teacher when I was learning to become a data analyst :)

  • @Dana-wr2tt
    @Dana-wr2tt 6 ปีที่แล้ว +5

    OMG thanks so much for this. I just started full time as an audit associate and didn't follow along well with the excel training we were given. I was literally just thinking about how Ill probably need to watch a tutorial on pivot tables and v lookups, then saw ur video!! I really was not in the mood to watch a lecture on excel, but yours feels like I'm just watching another fun (non work related) youtube video. :)

    • @WithStephie
      @WithStephie  6 ปีที่แล้ว +1

      I am so glad! I was worried it was going to be boring and glad it was tolerable haha 💗

    • @Dana-wr2tt
      @Dana-wr2tt 6 ปีที่แล้ว

      haha yeah u could not have put this up at a more perfect time. all the new hires at the bigger firms are just starting and need this desperately !

  • @leyr501
    @leyr501 3 ปีที่แล้ว +1

    Due to pandemic, it's hard to cope up with my study and the things I need to learn about my course but I don't wanna graduate unequipped with at least basic knowledge so I'm here in youtube.

  • @ranjanadissanayaka5390
    @ranjanadissanayaka5390 5 ปีที่แล้ว +2

    Hey, I just started out as a audit Trainee associate at KPMG,, and I been struggling with excel so much,, but within first few minutes of your video I learned just what I been lookin for. I'm gonna be so much faster at tomorrow at work.
    Thank you million times. 😊

    • @ranjanadissanayaka5390
      @ranjanadissanayaka5390 5 ปีที่แล้ว +2

      @Wraith Wraithin the class room we spend lots of time making balance sheets and income statements. But when you go to work place, you won't be given to make those until you become a senior

  • @optimusprime3143
    @optimusprime3143 5 ปีที่แล้ว +1

    Thx for vlookup , pivot table data value change and Use of F4 for freezing column and Row for formula

  • @Yorfallon21
    @Yorfallon21 5 ปีที่แล้ว +9

    I feel really good about how much I know. I currently do bookkeeping and know how to do most of these. I am a sophomore in college and I haven't started my Acct. classes yet. I am so bummed. Feel like its gonna be hard(time consuming) getting my BBA. Thanks for the extra knowledge!

    • @baselahmed6298
      @baselahmed6298 4 ปีที่แล้ว

      M on the sec y of Acc hope we can get n touch tho we can help each other by exchanging knowledge 😊

  • @beautybitten
    @beautybitten 6 ปีที่แล้ว +38

    LOL I'M GEEKING OUT OVER THIS VIDEO. I love excel hahahaha. Learning Excel as part of my business pre-req was the one class that I found extremely useful after college. Your work life is so much easier when you know shortcuts, formulas, and pivot tables. I still love using Excel to organize my personal life.

    • @WithStephie
      @WithStephie  6 ปีที่แล้ว

      Yessssss 🙌🙌🙌🤓

  • @secunatutoriais2537
    @secunatutoriais2537 5 ปีที่แล้ว +4

    Congratulation from Guiné-Bissau. I am Excel teacher. I love Excel!

  • @Brittt001
    @Brittt001 6 ปีที่แล้ว +48

    Just started in public accounting and NEEDED this video. Thanks!!

    • @Elpaladino1
      @Elpaladino1 6 ปีที่แล้ว

      Same with me... Thumbs up + comment for great video!

    • @mrdavid3163
      @mrdavid3163 6 ปีที่แล้ว +1

      Hello dear u look so nice wow

    • @biapac7849
      @biapac7849 4 ปีที่แล้ว +4

      @@mrdavid3163 Looks like she didn't care much bro 😂

    • @vinniechan
      @vinniechan 4 ปีที่แล้ว +1

      One thing I got repeatedly told off by my senior is rounding issue
      U need to use the round formula to make absolutely sure the decimals are properly dropped off and then u fix the rounding
      Simple displaying 2 or 3 decimal places won't do

    • @profadmire
      @profadmire 3 ปีที่แล้ว

      Hello will love to learn a lot from you.Am starting
      my public practice,am in Africa.

  • @dorisjames3170
    @dorisjames3170 3 ปีที่แล้ว

    I’m about to move into a new house and found your move video, I recently started a new data mgmt job and feel so Blessed for this awesome guide to Excel formulations-thank you!

  • @janicewa16
    @janicewa16 3 ปีที่แล้ว

    Yes do more short videos please! Yours is easy to follow and not an hour long like some videos on here. I like your lashes 😍

  • @nctan88
    @nctan88 6 ปีที่แล้ว +3

    Glad you are teaching this so I don't have to take classes from others. This is good. Continue.

  • @kennethalaka1536
    @kennethalaka1536 4 ปีที่แล้ว +1

    Wow..you make learning excel so easy!!! thank you so much!!!!!!!

  • @fatedgaming6550
    @fatedgaming6550 3 ปีที่แล้ว

    great effort! Ive recently started to study accounting and i was lost as to how the formulas worked. This gave me the answers to everything i was hoping for thanks so much!

  • @hezronsanga2991
    @hezronsanga2991 4 ปีที่แล้ว

    Your awesome, i listen the video and end up close all my notes which i was try to path through so as i can understand the excel, thanks for this gift.

  • @yashshah7250
    @yashshah7250 4 ปีที่แล้ว +2

    Hi Stephie!
    Thanks for the Awesome Video!
    Please do post more videos on Excel :)

  • @wombathappinessgirl7563
    @wombathappinessgirl7563 5 ปีที่แล้ว +3

    Seriously, I am investing time in your videos... good job & thank you so much.🙌🏽🙌🏽🙌🏽🙌🏽. Do more Accounting daily jobs with you? ❤️❤️❤️

  • @Erick-bg3cw
    @Erick-bg3cw 6 ปีที่แล้ว +1

    Thank you! I've been watching so many videos online about excel, since its one of my weaknesses. This was really helpful. 2 more semesters before I get my B.S in Accounting!

    • @WithStephie
      @WithStephie  6 ปีที่แล้ว +1

      Woohooooo almost done 🙌🙌🙌

    • @baselahmed6298
      @baselahmed6298 4 ปีที่แล้ว

      M on the sec y of Acc hope we can get n touch tho we can help each other by exchanging knowledge 😊

  • @Tunogkalyeah
    @Tunogkalyeah 4 ปีที่แล้ว +1

    Excel always present through any office transactions. My pleasure to also share my skills.

  • @faisalrehman5798
    @faisalrehman5798 4 ปีที่แล้ว

    Happy to see someone doing something like me like care about sheet to make a copy and using shortcuts but I think I'm doing the same job at an advanced level as I'm an accountant of UK clients. and I think I'm doing the same thing with the easy and smart way I can teach if you want dear.

    • @WithStephie
      @WithStephie  4 ปีที่แล้ว +1

      This video was meant for beginners, as stated in the title. Great to hear you have advanced skills.

    • @faisalrehman5798
      @faisalrehman5798 4 ปีที่แล้ว

      @@WithStephie email me I want to talk about something faisalwithsmy@gmail.com

  • @anrr5317
    @anrr5317 6 ปีที่แล้ว +17

    this is so helpful... please more excel and accounting software :)

  • @nuruldahiahdarmawi4548
    @nuruldahiahdarmawi4548 4 ปีที่แล้ว

    needed this because im starting my internship in few months. thank you so much!

  • @sarahdominiquef.villano4808
    @sarahdominiquef.villano4808 6 ปีที่แล้ว +12

    Thank you for creating this video. I appreciate how you want to impart knowledge you have in this field of study. You are an awesome person! You make it interesting to learn skills such as this one. May I ask if you happen to use quickbooks or any other accounting software, and may you share how to use it? If no, is excel the simplest one to use?

    • @WithStephie
      @WithStephie  6 ปีที่แล้ว +2

      Awww thank you for the kind words love!! I do use a couple of general ledger/ financial reporting tools but I wouldn't be able to share since it's my company's information. I actually have never used quickbooks before but I have used peachtree. Excel is definitely what we use most though as auditors outside software provided by company or accounting firm.

  • @soobax7544
    @soobax7544 3 ปีที่แล้ว

    great video. just one suggestion, instead of using shift+down arrow every time, you can insert table, named it, and its easier now to select any column.

  • @micheleann1737
    @micheleann1737 6 ปีที่แล้ว +1

    Great video. I wasn't aware of all the shortcut keys in excel.

  • @tatanacio91
    @tatanacio91 3 ปีที่แล้ว

    Thanks for the useful video! Definitely using these for my job!
    Also, loving the FREINDS reference 😂 PIVOTTTTT. Definitely one of the funniest scenes along with Phoebe imitating the bagpipes

  • @sivathasuon8223
    @sivathasuon8223 5 ปีที่แล้ว +1

    Great video. Please keep it coming. Thanks.

  • @ballermartial1508
    @ballermartial1508 4 ปีที่แล้ว

    Wanna become an accountant, this is a great start

  • @chrisvu422
    @chrisvu422 6 ปีที่แล้ว +5

    Wow! Thank you so much for posting this tutorial. I absolutely love your videos since I declared my Accounting major!
    I have an interview Monday for a regional CPA firm as an Audit Intern next summer. I’m so excited yet nervous because I really want this position. Do you have an advice for intern for interviews
    Thank you so much!
    XOXO

  • @silas_zur
    @silas_zur 2 ปีที่แล้ว

    "Pivot, pivot"
    Really useful quick video thanks so much!

  • @romettashavers-money8658
    @romettashavers-money8658 6 ปีที่แล้ว +1

    Yes please do a series 🙌🏼🙌🏼

  • @bryenyap6572
    @bryenyap6572 5 ปีที่แล้ว +1

    This is very helpful especially when i needed to do accounting work in excel as a non accountant xD love the way you teach

    • @WithStephie
      @WithStephie  5 ปีที่แล้ว +1

      Thank you so much!

  • @akavin5076
    @akavin5076 3 ปีที่แล้ว

    This video is very help full, which helped me in my work place.

  • @davidguo5954
    @davidguo5954 6 ปีที่แล้ว +2

    This was helpful. Would you be doing an advanced lesson? Or a tutorial of another data processing tool? If so, that'd be great!

    • @WithStephie
      @WithStephie  6 ปีที่แล้ว

      Thank you! I plan on doing super super basic then move to more advanced in the coming months! I don't really use many other softwares other than office products, at least softwares I could share.

  • @ingridhen619
    @ingridhen619 6 ปีที่แล้ว +1

    You are the best!!!!!
    Please do a series on excel. Dam it...i wish you were my sister. Thanks for all your videos.

    • @WithStephie
      @WithStephie  6 ปีที่แล้ว +1

      I'm your online sis 😉 so glad it was helpful!

    • @jitendrajena3232
      @jitendrajena3232 3 ปีที่แล้ว

      Where are you from?

  • @coreyfields175
    @coreyfields175 6 ปีที่แล้ว +1

    This was really helpful. I like how broke it down in a step by step manner. Looking forward to more videos like this.

  • @huyphamvuong1026
    @huyphamvuong1026 6 ปีที่แล้ว +1

    This video is super helpful to me. Thank you so much !!

  • @1986Unlimited
    @1986Unlimited 3 ปีที่แล้ว +1

    Lmao..pivot!!! Good times.
    Great Tutorial. Please continue making videos like this. Also, if you could attach your excel worksheets so that we can practice along side with you, that would definitely be a step up .

  • @marioandluigi54321
    @marioandluigi54321 6 ปีที่แล้ว +2

    I love this video - super useful since I just started. I’ve been subbed for over a year now and have loved all your advice and vlogs. Thank you Stephie!

    • @WithStephie
      @WithStephie  6 ปีที่แล้ว

      Awww thank you so much!

  • @anthonystonum8157
    @anthonystonum8157 5 ปีที่แล้ว +1

    Helpful, detailed, and very well organized. Awesome 👍🏽

  • @duongbui9477
    @duongbui9477 4 ปีที่แล้ว +1

    Thank you for a useful video

  • @summerchen1912
    @summerchen1912 5 ปีที่แล้ว +1

    Thanks for sharing! It’s really helpful 👍🏻👍🏻👍🏻

  • @ma.kathlenegailereyes2421
    @ma.kathlenegailereyes2421 3 ปีที่แล้ว

    super helpful huhu i wish i could have the same file and do it at the same time she does it to make me get a feel of whatever she's doing

  • @simonlaowo15
    @simonlaowo15 ปีที่แล้ว +1

    thanks for share

  • @pallavideepaksherigar445
    @pallavideepaksherigar445 6 ปีที่แล้ว +2

    You are the best❣looking forward to the series✌

  • @mcmillinitchsalceda3728
    @mcmillinitchsalceda3728 4 ปีที่แล้ว +1

    thanks you so much!
    Stephie, you're the best!

  • @anthonyvazquez8742
    @anthonyvazquez8742 6 ปีที่แล้ว +1

    Yesss!! Just started public accounting and this is exactly what I need.

  • @Crostoflame_
    @Crostoflame_ 4 ปีที่แล้ว

    Thanks a lot for making this video! My auditing internship starts tomorrow 🙂

    • @WithStephie
      @WithStephie  4 ปีที่แล้ว +1

      So exciting! Best of luck to you 🙌

  • @yeahitsevelyn
    @yeahitsevelyn 3 ปีที่แล้ว +3

    So happy I found this video... everything is simple, clear, and to the point
    I'm still a freshman at my college, but I am definitely gonna learn this now and save this video for future reference !:)

  • @natebrown1394
    @natebrown1394 2 ปีที่แล้ว

    I learned things! My first excel tutorial woot woot ty ty so much

  • @Ari-lu5ve
    @Ari-lu5ve 4 ปีที่แล้ว +1

    Need more excel videos!! Thanks!

  • @asianartifactful
    @asianartifactful 6 ปีที่แล้ว +1

    more please! this was super insightful and easy to follow!

  • @erici.8805
    @erici.8805 3 ปีที่แล้ว

    We all appreciate you! Very helpful thank you so much!

  • @libertyharvey8703
    @libertyharvey8703 4 ปีที่แล้ว

    I’ve got my final accounts exam tomorrow that focuses on excel! Can I just say a massive Thankyou! This video has really helped me out and made me feel a lot more confident! THANKYOU 💗

  • @arvie978
    @arvie978 4 ปีที่แล้ว

    This is so helpful for us dear..thanks for sharing

  • @lalamichael9236
    @lalamichael9236 4 ปีที่แล้ว

    Oh my goodness, I'm only a few minutes to this video & I love your style & presentation!! You get to the point and are so enjoyable to listen to & follow. I can't wait to dive into other videos. I've worked in accounting for 4 years and am always looking to work smarter and not harder. Thank you & you have new subscriber :)

  • @abichiart
    @abichiart 4 ปีที่แล้ว +3

    HI Stephie Mills, Can you discuss the create and reconcile transactions in excel?
    a. Money spent on credit cards
    b. Money out from checking
    Thanks in advance. 🌹

  • @sreedevimadhu4696
    @sreedevimadhu4696 6 ปีที่แล้ว +1

    Liked before I watch it...

    • @WithStephie
      @WithStephie  6 ปีที่แล้ว

      Hahaha thank you! Hope it earned the like 😉

  • @ricelhibionada9575
    @ricelhibionada9575 4 ปีที่แล้ว +1

    This is very helpful

  • @rmmccarthy1240
    @rmmccarthy1240 2 ปีที่แล้ว

    Outstanding! Thanks for the lesson!

  • @silentmeasure8141
    @silentmeasure8141 4 ปีที่แล้ว +2

    Thank you, Stephie, for your instruction. Did you happen to have a series for accountant and auditors? I recently have a job as an internal auditor internship for a tech company, and I really want to get better. Again, thank you so much.

  • @cogwheelLearning
    @cogwheelLearning 4 ปีที่แล้ว

    Really awesome video! I love teaching Excel to beginners too and I post some interesting tutorials daily

  • @deadmouzes8389
    @deadmouzes8389 3 ปีที่แล้ว

    on this years May i will be starting working as an accounting clerk, and I have 0 experience, but instantly got hired because I know typing and computers but excels i have a hard time learning, thanks to this I finally get to learn bit by bit. Thanks 🥰

  • @nm9857
    @nm9857 3 ปีที่แล้ว

    I thought Excel was too complicated for me but now that I know I can yell "PIVOT" when I make a pivot table it all makes sense.

  • @emztweety95
    @emztweety95 5 ปีที่แล้ว +1

    Thank you for this. You are very helpful!!

  • @KellysBeautySecrets
    @KellysBeautySecrets 6 ปีที่แล้ว +9

    I can’t wait to get back into college!! I’m going to make sure I take an excel and quickbooks course before graduating

  • @paulino_ayo
    @paulino_ayo 3 ปีที่แล้ว

    Awesome informative video! Very in-context and practical. Thank you

  • @mike-thewantrepreneurjourn8946
    @mike-thewantrepreneurjourn8946 4 ปีที่แล้ว

    this is a great tutorial, i have been using excel at my jobs for over 7 years. i want to do some tutorials also, covering pivot tables and vlookups or how to utilize the free templates in excel such as ones for budgeting

    • @WithStephie
      @WithStephie  4 ปีที่แล้ว

      Thank you and you definitely should! Sounds like helpful and interesting content 😊

  • @carsonscott2772
    @carsonscott2772 5 ปีที่แล้ว +1

    SUCH a good video!!! Thank you!

  • @Matt-hn4hn
    @Matt-hn4hn 4 ปีที่แล้ว +2

    Thanks you’re a big help!

  • @notebooksandlife
    @notebooksandlife 5 ปีที่แล้ว +1

    GIRL. I haven't finished watching the video yet, but I just want to say (before I forget lol) YOU'RE HELPING ME SO MUCH RIGHT NOW!!! lol
    I need to study all this for a new AP job because I've been putting it off for forever...and I remembered that you had made a video so I ran straight over here to find it.
    I freakin love you!!!!

    • @WithStephie
      @WithStephie  5 ปีที่แล้ว

      I'm so glad to was helpful and hope your new job is going great 💗

  • @maryhiano9154
    @maryhiano9154 6 ปีที่แล้ว +2

    Hi Stephie, yes more beginner content like this please and also I love your friendly sisterly advice series xox

  • @Jeebus0143
    @Jeebus0143 6 ปีที่แล้ว +1

    PLEASE do more excel videos. Just started as a first year staff accountant and I don't know anything

  • @victorserrano7939
    @victorserrano7939 5 ปีที่แล้ว +1

    Thank you for the content, can you do a video explaining tax coding, if I’m not mistaken I saw tht revenue is 100’s deductibles are 200’s, balance sheet 400’s and so on, thank you

  • @daliacaleia9883
    @daliacaleia9883 5 ปีที่แล้ว +1

    that was so hepfull!! I´m glad I found your channel, and I wish you post more videos like this. Thanks!!

  • @TheOfficalDarwin
    @TheOfficalDarwin 6 ปีที่แล้ว +1

    You're a natural I really enjoyed that 💖

    • @WithStephie
      @WithStephie  6 ปีที่แล้ว

      Awww thank you doll!

  • @jitendrajena3232
    @jitendrajena3232 3 ปีที่แล้ว

    Beautiful video for learn,so thanks for reaching

  • @patrickjohnson721
    @patrickjohnson721 3 ปีที่แล้ว

    Absolutely brilliant, thank you very much for the great tutorial! x ☺️☺️

  • @Marangelize
    @Marangelize 5 ปีที่แล้ว +1

    Thank you! I love this kind of videos, please please do more and
    more

  • @worldcitizen3577
    @worldcitizen3577 6 ปีที่แล้ว +2

    I love this video! More of this series please!

  • @patatim452
    @patatim452 3 ปีที่แล้ว

    This helps a lot. Thank you so much.

  • @elisapierre247
    @elisapierre247 6 ปีที่แล้ว +8

    Yeeaasss More in this series please!!

  • @insansombolinggi8275
    @insansombolinggi8275 5 ปีที่แล้ว +1

    Please do more videos like this!!

  • @gaofaye9346
    @gaofaye9346 6 ปีที่แล้ว +1

    You are so nice and helpful!

  • @azlanabrahman3866
    @azlanabrahman3866 3 ปีที่แล้ว

    Great video, useful tricks.

  • @ridwanmaulana6176
    @ridwanmaulana6176 4 ปีที่แล้ว

    would you mind if you add your file in description to be an exercise? because i find in internet and it is hard to find exercise. Thank you before and great video

  • @welcomeshorts770
    @welcomeshorts770 4 ปีที่แล้ว +1

    Very helpful ❤

  • @iangalinato3864
    @iangalinato3864 4 ปีที่แล้ว +3

    "Pivot Pivot!" LOL
    Ty for the vid!

    • @WithStephie
      @WithStephie  4 ปีที่แล้ว

      🤣🤣🤣🤣 thank you!

  • @Ssm1998
    @Ssm1998 5 ปีที่แล้ว +1

    Loved this. So much help!!

  • @muchymudzy6333
    @muchymudzy6333 5 ปีที่แล้ว +1

    just started my auditing job, omgshhh this is so helpful

  • @Pylemorgan
    @Pylemorgan 5 ปีที่แล้ว +1

    It would be so dope if you put a link to your example data that you started with so we can follow along and try it

  • @Adil-ig7it
    @Adil-ig7it 4 ปีที่แล้ว +1

    This is a very good summary, thanks so much!! 😊