Will Boardman
Will Boardman
  • 106
  • 466 844
How to do a Vlookup and Hlookup in Excel (SIMPLE SOLUTION with EXAMPLES)
Within this video I'll walk you through how to do vlookup and hlookup in Microsoft Excel.
Thank you for watching the video and supporting the channel! Links below:
willboardman_
www.linkedin.com/in/will-boardman
will-aat@outlook.com
📚 Looking for the best AAT study material?
accountext.co.uk/
Use code: "will20" for 20% off your order.
☕ Looking for the best coffee to help you focus?
londonnootropics.com/
Use code: "Willboardman" for 15% off.
#accounting #accountingexam #accountingeduction #exampreparation #accountingtips #finance
มุมมอง: 191

วีดีโอ

How to do a Bank Reconciliation with Examples (SIMPLE METHOD!)
มุมมอง 43516 ชั่วโมงที่ผ่านมา
Within this video I'll walk you through how to do a bank reconciliation in accounting. Thank you for watching the video and supporting the channel! Links below: willboardman_ www.linkedin.com/in/will-boardman will-aat@outlook.com 📚 Looking for the best AAT study material? accountext.co.uk/ Use code: "will20" for 20% off your order. ☕ Looking for the best coffee to help you focus?...
AAT Level 4 - INAC Examiners Report Review
มุมมอง 32814 วันที่ผ่านมา
Within this video I'll be taking you through the internal accounting systems and control (INAC) examiners report and adding my thoughts! Thank you for watching the video and supporting the channel! Links below: willboardman_ www.linkedin.com/in/will-boardman will-aat@outlook.com 📚 Looking for the best AAT study material? accountext.co.uk/ Use code: "will20" for 20% off your order...
Prepaid Income Explained (SIMPLE METHOD WITH ACCOUNTING ENTRIES)
มุมมอง 48721 วันที่ผ่านมา
Within this video I'll walk you through how to account for prepaid income within your accounts. This video forms part of the accruals concept of accounting which states goods or services are to matched with the period that they took place. It's also known as the matching concept. Thank you for watching the video and supporting the channel! Links below: willboardman_ www.linkedin....
How to Balance off Accounts in Accounting (Balancing T Accounts with Examples)
มุมมอง 859หลายเดือนก่อน
Within this video I'll be taking you through how to balance off accounts within accounting. I'll also be explaining what the purpose is and why it's useful for the business with a couple of examples. Thank you for watching the video and supporting the channel! Links below: Trial Balance Tutorial: th-cam.com/video/6N1JRYSQ2Hw/w-d-xo.html willboardman_ www.linkedin.com/in/will-boar...
Which AAT Level Should I Start on?
มุมมอง 416หลายเดือนก่อน
Within this video I'll be trying to answer the question Which level AAT should I start on? Thank you for watching the video and supporting the channel! Links below: www.willboardman.co.uk willboardman_ www.linkedin.com/in/will-boardman will-aat@outlook.com Link to my full library of videos: tinyurl.com/2ye4xunx 📚 Looking for the best AAT study material? accountext.co.uk/ Use code...
AAT Level 2 - Qualification Overview (and Considerations!)
มุมมอง 1.2Kหลายเดือนก่อน
Within this video I'll be looking at the AAT level 2 Qualification, its structure and whether you should be looking at the bookkeeping or accounting route. Thank you for watching the video and supporting the channel! Links below: Self-employed licence information: www.aat.org.uk/membership/licensed-membership-be-your-own-boss Find an AAT assessment venue: www.aat.org.uk/assessment-venues/search...
6 Reasons you SHOULD become an Accountant
มุมมอง 870หลายเดือนก่อน
Within this video be going through 6 reasons you should become an accountant. Thank you for watching the video and supporting the channel! Links below: www.willboardman.co.uk willboardman_ www.linkedin.com/in/will-boardman will-aat@outlook.com Link to my full library of videos: tinyurl.com/2ye4xunx 📚 Looking for the best AAT study material? accountext.co.uk/ Use code: "will20" fo...
AAT Level 4 - Applied Management Accounting (AMAC) - Mock Exam Walkthrough - Part 4
มุมมอง 7992 หลายเดือนก่อน
Within this video I'll be walking you through Task 7 and 8 of Applied Management Accounting. This is covering mock two from the AAT website. Thank you for watching the video and supporting the channel! Links below: www.willboardman.co.uk - Looking for AAT revision and additional mock exams? willboardman_ www.linkedin.com/in/will-boardman will-aat@outlook.com Link to my full libra...
AAT Level 4 - Applied Management Accounting (AMAC) - Mock Exam Walkthrough - Part 3
มุมมอง 7352 หลายเดือนก่อน
Within this video I'll be walking you through Task 5 and 6 of Applied Management Accounting. This is covering mock two from the AAT website. Thank you for watching the video and supporting the channel! Links below: www.willboardman.co.uk - Looking for AAT revision and additional mock exams? willboardman_ www.linkedin.com/in/will-boardman will-aat@outlook.com Link to my full libra...
AAT Level 4 - Applied Management Accounting (AMAC) - Mock Exam Walkthrough - Part 2
มุมมอง 1.1K2 หลายเดือนก่อน
Within this video I'll be walking you through Task 3 and 4 of Applied Management Accounting. This is covering mock two from the AAT website. Thank you for watching the video and supporting the channel! Links below: www.willboardman.co.uk - Looking for AAT revision and additional mock exams? willboardman_ www.linkedin.com/in/will-boardman will-aat@outlook.com Link to my full libra...
AAT Level 4 - Applied Management Accounting (AMAC) - Mock Exam Walkthrough - Part 1
มุมมอง 2K2 หลายเดือนก่อน
Within this video I'll be walking you through Task 1 and 2 of Applied Management Accounting. This is covering mock two from the AAT website. Thank you for watching the video and supporting the channel! Links below: www.willboardman.co.uk - Looking for AAT revision and additional mock exams? willboardman_ www.linkedin.com/in/will-boardman will-aat@outlook.com Link to my full libra...
Going from AAT Level 3 to AAT Level 4 - BE PREPARED!
มุมมอง 1.7K3 หลายเดือนก่อน
Within this video I'll be walking you through some key points you should know going from AAT level 3 to level 4. AAT results calendar: www.aat.org.uk/prod/s3fs-public/assets/AAT-Q2022-EPA-result-release-dates-synoptic-calendar-2023-2024.pdf Thank you for watching the video and supporting the channel! Links below: www.willboardman.co.uk - Looking for AAT revision and additional mock exams? insta...
AAT Level 4 - Drafting and Interpreting Financial Statements (DAIF) - Mock Exam Walkthrough - Part 4
มุมมอง 9663 หลายเดือนก่อน
Within this video I'll be walking you through Task 6 and 7 of Drafting and Interpreting Financial statements. This is covering mock two from the AAT website. Thank you for watching the video and supporting the channel! Links below: www.willboardman.co.uk - Looking for AAT revision and additional mock exams? willboardman_ www.linkedin.com/in/will-boardman will-aat@outlook.com Link...
AAT Level 4 - Drafting and Interpreting Financial Statements (DAIF) - Mock Exam Walkthrough - Part 3
มุมมอง 1.2K3 หลายเดือนก่อน
Within this video I'll be walking you through Task 5 of Drafting and Interpreting Financial statements. This is covering mock two from the AAT website. Thank you for watching the video and supporting the channel! Links below: www.willboardman.co.uk - Looking for AAT revision and additional mock exams? willboardman_ www.linkedin.com/in/will-boardman will-aat@outlook.com Link to my...
AAT Level 4 - Drafting and Interpreting Financial Statements (DAIF) - Mock Exam Walkthrough - Part 2
มุมมอง 1.3K4 หลายเดือนก่อน
AAT Level 4 - Drafting and Interpreting Financial Statements (DAIF) - Mock Exam Walkthrough - Part 2
AAT Level 4 - Drafting and Interpreting Financial Statements (DAIF) - Mock Exam Walkthrough - Part 1
มุมมอง 2.6K4 หลายเดือนก่อน
AAT Level 4 - Drafting and Interpreting Financial Statements (DAIF) - Mock Exam Walkthrough - Part 1
AAT Level 2 - Business Environment (BENV) - Mock Exam Walkthrough - Part 2
มุมมอง 2.6K4 หลายเดือนก่อน
AAT Level 2 - Business Environment (BENV) - Mock Exam Walkthrough - Part 2
AAT Level 2 - Business Environment (BENV) - Mock Exam Walkthrough - Part 1
มุมมอง 4.4K4 หลายเดือนก่อน
AAT Level 2 - Business Environment (BENV) - Mock Exam Walkthrough - Part 1
5 Misconceptions about Accounting
มุมมอง 5305 หลายเดือนก่อน
5 Misconceptions about Accounting
AAT Level 3 - Tax Processes for Business (TPFB) FA23 Mock Exam Walkthrough - Part 2
มุมมอง 3.8K5 หลายเดือนก่อน
AAT Level 3 - Tax Processes for Business (TPFB) FA23 Mock Exam Walkthrough - Part 2
AAT Level 3 - Tax Processes for Business (TPFB) FA23 Mock Exam Walkthrough - Part 1
มุมมอง 5K5 หลายเดือนก่อน
AAT Level 3 - Tax Processes for Business (TPFB) FA23 Mock Exam Walkthrough - Part 1
6 Ways to Study AAT (Cheapest to Most Expensive!)
มุมมอง 1.5K5 หลายเดือนก่อน
6 Ways to Study AAT (Cheapest to Most Expensive!)
5 Benefits of Completing the AAT Qualification
มุมมอง 2.7K6 หลายเดือนก่อน
5 Benefits of Completing the AAT Qualification
NEW AAT Revision Sessions!
มุมมอง 3.3K6 หลายเดือนก่อน
NEW AAT Revision Sessions!
AAT Level 2 - Principles of Bookkeeping Controls (POBC) - Mock Exam Walkthrough - Part 2
มุมมอง 4K6 หลายเดือนก่อน
AAT Level 2 - Principles of Bookkeeping Controls (POBC) - Mock Exam Walkthrough - Part 2
AAT Level 2 - Principles of Bookkeeping Controls (POBC) - Mock Exam Walkthrough - Part 1
มุมมอง 8K6 หลายเดือนก่อน
AAT Level 2 - Principles of Bookkeeping Controls (POBC) - Mock Exam Walkthrough - Part 1
The Statement of Financial Position Explained - Sole Trader (FULL EXAMPLE)
มุมมอง 1.3K7 หลายเดือนก่อน
The Statement of Financial Position Explained - Sole Trader (FULL EXAMPLE)
Flexed Budgets - Complete Guide (WITH EXAMPLES)
มุมมอง 1.9K7 หลายเดือนก่อน
Flexed Budgets - Complete Guide (WITH EXAMPLES)
Errors NOT Disclosed Within a Trial Balance (With Examples)
มุมมอง 2K7 หลายเดือนก่อน
Errors NOT Disclosed Within a Trial Balance (With Examples)

ความคิดเห็น

  • @fossyboy100
    @fossyboy100 7 ชั่วโมงที่ผ่านมา

    Amazing as always, thanks Will! Just wondering does the F4 to lock cell values work in an aat exam?

  • @user-ClaireChadwick
    @user-ClaireChadwick 10 ชั่วโมงที่ผ่านมา

    Fab thanks Will, i know your busy but hoping you will do a walk through on a few other excel questions in MATs I.e IF, conditional formatting, charts 😁

    • @Willboardman
      @Willboardman 7 ชั่วโมงที่ผ่านมา

      Hopefully so, that’s the plan :)

  • @hanimaa.x7964
    @hanimaa.x7964 วันที่ผ่านมา

    Can you do AAT Level 2 in accounting and once completed apply for the AATQB license as you’ve done the 2 units of bookkeeping as well?

    • @Willboardman
      @Willboardman 19 ชั่วโมงที่ผ่านมา

      Hi, you’ll need to do the level 3 bookkeeping units (FAPS, and TPFB) in order to apply for AATQB

  • @hanimaa.x7964
    @hanimaa.x7964 วันที่ผ่านมา

    Could you please explain the debit and credits for 5c

    • @Willboardman
      @Willboardman 19 ชั่วโมงที่ผ่านมา

      So the debits here are expenses to the business, the credits are all liabilities because they are not paid immediately :)

  • @lukefraser7811
    @lukefraser7811 2 วันที่ผ่านมา

    Are you able to do another AAT mock exam, your explanations are good.

  • @rebekahmontague3734
    @rebekahmontague3734 2 วันที่ผ่านมา

    Very helpful, thank you!

  • @bruhmoment8592
    @bruhmoment8592 3 วันที่ผ่านมา

    Will, i could kiss you. Keep on the good work. AAT till i die

  • @emm1086
    @emm1086 3 วันที่ผ่านมา

    Thank you for such useful videos. I just watched your video on ways of studying aat. I'm thinking to study the book keeping cpurse. For self study which books would your recommend? And could you kindly recommend any providers for the 'Organised self study'? And finally, if I want to enter the work market ASAP,, is it better to study the accounting course or just the bookkeeping course? Thank you

    • @Willboardman
      @Willboardman 2 วันที่ผ่านมา

      Hi, I would recommend the accountext books, if you use code will20 you’ll also get 20%. In my opinion these are the best to self study with. In terms of the provider have a look at Training Link!

  • @wailinesao
    @wailinesao 3 วันที่ผ่านมา

    Thank you Will its really very useful.

  • @qlecaterina3417
    @qlecaterina3417 4 วันที่ผ่านมา

    Amac links are not in the library links

  • @lindakirby2540
    @lindakirby2540 5 วันที่ผ่านมา

    Thank you so much for another fantastic video. Such a big help!

  • @JAFFER3657
    @JAFFER3657 6 วันที่ผ่านมา

    do you have any recommendation in which order the standards should be studied?

  • @emilyannreeve
    @emilyannreeve 7 วันที่ผ่านมา

    my unicorn loves, big red mangos, and then add another 'm' (sounds insane but im using it :D) = M=UxL, B=R-M, M=B+M

  • @agrawalchirag
    @agrawalchirag 9 วันที่ผ่านมา

    Hi Will, in the last question (task 4 f), you explain that a sales return will decrease assets as our trade receivables have decreased, but on the other hand, our stock (inventory) would increase, which is an asset. I am so confused.

    • @Willboardman
      @Willboardman 19 ชั่วโมงที่ผ่านมา

      So it’s referring to the entires for the sales return, this would be to debit sales returns, debit vat and credit trade receivables. So the entries for the return itself would not increase the inventory. The inventory would be picked up when doing the valuation in a separate journal

  • @patrycjanowak3152
    @patrycjanowak3152 9 วันที่ผ่านมา

    Do you have video regarding trial balance adjustments?

  • @mariatt293
    @mariatt293 12 วันที่ผ่านมา

    this was so helpful tysm😊 but i’m confused as to why receipts are recorded on the credit side could u explain pls!

    • @Willboardman
      @Willboardman 12 วันที่ผ่านมา

      No problem, they’re recorded on the credit side because it reduces the asset (the amount owed to the business). So a debit to receivables increases the total amount owed to the business. A credit to the receivables reduces the total amount owed. So when the customer pays this reduces the amount owed to the business. We’d therefore credit the receivables and debit the bank.

  • @IzabelaCoyle
    @IzabelaCoyle 14 วันที่ผ่านมา

    Great video! Hopefully the Mock 1 practice assessment will be released before my exam🤞 as I find it very helpful !

  • @nathanheywood6391
    @nathanheywood6391 15 วันที่ผ่านมา

    If you did level 4 via Distance learning would you recommend waiting for results before starting next module (incase you fail exam) or carry on to next module once you've sat your exam? Also which optional choices would you select as the best ones?

    • @Willboardman
      @Willboardman 12 วันที่ผ่านมา

      I’d make a start on the next unit and then if you were to unfortunately fail then I’d leave off the new unit and go back to the old unit!

  • @fabiasemedo7906
    @fabiasemedo7906 16 วันที่ผ่านมา

    What abou if we don’t have enough money ro cover the “issues”

  • @LusiaEyre
    @LusiaEyre 16 วันที่ผ่านมา

    It says in the scenario that our major competitor stopped trading in November, which would account for the significant difference between budgeted and actual sales in December and the trend continuing into January. Would this be OK to mention in my answer? Something like "Following the market exit of one of the competitors, sales increased overtaking budgeted sales numbers by a significant amount. It may be usuful to monitor for similar market changes in the future to react quickly and adjust stock levels when necessary in order to take advantage of the gap in the market. This should also be a factor in budgeting for incoming months, to ensure enough cards are produced, especially around card-centered holidays." Or would this be incorrect as I refer back to the scenario and not the graph only?

  • @LusiaEyre
    @LusiaEyre 16 วันที่ผ่านมา

    When you advise mentioning resigning if the issue is not addressed, can further whistle blowing or reporting the firm/s to external controllers be mentioned as well, or would that we seen as an 'overkill' by the examinator? My instinct would be to resign and tell someone that one company is faking their accounts and another let's them do it, but maybe that's not the escalation process included in the syllabus?

  • @LusiaEyre
    @LusiaEyre 16 วันที่ผ่านมา

    I only just started on this unit and I know it's only one mock (half of one actually) but I found this really easy. I genuinely was able to answer all the questions with the knowledge I have now and common sense... I don't know if it's good or bad, because I am now motivated to book my exam for this year, but I also understand that it can't be that easy, and I am bound to encounter stumbling blocks in the syllabus. Need to rain in the wild horses :) Off to see part 2!

    • @Willboardman
      @Willboardman 12 วันที่ผ่านมา

      Definitely doable before the end of the year! Not a huge unit by any means.

  • @leadacruz
    @leadacruz 16 วันที่ผ่านมา

    Hi, currently considering a career change. Do you have any recommended providers to use for the course? Also I am working full time at the moment, can AAT be studied part time only?

  • @mimiudo_
    @mimiudo_ 17 วันที่ผ่านมา

    I needed this video. Thank you so much

  • @nraja4131
    @nraja4131 18 วันที่ผ่านมา

    Hi. Thanks for the video. I live in London. I am 39 year old. Currently I am working in Restaurants as a chef. I need to work long hours for a decent wages! I would like to change my career to Accounting. I studied accounting in University level back home ages ago. I have decent knowledge in Accounting. Could you please advise me is it a good choice to Study AAT at this age? English is not my 1st language.

    • @Willboardman
      @Willboardman 18 วันที่ผ่านมา

      Absolutely yes, it’s completely possible to change career and move into accounting at that age!

  • @AmyDolan-m3y
    @AmyDolan-m3y 18 วันที่ผ่านมา

    what video do you recommend watching to try and get my head around the debit and credit principles as every time I think I have got it it all goes wrong again.

    • @Willboardman
      @Willboardman 18 วันที่ผ่านมา

      Have you watched my learning double entry in 5 minutes video?

  • @janetaddo4664
    @janetaddo4664 19 วันที่ผ่านมา

    Thank you for the explanation on each task.❤

  • @Tarunuknowbitch
    @Tarunuknowbitch 19 วันที่ผ่านมา

    PLEASE!! Do not stop making these level 2 videos thank you is there any way for me to get tutoring from you mate.

  • @yaeledmonds5158
    @yaeledmonds5158 19 วันที่ผ่านมา

    Hi Will, I worked through the mock exam and was completely thrown by a question about supply and demand graph. Does this mean S&D will be in the exam? Is there a video that summarises it?

    • @Willboardman
      @Willboardman 19 วันที่ผ่านมา

      Hi! Yes it is possible to get supply and demand within the exam :)!

    • @yaeledmonds5158
      @yaeledmonds5158 19 วันที่ผ่านมา

      @Willboardman ...but no video on it? Or is it in a video about other things?

    • @Willboardman
      @Willboardman 18 วันที่ผ่านมา

      I go through a couple within the mock walkthrough :)

  • @zarzeckak312
    @zarzeckak312 20 วันที่ผ่านมา

    Thank you, you explained it very well.

  • @sughrawalirehman9857
    @sughrawalirehman9857 21 วันที่ผ่านมา

    Hi dear your videos are very helpful could you please help me out I have done my Masters in finance from my home country alsy I recently completed MSc International Business from UK, now I got a 3 month contract job in a small company in uk I want to hunt the job as an Accounts Officer, bookkeeper but I am so confused which level I have to start can you suggest me the training providers details as well. Please please please I am eagerly waiting for your kind response

    • @Willboardman
      @Willboardman 18 วันที่ผ่านมา

      Hi! I would suggest given your prior studies to start on the level 3 qualification :)!

    • @tulsirupaliya26
      @tulsirupaliya26 12 วันที่ผ่านมา

      ​@@Willboardman hello thank you for this video. I completed my masters in account. Now I want to shift to UK pls suggest which one is best for me.please suggest which level is best for me?

  • @lee-wood
    @lee-wood 21 วันที่ผ่านมา

    Another great video, very helpful!

  • @lee-wood
    @lee-wood 21 วันที่ผ่านมา

    For task 4 question 1 - I knew the rates were calculated at 20 and 5 % - but how do I know that the error was the invoice and not "Jaz" entering the wrong vat rate? As far as I can tell theres no way to know which is intended to be correct for the question? It could equally be answerd as the invoice is correct and the rate used was 5% couldnt it?

  • @miroslavachovancova1397
    @miroslavachovancova1397 23 วันที่ผ่านมา

    You are amazing! Thank you. Going to take the PBOC exam in 2 hours 🫣

    • @Willboardman
      @Willboardman 22 วันที่ผ่านมา

      I hope it went well!

    • @miroslavachovancova1397
      @miroslavachovancova1397 17 วันที่ผ่านมา

      @@Willboardman passed it! Thank you :) Next one Principle of Costing. Hope I'll find some of your videos on here for this one too :)

  • @kanchantamang-s5q
    @kanchantamang-s5q 23 วันที่ผ่านมา

    Let’s see if I pass after watching this video

  • @kanchantamang-s5q
    @kanchantamang-s5q 23 วันที่ผ่านมา

    Let’s see if I pass after watching this video

  • @kanchantamang-s5q
    @kanchantamang-s5q 23 วันที่ผ่านมา

    Let’s see if I pass after watching this cideo

  • @nezha4775
    @nezha4775 24 วันที่ผ่านมา

    This guy saves me 4 times a year

  • @miroslavachovancova1397
    @miroslavachovancova1397 24 วันที่ผ่านมา

    Thank you! ❤

  • @JoanneChatt
    @JoanneChatt 24 วันที่ผ่านมา

    Very helpful, thank you😊

  • @Tarunuknowbitch
    @Tarunuknowbitch 25 วันที่ผ่านมา

    pls cover aat level 2 accounting course( im doing it in collage as well) btw are u from birmingham?

  • @aleemsabri123
    @aleemsabri123 25 วันที่ผ่านมา

    Let’s hope I pass I have my BESY exam for the FOURTH TIME!! I hope I pass this time.

  • @YosefCohen-o4v
    @YosefCohen-o4v 25 วันที่ผ่านมา

    Very helpful! Thank you. In task a)iii)b), I thought that we could not include the installations costs to the cost of the asset because it was done by an employee already receiving a salary.

    • @Willboardman
      @Willboardman 18 วันที่ผ่านมา

      You’re able to add installation because it’s still adding value to the asset. If part of the asset being usable includes professional installation then that in itself is part of the asset cost and therefore should be capitalised :).

  • @veselinakolovos8795
    @veselinakolovos8795 26 วันที่ผ่านมา

    Super helpful, Thank you. 🙂🙂🙂

  • @MichaelHepton
    @MichaelHepton 26 วันที่ผ่านมา

    The mock walkthrough's you do are always a huge help!! If you have not already are you posting a coverage of Mock 1 AMAC anytime soon?

    • @Willboardman
      @Willboardman 18 วันที่ผ่านมา

      I’d like to at some point but I don’t think it will be anytime soon!

  • @roslavington1859
    @roslavington1859 28 วันที่ผ่านมา

    thankyou, very helpful

  • @princessofproductivity
    @princessofproductivity 29 วันที่ผ่านมา

    you're so good at explaining, so clear!

  • @roshangurung3749
    @roshangurung3749 29 วันที่ผ่านมา

    Hi Will, love your videos! You made videos on accrued income, accrued expense and prepaid expense. I was wondering why there wasn't a video to show for recording prepaid income and i can't really find it anywhere else either.

    • @Willboardman
      @Willboardman 29 วันที่ผ่านมา

      Another one on the list to do :)!

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

    Thank you!