ObenAY
ObenAY
  • Видео 55
  • Просмотров 441 165

Видео

Passive Income Tracker | Dividend Portfolio Tracker Live Data #passiveincome Part2
Просмотров 34Год назад
#investment #stockportfolio #excel #dividend #passiveincome Part1 Passive Income Tracker | Dividend Portfolio Tracker Live data - Portfolio Dashboard - Live Data pulling to table ( Annual Dividend, Ex-dividend date and Payment date
Passive Income Tracker | Dividend Portfolio Tracker Live Data #passiveincome Part1
Просмотров 137Год назад
#investment #stockportfolio #excel #dividend #passiveincome Part1 Passive Income Tracker | Dividend Portfolio Tracker Live data - Portfolio Dashboard - Live Data pulling to table ( Annual Dividend, Ex-dividend date and Payment date
ObenaAY's Boutique
Просмотров 2,2 тыс.3 года назад
obenaysboutique Rose Teddy Bears | ObenAy's Rose Teddy Bears #ObenAY'sBoutique
Some Excel Functions Everyone Should Know
Просмотров 1,9 тыс.4 года назад
Some Excel Functions Everyone Should Know - Splitting words from a cell into cells and from cells into a cell - Transforming into UPPER or LOWER case and PROPER - Adding Leading numbers - Make Data Sideways or Vertical - Flash Fill - Text to Columns
Best of British in Tenerife
Просмотров 2 тыс.4 года назад
Holiday experience 2020
Baklava - Home Made Turkish Pastry
Просмотров 1,8 тыс.4 года назад
Baklava - Home Made Turkish Pastry
How To Calculate Weekly Wages in Excel from Gross pay to Net Income UK
Просмотров 3,7 тыс.4 года назад
How To Calculate Weekly Wages in Excel using only IF function workout Income Tax and National Insurance Contribution (NIC) :) What is your Gross pay and what leftover Take home Download: mega.nz/file/ns5GVTqL#Llc9CutJOgxfvbmqdVl3Ux44KCeJaQVxicCCRiVla1w To get the PASSWORD, go to the video and get it from cell F8 (first 4 numbers ) do not take the decimal #excel #wages #incometax
How to Calculate National Insurance Contribution in Excel 2019-2020
Просмотров 6 тыс.4 года назад
How to Calculate National Insurance Contribution in Excel 2019-2020 with the rates 0% FIRST £166 12% £166.01 to £962 2% OVER £962
How to add QR Code in Excel
Просмотров 29 тыс.4 года назад
How to add QR Code in Excel
Orange cookies Christmas cookies with orange flavour
Просмотров 2,9 тыс.4 года назад
Orange cookies Christmas cookies with orange flavour
AAT Level 3 Synoptic Spreadsheet: Practice Assessment 1 Task 2.2
Просмотров 4,4 тыс.4 года назад
AAT Level 3 Synoptic Spreadsheet: Practice Assessment 1 Task 2.2
AAT Level 3 Synoptic Spreadsheet: Practice Assessment 1 Task 2.1
Просмотров 6 тыс.5 лет назад
AAT Level 3 Synoptic Spreadsheet: Practice Assessment 1 Task 2.1
Aion Legions of War: Summon Heroes - 38 x Shards, 3 x Light and Dark Shards, 2x Summonite Shards
Просмотров 4045 лет назад
Aion Legions of War: Summon Heroes - 38 x Shards, 3 x Light and Dark Shards, 2x Summonite Shards
Bonfire Night Fireworks Display 2019 Bonfire Night Guy Fawkes Night
Просмотров 18 тыс.5 лет назад
Bonfire Night Fireworks Display 2019 Bonfire Night Guy Fawkes Night
Aion Legions of War: Arena with Bloodfang Nora Blair Viper and Sacra against stronger team
Просмотров 1,1 тыс.5 лет назад
Aion Legions of War: Arena with Bloodfang Nora Blair Viper and Sacra against stronger team
The Duchess of Sutherland Historic Steam Train built in 1938
Просмотров 1,4 тыс.5 лет назад
The Duchess of Sutherland Historic Steam Train built in 1938
Aion Legions of War: Film Mode - using LEMAY to kill Dark Triroan
Просмотров 1,7 тыс.5 лет назад
Aion Legions of War: Film Mode - using LEMAY to kill Dark Triroan
Aion Legions of War: Film mode Gameplay
Просмотров 1,7 тыс.5 лет назад
Aion Legions of War: Film mode Gameplay
Aion Legions of War: ISHTAR
Просмотров 2 тыс.5 лет назад
Aion Legions of War: ISHTAR
AAT Level 2 Sample Assessment Using Accounting Software SAGE50
Просмотров 39 тыс.5 лет назад
AAT Level 2 Sample Assessment Using Accounting Software SAGE50
iPhone 11 & iPhone 11 Pro #subscribe
Просмотров 2 тыс.5 лет назад
iPhone 11 & iPhone 11 Pro #subscribe
AutoCAD Autodesk Basics #6
Просмотров 1,7 тыс.7 лет назад
AutoCAD Autodesk Basics #6
AutoCAD Autodesk Basics #9
Просмотров 1,7 тыс.7 лет назад
AutoCAD Autodesk Basics #9
AutoCAD Autodesk Basics #8
Просмотров 1,6 тыс.7 лет назад
AutoCAD Autodesk Basics #8
AutoCAD Autodesk Basics #7
Просмотров 7087 лет назад
AutoCAD Autodesk Basics #7
AutoCAD Autodesk Basics #5
Просмотров 6857 лет назад
AutoCAD Autodesk Basics #5
AutoCAD Autodesk Basics #4
Просмотров 5317 лет назад
AutoCAD Autodesk Basics #4
AutoCAD Autodesk Basics #3
Просмотров 4787 лет назад
AutoCAD Autodesk Basics #3
AutoCAD Autodesk Basics #2
Просмотров 4387 лет назад
AutoCAD Autodesk Basics #2

Комментарии

  • @SEBIsUNIVERSE
    @SEBIsUNIVERSE 4 месяца назад

    Special 🎁gift❤❤❤

  • @AhmedElsayed-fd6gr
    @AhmedElsayed-fd6gr 2 года назад

    Would I be able to practice for the exam sage 50 just by downloading sage 50 from their website and buy the material from Kaplan? Please advise.

    • @khssed4944
      @khssed4944 Год назад

      Yes I wanted to ask the same. I’m self studying and so confused if I should be using the online sage accounts or if I need the software on my desktop?

    • @AhmedElsayed-fd6gr
      @AhmedElsayed-fd6gr Год назад

      @@khssed4944 join the club, honestly I find this very stressful and no one have much knowledge about this particular part, u might get some information soon, I will let you know.

  • @chloedavis2297
    @chloedavis2297 2 года назад

    Why is there no sound?

  • @lakshmisaran2627
    @lakshmisaran2627 2 года назад

    Nice. ❤️ from Kerala, India.

  • @bhabesaguilad581
    @bhabesaguilad581 2 года назад

    Nice

  • @AliehsPJ
    @AliehsPJ 2 года назад

    Wow! Beautiful work of art!

  • @kimnamjoon6622
    @kimnamjoon6622 2 года назад

    Super..

  • @lakshmisaran2627
    @lakshmisaran2627 2 года назад

    Mr.Buttler 👍👍👍

  • @beluga1260
    @beluga1260 2 года назад

    Nice video 👍😊👍

  • @sergibf7038
    @sergibf7038 2 года назад

    Hello, how can I get your excel file to practise? Thanks!

  • @peaceful6210
    @peaceful6210 2 года назад

    Oh what happen to the sound. I can’t hear non. i can only see movements. Can you please fix the sound. Thanks

  • @thaimendoza8356
    @thaimendoza8356 2 года назад

    Hello how can i delete record in the opening balance. please

  • @warehouseclaims7627
    @warehouseclaims7627 3 года назад

    THANK YOU

  • @tommyharris5817
    @tommyharris5817 3 года назад

    get rid of the stupid robot voice

  • @danielle5620
    @danielle5620 3 года назад

    Would help more if it had sound

  • @amashayekhi5712
    @amashayekhi5712 3 года назад

    Could you please answer aat l3 spreadsheet plz

  • @juliamalcolm7673
    @juliamalcolm7673 3 года назад

    Revising for my last exam (Sage 50) in level 2 but I'm a little confuse with this question. Question: "Enter the following Wages summary journal." Gross Wages: £13068.52 PAYE - Income Tax: £2612.25 Employees National Insurance: £1437.53 Net Wages: £9018.74 Employers National Insurance: £1672.77 When I Debit the Gross Wages (£13068.52) & Employers National Insurance (£1672.77) and Credit the PAYE (£2612.25), National Insurance (£1437.53) & Net Wages (£9018.74) the journal did not balances. Believe this is because of the Employer's National Insurance making it unbalance. Please if you could kindly explain how I should enter the wages in journal entry.

    • @masoodchaudhari2555
      @masoodchaudhari2555 3 года назад

      7000 - Wages DR 14,741.20 (Total Wages Expense) 2210 - PAYE to pay to HMRC CR 2,612.25 2220 - NIC to pay to HMRC CR 3,110.30 2250 - Net Wages CR 9,018.65 To record the wages journal in Sage

    • @juliamalcolm7673
      @juliamalcolm7673 3 года назад

      @@masoodchaudhari2555 Thank you for replying. You forgotten the Employers National Insurance and don't believe we are able to change the figures. I used a suspense account to make the journal balance.

  • @johnbarr1404
    @johnbarr1404 3 года назад

    After closing 8 months ago due to the pandemic, it’s great news that Harriet’s is to re-open tomorrow morning August 16th 09:30 till 16:30

  • @lustforlife247
    @lustforlife247 3 года назад

    Useless! Where’s the audio?!?!

  • @gracejoymorphew6610
    @gracejoymorphew6610 3 года назад

    Hi, Is there meant to be sound?

  • @lynxo5695
    @lynxo5695 3 года назад

    Thank you very much for this. Very helpful.

  • @bridgetbarrett6008
    @bridgetbarrett6008 3 года назад

    Have saved this video and will practice exactly as she has done it. Its the last one to pass now on L2. Then am done more confident from watching this there were a few things I was doing wrong but know that they are now and am getting tech savvy with this software lols so thanks

  • @teclasicbaldi
    @teclasicbaldi 3 года назад

    do you have any intention to upload the assessments for AAT level 3 advanced bookkeeping? the level 2 was very well done

  • @tiyoungyati9075
    @tiyoungyati9075 3 года назад

    Thank you so much for this

  • @imurprisoner1
    @imurprisoner1 3 года назад

    is it meant with no sound? cant hear anything

  • @anxious-_-panda
    @anxious-_-panda 4 года назад

    I'm still confused with the reports. Have you got a video on the reports and where to upload them?

    • @teamine
      @teamine 4 года назад

      Hi Sophie, Yes you have to upload when you sit the live assessment. There is no video for it.

    • @anxious-_-panda
      @anxious-_-panda 4 года назад

      @@teamine No I haven’t, but I’ve spoken to my tutor and I understand them now. I have my business comms tomorrow though :)

    • @anxious-_-panda
      @anxious-_-panda 4 года назад

      @@teamine thank you for your comment though

  • @ajp1690
    @ajp1690 4 года назад

    Can you please paste the long IF function formula for IT and NI tax? :-D

  • @MrNicky2496
    @MrNicky2496 4 года назад

    Hi the link for the download doesn't work. Great video though.

    • @ObenAY
      @ObenAY 4 года назад

      Hi, I've just added a new link sorry about that thank you

    • @markwillis6106
      @markwillis6106 3 года назад

      @@ObenAY Ive downloaded but cant access?

  • @marianawoolencraft786
    @marianawoolencraft786 4 года назад

    You are great teacher i passed my exam due to this video.i got confidence now. Thanks for sharing.

  • @oliverosemadzura2638
    @oliverosemadzura2638 4 года назад

    iOS iOS devices iOS ft. Forget - you learn how to learn the business

  • @oliverosemadzura2638
    @oliverosemadzura2638 4 года назад

    Forget - get your business official video

  • @zismail6309
    @zismail6309 4 года назад

    this is really helpful ,great solution .thank you so much but it will be much better with audio xxx

  • @denismustafov1599
    @denismustafov1599 4 года назад

    Very nicee!

  • @sandywatson9271
    @sandywatson9271 4 года назад

    It's cool everyone

    • @Johnsonuher
      @Johnsonuher 4 года назад

      yes it is theres annother one on the 6th november hope to meet you there

  • @katrinasalindong2967
    @katrinasalindong2967 4 года назад

    hi there, may i ask if its okay to delete transactions during the exam (just in case i have encoded something mistakenly) or will there be a deduction on your score everytime you delete a transaction?

    • @joshmorgan-kane4078
      @joshmorgan-kane4078 4 года назад

      I've been told its fine to delete them. 🤞 I got the right advice

  • @AmjadALI-db6et
    @AmjadALI-db6et 4 года назад

    Very helpful. Thank you very much 👌

  • @axelblah41
    @axelblah41 4 года назад

    Hi. When I tried this assessment my bank reconciliation was out by 14.00 even when I entered the bank charges. I noticed your bank account amount before reconciliation was 21378.79 but mine was 21364.79. Any ideas where I could be going wrong? All my numbers I put in are correct.

    • @alessiocollyer4471
      @alessiocollyer4471 4 года назад

      Did you do a transaction the wrong way round?

    • @axelblah41
      @axelblah41 4 года назад

      @@alessiocollyer4471 Nope. I checked everything. I checked if I applied the correct tax code as well. Everything is exactly as in the video.

  • @airJohn123
    @airJohn123 4 года назад

    How can download just for practice

  • @vladimirkraus2678
    @vladimirkraus2678 4 года назад

    I LOVE YOU!! im doing the test tomorrow and you just helped me with couple of things i was missing!

    • @katrinasalindong2967
      @katrinasalindong2967 4 года назад

      hi there, may i ask if its okay to delete transactions during the exam (just in case i have encoded something mistakenly) or will there be a deduction on your score everytime you delete a transaction?

  • @rahulpanse4692
    @rahulpanse4692 4 года назад

    Where is the sound in here? what happened?

  • @rahulpanse4692
    @rahulpanse4692 4 года назад

    Sound????

  • @ulitalamontagne315
    @ulitalamontagne315 4 года назад

    Tasks 6b - Net pay of wages should be posted to nominal code: 2220 (Net wages) as seen in the chart of accounts Sage 50. Nominal code: 7000 is for Gross wages this is an expense account incurred cost to the company.

    • @EGRJ
      @EGRJ 3 года назад

      How can you tell the difference?

    • @ras105
      @ras105 2 года назад

      @@EGRJ anything 5000+ is outgoing

  • @teclasicbaldi
    @teclasicbaldi 4 года назад

    17:01 task 5 22:07 task 7 _____ 23:18 visual task 7 24:33 task 8 _____ 25:31 task 9

  • @itsnamo361
    @itsnamo361 4 года назад

    Great video

  • @richardbalogh2433
    @richardbalogh2433 4 года назад

    How do you enter the bank charges in the Trial Balance ?

  • @GOSSIP911
    @GOSSIP911 4 года назад

    What year is that software ??

    • @ObenAY
      @ObenAY 4 года назад

      I’ve done this exam in 2018 same software version then decided to make a video with same version as in exam. I hope in 2020 will be the same mostly

  • @amitrana5595
    @amitrana5595 4 года назад

    how to create qr code through vba excel

  • @بنأعمرأمين
    @بنأعمرأمين 4 года назад

    office 2007 exel trouve pac utillitair

  • @PaperFolder_
    @PaperFolder_ 4 года назад

    In the exam will you get the exam paper as a printout or will it be on a word document?

    • @teclasicbaldi
      @teclasicbaldi 4 года назад

      it'll be on aat icon and you will have to open also sage50 and work on two windows at the same time

  • @RandomChessTalk
    @RandomChessTalk 4 года назад

    Thank you for this video. I have one question please, so I tried to do everything you did with the queen, but when I select on mine 11 small cylinders to make a crown, it says 1 object found instead od 11, and when I press enter nothing happens, it says No solid, surfaces, or regions selected. What should I do please help man