Creating Financial Statements using Microsoft Excel

The next course I chose was 'Create a Financial Statement Using Microsoft Excel' which provided me with practical experience in preparing financial statements. The course is a 2-hour guided project taught by Paula Del Rey and was delivered through step-by-step tutorial videos, which I followed side by side, and concluded with a quiz to test my understanding. I learned how to create a transactions page, generate a profit and loss statement, and develop a balance sheet using MS Excel Online which was a new experience for me as I always used the offline version. The online MS Excel is a great tool for companies to saved real time data and financial information.

I started by identifying assumptions for the statement and creating a transactions page. Then we used the SUMIFS formula to summarize the monthly transactions in the profit and loss statement. I learned how to complete both the Assets and Liabilities & Owner’s Equity sections of the balance sheet and perform a final balance check to ensure accuracy though it was a revision the formula to input was a new thing.

This course reinforced my understanding of Class XI's topic Financial Statements and Class XII's Financial Statements of a Limited Company. While we traditionally complete these steps manually, applying them through Excel made the entire process more efficient and less error-prone. It showed me how financial data can be presented professionally and consistently, aligning with the Bhutan Accounting Standards (BAS).

As a future teacher, I see the advantage of incorporating this course into practical sessions. Students will benefit from applying textbook knowledge to spreadsheet-based simulations. This not only improves their technical skills but also prepares them for work environments that demand digital fluency.




Course Certificate Link: https://coursera.org/share/f54b352fa55a4d82c2f816e82df88030

Comments

  1. Bhupen's JourneyJune 6, 2025 at 1:52 AM

    Marking criteria
    I. e-certificate: 10 marks
     Selection of the course : 5 marks (course to be relevant and engaging) 4
     Level of completion : 5 marks (enrolment 2 marks; partially completed 3- 9 marks, fully completed with certificate 10 marks) 5

    2. Blog reflection: 10 marks
     demonstrates the in depth understanding of the course 4 marks 3.5
     critical analysis of course connecting to accountancy practical’s in school 4 marks 3.5
     clarity of language and grammar 2 marks 1.5

    17.5/20

    ReplyDelete

Post a Comment

Popular posts from this blog

Getting Started with Microsoft Excel

Image
The first course I chose was "Getting Started with Microsoft Excel" which was of approximately 2 hours guided project course taught by Summer Scaggs. This course was a perfect foundation for understanding how to navigate and use MS Excel for simple data management. It included side-by-side tutorials and a final quiz that helped reinforce key concepts. I learned about the layout of Excel, how to use the ribbon, and some of the most important keyboard shortcuts which was somewhat like a revision as I knew some of it. The course also showed me how to format data, write basic formulas, and track information in a structured spreadsheet. The course objectives were fulfilled by creating basic formulas to analyze data, formatting cells, and designing simple spreadsheets for tracking purposes. I also became familiar with the basic view and features of MS 365 Excel. I found this course useful for building foundation to Class XI students if Excel topic was re-introduced and had to be ta...
Read more

Introduction to Business Analysis Using Spreadsheets: Basics

Image
The course  'Introduction to Business Analysis Using Spreadsheets: Basics'  introduced fundamental spreadsheet skills such as using  SUM, COUNTIF,  and  IF  functions, as well as organizing data and visualizing it through charts. The course is a 2-hour guided project course taught by Omnya Khaled, and it includes step-by-step video tutorials that enable me to learn by doing, and it concluded with a quiz to assess my understanding of the course. The course helped me understand the basics of spreadsheet software using Google Sheets and how to apply functions to perform mathematical operations, clean and manipulate data, and create visual presentations. I learned how to apply logical functions like IF, AND, OR, and aggregation functions like SUMIF and COUNTIF . I also learned how to clean data by deleting duplicates and splitting columns and most of activities were new to me, though simple but an essential skill and something to make my work easier while ...
Read more