Paul Harris
Paul Harris
  • 59
  • 806 501
How to use Chat GPT in your accounting job! What are the limitations of Chat GPT?
I go through my initial impression of chat gpt and discuss where i think it could help elevate peoples roles and also what it's limitations are.
Every Excel Formula You will Need [to audit/finance analyst] - www.buymeacoffee.com/paulharris/e/24491
Excel Support for "Every Excel Formula" Workbook - www.buymeacoffee.com/paulharris/e/49732
Financial Statement Template File [Small Company] -
www.buymeacoffee.com/paulharris/e/23530
If you found this video helpful then support the channel buying me a coffee - www.buymeacoffee.com/paulharris
zhlédnutí: 25 371

Video

How I would answer Audit interview questions? From an ex PwC external auditor
zhlédnutí 15KPřed 2 lety
Thought this may be useful for those going for an interview to be an external auditor? Every Excel Formula You will Need [to audit/finance analyst] - www.buymeacoffee.com/paulharris/e/24491 Excel Support for "Every Excel Formula" Workbook - www.buymeacoffee.com/paulharris/e/49732 Financial Statement Template File [Small Company] - www.buymeacoffee.com/paulharris/e/23530 If you found this video ...
Answering your questions
zhlédnutí 1,5KPřed 2 lety
1:00 - Investing in Coinbase/ Crypto? 2:20 - should you invest in bonds 4:00 - what financial target to set yourself? 6:00 - are finance business partnering skills transferable across industries 7:35 - don’t know what you are getting yourself in for with your career? 10:00 - why invest in S&p500 and L&g tech index? 11:30 - should i get the cfa? 13:00 - worried about tax implications of investi...
10 Essential Pivot Table Tricks In Excel
zhlédnutí 13KPřed 2 lety
10 Essential Pivot Table Tricks In Excel Every Excel Formula You will Need [to audit/finance analyst] - www.buymeacoffee.com/paulharris/e/24491 Excel Support for "Every Excel Formula" Workbook - www.buymeacoffee.com/paulharris/e/49732 Financial Statement Template File [Small Company] - www.buymeacoffee.com/paulharris/e/23530 If you found this video helpful then support the channel buying me a c...
10 Excel Formulas to Learn First
zhlédnutí 6KPřed 2 lety
Every Excel Formula You will Need [to audit/finance analyst] - www.buymeacoffee.com/paulharris/e/24491 Excel Support for "Every Excel Formula" Workbook - www.buymeacoffee.com/paulharris/e/49732 Financial Statement Template File [Small Company] - www.buymeacoffee.com/paulharris/e/23530 If you found this video helpful then support the channel buying me a coffee - www.buymeacoffee.com/paulharris
Are you clever enough to do your job?
zhlédnutí 4,9KPřed 2 lety
If you found this video helpful then support the channel by subscribing or you can now buy me a coffee - www.buymeacoffee.com/paulharris Original video - czcams.com/video/P2mxdrTP-os/video.html
How to record a macro in excel to speed up your workflow
zhlédnutí 2,7KPřed 2 lety
Every Excel Formula You will Need [to audit/finance analyst] - www.buymeacoffee.com/paulharris/e/24491 Excel Support for "Every Excel Formula" Workbook - www.buymeacoffee.com/paulharris/e/49732 Financial Statement Template File [Small Company] - www.buymeacoffee.com/paulharris/e/23530 If you found this video helpful then support the channel buying me a coffee - www.buymeacoffee.com/paulharris I...
How I get more work done in a day
zhlédnutí 3KPřed 2 lety
If you found this video helpful then support the channel by subscribing or you can now buy me a coffee! Also available excel worksheet for financial analysts - www.buymeacoffee.com/paulharris
why you should try and stay within one company or industry
zhlédnutí 4,5KPřed 2 lety
If you found this video helpful then support the channel by subscribing or you can now buy me a coffee! Also available excel worksheet for financial analysts - www.buymeacoffee.com/paulharris
Communication Lessons from an ACA Qualified Accountant
zhlédnutí 2,5KPřed 2 lety
This video was requested by one of my subscribers. Hopefully there are some lessons to be learned for anyone starting out as a corporate accountant. Support the channel or download an excel workbook via this link - www.buymeacoffee.com/paulharris
What I actually do in a day: Finance Business Partner
zhlédnutí 13KPřed 2 lety
As requested by a subscriber; I go through a typical day as a finance business partner. Hopefully it helps give some indication of the type of work you will be doing if you are considering a move. Download excel workbook - www.buymeacoffee.com/paulharris subscribe for more stuff like this stuff.
Working From Home As A Financial Accountant. What is it like? Do we need to go to the office?
zhlédnutí 2,3KPřed 2 lety
My experience working at home as a financial accountant. Download excel workbook - www.buymeacoffee.com/paulharris
What is it Actually Like to be a Qualified Accountant?
zhlédnutí 5KPřed 3 lety
DOWNLOAD LINK TO ALL EXCEL FORMULAS - www.buymeacoffee.com/paulharris 8 year qualified as an accountant - i break down what i actually think about being an accountant and answer some frequently asked questions.
Excel: 10 things I wish I knew when I started using excel [Finance Analyst]
zhlédnutí 15KPřed 3 lety
Every Excel Formula You will Need [to audit/finance analyst] - www.buymeacoffee.com/paulharris/e/24491 Excel Support for "Every Excel Formula" Workbook - www.buymeacoffee.com/paulharris/e/49732 Financial Statement Template File [Small Company] - www.buymeacoffee.com/paulharris/e/23530 If you found this video helpful then support the channel buying me a coffee - www.buymeacoffee.com/paulharris
How to deal with stress at work....
zhlédnutí 3KPřed 3 lety
Having experienced stress at work, particularly whilst at PwC, i thought i would break down some of the things i do to manage the problem.
Quitting my Boring Accounting Jobs. Find a Role that will Challenge you...
zhlédnutí 9KPřed 3 lety
Quitting my Boring Accounting Jobs. Find a Role that will Challenge you...
Will Technology make the Accounting Profession Redundant?
zhlédnutí 20KPřed 3 lety
Will Technology make the Accounting Profession Redundant?
How much does it cost to have a child? First 2 years.....
zhlédnutí 1,8KPřed 3 lety
How much does it cost to have a child? First 2 years.....
How to move from Qualified Accountant to Equity Analyst [and other commercial role].....
zhlédnutí 6KPřed 3 lety
How to move from Qualified Accountant to Equity Analyst [and other commercial role].....
The Problem with Management.... (how to be an effective manager)
zhlédnutí 1,8KPřed 3 lety
The Problem with Management.... (how to be an effective manager)
VLOOKUP - all finance analysts need to know this trick to save loads of time
zhlédnutí 12KPřed 3 lety
VLOOKUP - all finance analysts need to know this trick to save loads of time
The problem with year end feedback reviews....
zhlédnutí 1,6KPřed 3 lety
The problem with year end feedback reviews....
Un-Pivot Data - Every finance analyst and auditor needs to know this hack...
zhlédnutí 2,3KPřed 3 lety
Un-Pivot Data - Every finance analyst and auditor needs to know this hack...
How to pass the ACA Exams first time
zhlédnutí 9KPřed 3 lety
How to pass the ACA Exams first time
First 10 Minutes on Excel
zhlédnutí 1,7KPřed 3 lety
First 10 Minutes on Excel
Accounting & Finance Degree - How does the Degree differ from the Accounting Profession?
zhlédnutí 5KPřed 3 lety
Accounting & Finance Degree - How does the Degree differ from the Accounting Profession?
Prepare your company financial statement using Excel [TEMPLATE FILE AVAILABLE]....
zhlédnutí 2,3KPřed 3 lety
Prepare your company financial statement using Excel [TEMPLATE FILE AVAILABLE]....
Answering your career questions....
zhlédnutí 3,9KPřed 3 lety
Answering your career questions....
Prepare your company financial statement using Excel [TEMPLATE FILE AVAILABLE]....
zhlédnutí 5KPřed 3 lety
Prepare your company financial statement using Excel [TEMPLATE FILE AVAILABLE]....
Don't make the same mistakes I did at PwC....
zhlédnutí 183KPřed 3 lety
Don't make the same mistakes I did at PwC....

Komentáře

  • @CarlosMoran-qp5ww
    @CarlosMoran-qp5ww Před 3 dny

    Do you think AI will take over financial jobs ?

  • @shanemistry5899
    @shanemistry5899 Před 18 dny

    Great video

  • @katysingh09
    @katysingh09 Před 22 dny

    I want to do accounting for my father’s small company but we live in different countries. How can I do it online? How can I gather information?

  • @yohannesabraham7472
    @yohannesabraham7472 Před 27 dny

    Great content as usual except that it is not clear when you used the Vlookup to put additional columns of dates (months and Qs)

  • @RomaStreetDentalBrisbane
    @RomaStreetDentalBrisbane Před měsícem

    In the grey box above click on the word "more" at the very end. The grey box will expand and the VB code and the other forumlas referred to in the video are displayed. Don't thank me... found it by accident! 🙄

  • @KatsC100
    @KatsC100 Před měsícem

    Thank you!

  • @connerprestonpierce
    @connerprestonpierce Před měsícem

    How do you do this also for the X axis?

  • @AdamThomson-tk2jw
    @AdamThomson-tk2jw Před 2 měsíci

    Paul can you do this without VBA or macros. I do not have access to developer

  • @bordua98
    @bordua98 Před 2 měsíci

    very informative! Thanks for the research

  • @sophieshen6886
    @sophieshen6886 Před 2 měsíci

    thank you for the valuable information!!! I have been watching through your CZcams videos. do you think becoming an accountant need certain types of personalities? and do you think people without these personalities can be train to become a good accountant?

  • @josephsy
    @josephsy Před 2 měsíci

    really like your delivery, thank you for the insights, really helps as someone trying to get into the industry

  • @erenyeager9944
    @erenyeager9944 Před 3 měsíci

    Amazing thanks a lot❤

  • @angelpaz4069
    @angelpaz4069 Před 4 měsíci

    Crazy how much this aligns with my experience. Literally exactly what I am currently going through.

  • @bhadrinath4191
    @bhadrinath4191 Před 4 měsíci

    ACCA FCCA

  • @milztothemax6854
    @milztothemax6854 Před 4 měsíci

    lol, i am on my 2 out of 3 client and have been getting attitude and no response. getting yelled at for not knowing how to do something and when i ask for coaching, they tell me to try it on my own and after i try it and do it wrong, i get spammed with the things i did wrong and that i need to be better. this video will hopefully help me understand ways to respond.

  • @tomaszstrzyzewski3612
    @tomaszstrzyzewski3612 Před 4 měsíci

    AI will make all accountants more efficient; hence, they will be capable of doing more work with the same effort, as part of their tasks will be automated. With a more efficient workforce, there will be fewer people needed on the market, and with fewer people needed, the competition for the job will be higher. In effect, the accountants, even though they become more efficient due to the implementation of AI tools, will be paid below the efficiency gain because of the job market competition. And you still need someone to be put to jail in case AI messes something up in taxes. You cannot put a computer into jail so I guess some positions are safe 😉

  • @carlosdna
    @carlosdna Před 4 měsíci

    Great explanation on diving in to the commercial finance business partnering. I will be glad and very pleased if we can share more of these experiences. Thank you!

  • @avidreader-pe7vm
    @avidreader-pe7vm Před 4 měsíci

    can you please share the excel file so we can practice along the video

  • @felicityzizomadikiza5210
    @felicityzizomadikiza5210 Před 4 měsíci

    Enjoyed it! Thank you

  • @jamesrice5683
    @jamesrice5683 Před 4 měsíci

    where's the code please?

  • @jonathanborg3626
    @jonathanborg3626 Před 4 měsíci

    Thank you for this valuable advice :)

  • @campbellblk7484
    @campbellblk7484 Před 4 měsíci

    I don't see the point of the cont/1 format, can't I just replace the minus with a bracket manually? Plus it's kind of confusing or hard to remember.

  • @maryamjurgees
    @maryamjurgees Před 5 měsíci

    thanks alot man this was helpful

  • @maryamjurgees
    @maryamjurgees Před 5 měsíci

    thanksss

  • @alexanderazarov2105
    @alexanderazarov2105 Před 5 měsíci

    excellent content!!

  • @CimolOk-nz5yj
    @CimolOk-nz5yj Před 5 měsíci

    🎯 Key Takeaways for quick navigation: 00:00 📚 *Introduction and Overview* - Introduction to the speaker's experience at PwC and the purpose of the video. - Insights into the mixed experiences at PwC, highlighting both positives and negatives. 00:40 🌱 *Early Career and Qualifications* - The start of the career at PwC, including the graduate scheme and qualifying as an accountant. - The importance of teamwork and building relationships during the strenuous process of studying for the ACA. 02:16 🤝 *Networking and Professional Growth* - Benefits of networking and professional growth through working with talented and experienced colleagues. - The competitive environment leading to a stressful experience due to long working hours. 03:38 ⏰ *Work Culture and Challenges* - Discussion of the work culture, including long hours and the pressure to exceed expectations. - Stress factors such as challenging work, poor management, and lack of recognition. 05:17 📈 *Learning and Development* - Positive aspects of challenging work and taking on more responsibility for personal and professional development. - The speaker's personal experiences with management and the lessons learned from handling stress and time management. 06:47 🔄 *Reflections on Work and Stress* - Reflections on the nature of work at PwC, including audit work, stress, and the impact on personal well-being. - The importance of recognizing the benefits and drawbacks of working in such an environment. 08:10 🎓 *Qualifications and Career Advancement* - The value of becoming a qualified accountant and the benefits of PwC's training for future roles. - How experiences at PwC provide a strong foundation for understanding and operating in finance teams elsewhere. 09:46 🔄 *Work-Life Balance and Final Thoughts* - Advice on work-life balance and the importance of happiness and self-awareness in career choices. - Concluding thoughts on the overall worth of the experience and advice for prospective PwC employees. Made with HARPA AI

  • @jd0879
    @jd0879 Před 5 měsíci

    Some things it’s good for but some things it’s really really bad

  • @tomstanely
    @tomstanely Před 6 měsíci

    OMG. Finally. That 10th point. I've always wondered if I could do that. Finally i found out how.

  • @tomstanely
    @tomstanely Před 6 měsíci

    It can give you excel formulas and VBA codes too

  • @bob-cq8wg
    @bob-cq8wg Před 6 měsíci

    Watching this video after enrolling myself in accountancy 🥶💪(I didn't know what accountants did until this video)

  • @Unknown-pt7xe
    @Unknown-pt7xe Před 6 měsíci

    Jeez, wait till this guy finds out about the dishwasher.

  • @norbarellis
    @norbarellis Před 6 měsíci

    I just miss BFEs. Every firm should have PwC's finance system

  • @goodvibesxox
    @goodvibesxox Před 6 měsíci

    if people say it’s easy wouldn’t it be fine starting out remote? or very high skill and hard that you need a ton of experience first. I see many say it’s close to impossible to start remote but I figured there’d be remote jobs (although very competitive to get)

  • @TheHomelessMoneyWizard
    @TheHomelessMoneyWizard Před 7 měsíci

    You have really great playlists and videos but i only found you after hours of watching and i nearly didnt click on the playlist. Im commenting because its a brill playlist and I think that theres a few points to think about that may help you reach more people. I have been watching YT videos on AI, ChatGPT and Accounting, Finance, and Auditing for about 12/13 hours a day for the last couple of months as I make a huge Accounting related playlist and add in things like new tech, AI, and other cool tech and tools that I think would be interesting and play it as I revise, study or do chores. Still, it has taken 7 hours of straight watching directly relevant videos to stumble across your playlist, and I only clicked on it when my computer jumped and I lost my queue, but didnt want to spend ages making another. The reason I didnt initially add the playlist was for a few reasons: 1) You cant read the entire playlist name when it pops up in recommendations. All you see is "Career advice - finance analysts, pro..." so it didnt really explain the playlist contents well and the chatgpt thumbnail made me think the entire playlist was about chatgpt. 2) It is worth looking into SEO to make your videos more friendly to the algorithm 3) Maybe cleaning up some of the editing Keep up the good work though because your content is actually really good, so sell it like it!

  • @aasthaarora7174
    @aasthaarora7174 Před 7 měsíci

    The way you explain in a polite and slow placed manner is very helpful for students. Really greatful to found your channel sir.

  • @aasthaarora7174
    @aasthaarora7174 Před 7 měsíci

    Thanks can you make more such videos

  • @andreakeeling9217
    @andreakeeling9217 Před 7 měsíci

    7:50 Yup, I was fired for asking questions and trying to follow the rules.

  • @andreakeeling9217
    @andreakeeling9217 Před 7 měsíci

    5:15 People who don’t know how to manage and mentor. Not cool. Booooooooooo bad manager.

  • @andreakeeling9217
    @andreakeeling9217 Před 7 měsíci

    3:30 I remember feeling the same way. I left the audit agency to get more experience in Accounting and Internal Controls. Now I’m confident but I can’t get the job back with the audit agency so I could show em what I learned. ❤❤❤❤❤

  • @SyahmiHaziq32
    @SyahmiHaziq32 Před 7 měsíci

    Could you speak a bit on the working culture of being an Auditor? Are all the working till midnight & lack of work/life balance justified and worth it?

  • @geraldparker1767
    @geraldparker1767 Před 8 měsíci

    PWC = Partners Without Conscience.!

  • @CimolOk-nz5yj
    @CimolOk-nz5yj Před 8 měsíci

    🎯 Key Takeaways for quick navigation: 00:00 🗣️ *Introduction to the video's topic* - Paul Harris introduces the theme of the video: discussing key experiences at PwC. - He aims to provide insights for those considering a career in finance or at a professional firm. 00:58 🏃‍♂️ *"Run Before You Can Walk" Scenario in Audit* - Harris describes a challenging audit task early in his career. - He emphasizes the difficulty of tasks requiring detailed knowledge and process adherence. - Discusses the stress and management issues faced due to lack of training and guidance. 06:40 🗨️ *Key Lessons and Advice* - Importance of asking questions, regardless of task progress. - Dealing with uncooperative or dismissive colleagues. - Emphasizes the value of effective communication in overcoming workplace challenges. 11:11 💼 *Finding Enjoyable Work* - Harris reflects on a positive experience at the end of his PwC tenure. - Describes a high-pressure but rewarding audit project. - Stresses the importance of finding meaningful work and proactive career management. 16:58 🚪 *Concluding Thoughts and Career Insights* - Harris shares his decision to leave PwC after feeling undervalued. - Encourages viewers to seek fulfilling roles and advocate for themselves. - Emphasizes the importance of communication in achieving career satisfaction. Made with HARPA AI

  • @TomHolmHansen
    @TomHolmHansen Před 8 měsíci

    Hi Paul, This is exactly what I have been looking for - except I need it for Google sheets where I am creating charts based on the "googlefinance" function! Would you have any suggestions how this can be implemented in their macro tool?

  • @GetTheFunkOutOfMyHou
    @GetTheFunkOutOfMyHou Před 9 měsíci

    Yeah, great session. AI is not fit for purpose yet. So let's get rid of ACA's who just look at other people's works. Lol. Good luck, 😊

  • @GetTheFunkOutOfMyHou
    @GetTheFunkOutOfMyHou Před 9 měsíci

    Don't ACA's audit work done by the internal accountants, in my 20 years experience, I've not seen an ACA who has any gravitas on the "True and fair view", they are students. Then ACA's move onto commerce / FS and have no idea.

  • @GetTheFunkOutOfMyHou
    @GetTheFunkOutOfMyHou Před 9 měsíci

    I think AI will take ACA first, future statements are different, they'll be next after 20 years. Have you seen AI output? It's crap, so let's have a con ersation once we see a beta model.

  • @Ahmed-jl7uh
    @Ahmed-jl7uh Před 9 měsíci

    Where can I find the work file to practice?

  • @farooqtahir538
    @farooqtahir538 Před 9 měsíci

    I find this video highly useless

  • @farooqtahir538
    @farooqtahir538 Před 9 měsíci

    Bad video quality