Ultimate Excel Course – Lecture # 1 | Overview of Excel Hi guys welcome to the first lecture in this course. It is suitable for those of you who are beginners in Excel. This lesson will teach you about Excel’s structure, Ribbon and Excel Tabs, Work-Book and Work-Sheets of excel. For those of you who already know these basic concepts feel free to …
Read More »Tag Archives: LEARNERS-POINT
Learn Ultimate Excel Course with Practice Exercises
Learn Ultimate Excel Course with Practice Exercises Excel is a powerful spreadsheet now a days. In modern days, almost every business use it and it’s very rare, if it is not used by someone in daily basis for their routine office work. Lecture No. 1 : Overview of Excel Lecture no. # 2 BASIC EXCEL DATA & FORMATTING LECTURE # 3 BASICS OF …
Read More »Bank Reconciliation Statement Problems and Solutions
Bank Reconciliation Statement Problems and Solutions Problem # 1: From the following information, extract a bank reconciliation statement as on 31st Decembar, 2008 1. The balance as per Cash book on 31-12.2008 Rs.12000/- 2. Cheques issued but not presented in the bank Rs.1600/- 3. Cheques paid into bank but not cleared before 31st Dec,08 Rs.2000/- 4. Interest …
Read More »Learn Quick-Books Pro 2018 – Lecture # 3: How to Download and Install Quick-Books Pro
Learn Quick-Books Pro 2018 – Lecture # 2: INTRODUCTION Learn Quick-books Pro 2018 Lecture # 3: Download & Install QuickBooks Pro Please wait a little bit to Load In this lecture you will learn about Why the need of Quick-books or any other accounting software. Watch Next Lecture: Lecture # 4: Quick-Books and Accounting Might You Like Followings Hope you like …
Read More »Learn Quick-Books Pro 2018 – Lecture # 2: INTRODUCTION
Learn Quick-Books Pro 2018 – Lecture # 2: INTRODUCTION Learn Quick-books Pro 2018 Lecture 2- Introduction Please wait a little bit to Load In this lecture you will learn about Why the need of Quick-books or any other accounting software. Watch Next Lectures: Lecture # 3: How to Download and Install Quick-Books Pro 2018 Lecture # 4: Quick-Books and Accounting Might …
Read More »Banking Transactions Short Questions with Answers
BANKING TRANSACTIONS Q.1 WHAT IS BANK.? Ans. Bank is a financial institution which deals in money. It takes money from those people who have spare it on low rate of interest and lends to the needy people at a high rate of interest. This difference of rate of interest its income. Q. 2 WRITE THE KINDS OF BANK …
Read More »Single Column Cash Book Problems and Solutions
Problem .No.1 Write up a single column Cash book from the following transactions: 2000 May-1 Cash in hand Rs.2000/- 2 Purchased merchandise for Cash 200/- 3 Paid carriage …
Read More »Journal, Ledger and Trial Balance Problems and Solutions
Journal, Ledger and Trial Balance Problems and Solutions Problem-1 Record the following transactions in General Journal and post them into ledger. March.1 Anwar invested Rs.60000/- in the business. 8 Bought furniture Rs.5000/- on credit. 10. Purchased Supplies for Rs.1000/- 18. Purchased Equipment Rs.1700/- 25. Invested additional cash into …
Read More »Journal Entry Problems and Solutions
Journal Entry Problems and Solutions Problem-1 Record the following transaction into General Journal during the month of January, 2008. Jan. 1 Mr. Khubaib invested Rs.100,000 into the business. 2 Purchased Land for Cash Rs.52000. 4. Purchased Building Rs.36000, paid Rs.6,000 and issued note for the remaining 8. Purchased equipment on credit Rs.13,800. 15 Sold a part …
Read More »Accounting Equation Problems and Solutions
Accounting Equation Problems and Solutions Problem No.1 Show the effect of the following transactions on assets, owner’s equity and Liabilities: 1. Mr. Sultan invested cash into business Rs.30000/- 2. Bought Supplies for Cash Rs. 500/- 3. Purchased Furniture on account Rs.1000/- 4. Paid Salaries Rs.200 5. Earned Rs.2000/- by performing services to the clients. 6. Paid Rent of …
Read More »