Linda Oulton
Linda Oulton
  • 14
  • 70 550
Creating reports
This is an explanation of how to create a handful of commonly used reports in Sage 50 Professional
มุมมอง: 77

วีดีโอ

Finding and removing duplicates in Excel
มุมมอง 622 ปีที่แล้ว
Finding and removing duplicates in Excel
Kaplan AVSY Study text book mock assessment 2.1
มุมมอง 1102 ปีที่แล้ว
NOTE: AVSY has now been superseded by ADSY where the Excel portion of the exam is separate from the Synoptic exam. I'm leaving this video here, however, for anyone who is interested see how the older (pre 2020) excel exam was completed.
Kaplan AQ16 AVSY Study text mock assessment 2.2 (pre 2021)
มุมมอง 1302 ปีที่แล้ว
NOTE: AVSY has now been superseded by ADSY where the Excel portion of the exam is separate from the Synoptic exam. I'm leaving this video here, however, for anyone who is interested see how the older (pre 2020) excel exam was completed.
AAT AQ16 AVSY Sample assessment pt 2 (pre 2021)
มุมมอง 892 ปีที่แล้ว
NOTE: AVSY has now been superseded by ADSY where the Excel portion of the exam is separate from the Synoptic exam. I'm leaving this video here, however, for anyone who is interested see how the older (pre 2020) excel exam was completed.
AAT AQ16 AVSY Practice assessment 2 part 2 ( important info in description)
มุมมอง 2652 ปีที่แล้ว
NOTE: AVSY has now been superseded by ADSY where the Excel portion of the exam is separate from the Synoptic exam. I'm leaving this video here, however, for anyone who is interested see how the older (pre 2020) excel exam was completed.
AAT AVSY Practice assessment 1 part 2 Excel Spreadsheets
มุมมอง 2.4K3 ปีที่แล้ว
2022 update : NOTE: AVSY has now been superseded by ADSY where the Excel portion of the exam is separate from the Synoptic exam. I'm leaving this video here, however, for anyone who is interested see how the older (pre 2021) excel exam was completed. This is a useful video for any student studying AAT Level 3 Spreadsheets module which is included as part of the synoptic. NOTE - this only applie...
Incomplete records - 1 Accounting equation (AAT Level 3 AQ16 FAPR or Q22 FAPS)
มุมมอง 3.4K3 ปีที่แล้ว
Designed for students studying accounting. How to use the accounting equation (net assets) to find missing figures when producing the accounts of a sole trader from incomplete records. (AAT AQ16 Final Accounts preparation FAPR or Q2022 Financial Accounting Preparing Financial statements FAPS) #AAT #FAPR #FinalAccountspreparation #Preparingfinancialstatements #incompleterecords #FAPS
Incomplete records 2 General ledger (control accounts) (AAT AQ16 FAPR or Q2022 FAPS)
มุมมอง 1.5K3 ปีที่แล้ว
Designed for students studying accounting. How to use control accounts to find missing figures when producing the accounts of a sole trader from incomplete records. (AAT AQ16 Final Accounts preparation FAPR or Q2022 Financial Accounting Preparing Financial statements FAPS) #AAT #FAPR #FinalAccountspreparation #Preparingfinancialstatements #incompleterecords #FAPS
Incomplete records 3 Cost Structure - mark up and margin (AAT L3 AQ16 FAPR or Q2022 FAPS)
มุมมอง 3.9K3 ปีที่แล้ว
Designed for students studying accounting. How to use cost structures (mark ups and margins) to find missing figures when producing the accounts of a sole trader from incomplete records. (AAT AQ16 Final Accounts preparation FAPR or Q2022 Financial Accounting Preparing Financial statements FAPS) #AAT #FAPR #FinalAccountspreparation #Preparingfinancialstatements #incompleterecords #FAPS
Using the AAT Lifelong Learning Portal
มุมมอง 2.1K3 ปีที่แล้ว
London South East Colleges tutor team present a video that explains how to use the new features of the AAT's website.
What If data tables in Excel
มุมมอง 1503 ปีที่แล้ว
An explanation of one and two way data tables in Excel
AAT Sample assessment UACS Graze Office Store - Sage 50 walk through.
มุมมอง 56K4 ปีที่แล้ว
AAT Using Accounting Software Practice assessment using Sage 50 Professional. This is a start to finish walk through of the paper although I do not enter addresses of customers or suppliers for speed (and because the paper doesn't require them).
What are journals?
มุมมอง 4764 ปีที่แล้ว
This video is useful for anyone beginning bookkeeping or accounting to understand the function of the journal in the accounting process. This video is suitable students studying AAT, IAB, ICB or any other qualification.

ความคิดเห็น

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

    Thank you! Great help, I have been struggling to understand this for ages!

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

    Thank you - have found this video very helpful after going blank on how to calculate margins and find missing figures

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

    Excellent 👌

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

    thank you very much. your explanation is straightforward and easy to follow. outstanding teacher.

  • @gemmarose1947
    @gemmarose1947 ปีที่แล้ว

    You are my hero!

  • @regularbloke7410
    @regularbloke7410 ปีที่แล้ว

    what confuses me is that on paper scenario we have no transactions on income or expense accounts but trial balance balances anyway. How is that possible ?

  • @RoboBobo18
    @RoboBobo18 ปีที่แล้ว

    Very useful 👌 thank you! I'm doing self-study and the books don't explain how to study for this practice software exam...

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

    Very clear and helpful - thank you!

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

    Thanks Linda :)

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

    Hi Linda , Thank you so much your video. It’s really helpful even though I will take a test on sage one. Just one thing I couldn’t figure out, do I have to record last year (2021) with financial year to start on 1 June current year?

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

      The financial year will be stipulated in the exam paper. Just use the year it says.. which might not be the current year

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

      @@lindaoulton7549 Thank you!

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

    Really well explained.. CHEERS 👍👍

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

    🙋 𝐩𝐫𝐨𝐦𝐨𝐬𝐦

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

    NOTE: This is for the old AVSY Excel task. This has now been superceded by ADSY so the Excel exam is separate to the synoptic exam.

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

    Thank you for this video! I got 96%!!!

  • @Vlad.A_PT
    @Vlad.A_PT 2 ปีที่แล้ว

    Thank you Linda!!

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

    I owe you one Linda, my training provider is useless! Thanks for the clear helpful video

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

    Very helpful Linda. It makes a hell of a difference to be walked through the process. My kindly regards to you

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

    Compare to practice and real exam so much different

  • @Mr-everything389
    @Mr-everything389 2 ปีที่แล้ว

    if you put the wrong aat number when uploading the evidence. do you fail this exam.

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

      That would be a question for the exam centre. I hope you told them as they can probably intervene

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

    Great Video, many thanks.

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

    Thank you thank you! The simple breakdown is exactly what I was struggling with ✌️

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

    My exam is tomorrow. This video is very helpful. Thank you!

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

      How similar was this test exam to the actual exam??

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

    Hi Linda, I have just started preparing for my sage, well explained and thanks for sharing. I am stuck at the supplier opening balance, I mistakenly put wrong amount in 1 of supplier balances. I tried to correct it but it got added up. Now I dont know how to fix this , if you can help that would be great.

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

      Either delete it if possible or put an equal but opposite amount to cancel it out

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

    Hello my dear with version of the software di you installed?

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

      I did this video quite a while ago. It's the desktop version but I can't remember the version number

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

    Thank you so much you are a life saver!!! I am sitting my FAPR exam in a few weeks and I was really struggling with this. I love your style of teaching. One of the best on TH-cam! Please do more videos 🙏

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

      Thanks for your lovely comment. I'm glad I could be of use

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

    thank you very much

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

    Hi Linda, this video helped me enormously to prepare me for the exam and I’m sure is the reason that I passed with 100%.

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

    thank you it was very useful.

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

    Thank you for this video! It gave me so much more confidence and clarity going into my exam; I got 98%!! Now just need help with the other four modules...

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

    Very helpful, thank you :)

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

    That is absolutely what I wanted. Many thanks Linda.

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

    Hi Linda, this is really helping with exam preparation, thanks for sharing the tips for the exam.

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

    THANK U SO MUCHH!! I was looking for how a previous teacher of mine had taught how to do this but i wasn't able to recall at all since it's been a while ): but this is the closest to that! and it really helped thank u so much

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

    Linda I low-key love you! Thank you so much for this gem of a video! Hopefully we'll pass the exam first time thanks to your help :)

  • @Amara.Bayarm
    @Amara.Bayarm 3 ปีที่แล้ว

    It is very helpful. Thank you, Linda!

  • @ThuyNguyen-yb5fg
    @ThuyNguyen-yb5fg 3 ปีที่แล้ว

    Thanks a lot, Linda for a well-explained UACS assessment. It helps me a lot with exam preparation. just a quick question how do you take a screenshot with only the task you are doing?. I did the screenshot and pasted it on word but it is the whole screen that doesn't look very neatly

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

      Alt + print screen .... grabs only active window, or use windows snipping tool

    • @ThuyNguyen-yb5fg
      @ThuyNguyen-yb5fg 3 ปีที่แล้ว

      @@lindaoulton7549 Thank a lot Linda :) you have been so helpful

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

    Just wanted to say a massive thank you for your help. I was really struggling with being able to get through everything in the exam in time, after applying your tips and trick in the exam I managed to pass first time with 100%!! Thank you so so much! :-)

  • @S.Kh57
    @S.Kh57 3 ปีที่แล้ว

    Linda,, I really learn from your tips in this video specially to fix 1 of financial year at first then change it in during filling the invoice. This works during the exam to have time for other questions. Thank you so much for your best explanation.

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

    thanks very much for this it was greatly appreciated.

  • @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. Looking forward to your reply. Thanks

  • @Amara.Bayarm
    @Amara.Bayarm 3 ปีที่แล้ว

    It is more understandable and useful than my one-year course, 400 page of online book, 2 time Sage 50, being bought and installed on my computer. Thank you very much x

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

    Thank you Linda!

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

    If only I'd watched your video before my exam last Tuesday. I ran out of time and couldn't upload anything 😪. After watching this video I'm redoing the test next week, thank you so much Linda

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

    You’re the best! Thank you very much.

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

    i had a mental block with this. Your simple explanation was just what i needed! thank you. I have subscribed. I am taking exam next week! final Accounts Prep. Thanks for posting this.

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

    Thumb Up

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

    HELLO VERY NICE

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

    Your lectures very helpful for understanding overall chapter. Thanks for sharing.

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

    Thank you very much for this video, it was really helpful and made me understand some things that I wasn't sure about before. :)

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

    Is it level 2?