- 14
- 70 550
Linda Oulton
เข้าร่วมเมื่อ 26 ส.ค. 2013
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.
Thank you! Great help, I have been struggling to understand this for ages!
Thank you - have found this video very helpful after going blank on how to calculate margins and find missing figures
Excellent 👌
thank you very much. your explanation is straightforward and easy to follow. outstanding teacher.
You are my hero!
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 ?
Very useful 👌 thank you! I'm doing self-study and the books don't explain how to study for this practice software exam...
Very clear and helpful - thank you!
Thanks Linda :)
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?
The financial year will be stipulated in the exam paper. Just use the year it says.. which might not be the current year
@@lindaoulton7549 Thank you!
Really well explained.. CHEERS 👍👍
🙋 𝐩𝐫𝐨𝐦𝐨𝐬𝐦
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.
Thank you for this video! I got 96%!!!
Great result. Well done
Thank you Linda!!
I owe you one Linda, my training provider is useless! Thanks for the clear helpful video
You're welcome
Very helpful Linda. It makes a hell of a difference to be walked through the process. My kindly regards to you
Compare to practice and real exam so much different
if you put the wrong aat number when uploading the evidence. do you fail this exam.
That would be a question for the exam centre. I hope you told them as they can probably intervene
Great Video, many thanks.
Thank you thank you! The simple breakdown is exactly what I was struggling with ✌️
My exam is tomorrow. This video is very helpful. Thank you!
How similar was this test exam to the actual exam??
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.
Either delete it if possible or put an equal but opposite amount to cancel it out
Hello my dear with version of the software di you installed?
I did this video quite a while ago. It's the desktop version but I can't remember the version number
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 🙏
Thanks for your lovely comment. I'm glad I could be of use
thank you very much
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%.
So pleased to hear that
thank you it was very useful.
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...
Great news well done
Very helpful, thank you :)
That is absolutely what I wanted. Many thanks Linda.
Hi Linda, this is really helping with exam preparation, thanks for sharing the tips for the exam.
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
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 :)
It is very helpful. Thank you, Linda!
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
Alt + print screen .... grabs only active window, or use windows snipping tool
@@lindaoulton7549 Thank a lot Linda :) you have been so helpful
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! :-)
That's brilliant news. Well done
How similar was this test exam to real exam
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.
Glad you found it useful
thanks very much for this it was greatly appreciated.
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
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
Glad you found it helpful
Thank you Linda!
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
Good luck
You’re the best! Thank you very much.
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.
You're welcome. Glad it helped.
Thumb Up
HELLO VERY NICE
Your lectures very helpful for understanding overall chapter. Thanks for sharing.
Thank you very much for this video, it was really helpful and made me understand some things that I wasn't sure about before. :)
Is it level 2?