Getting Started with Microsoft Excel

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 taught. And also as a teacher, introducing such a basic concepts of MS Excel early in the year would help students become comfortable with digital tools and build a strong base before moving on to more advanced accounting tasks. With these excel skills students would be able to easily prepare and manage digital financial records, which would be a part of their skills set not just as a part of the knowledge.



Course Certificate Link: https://coursera.org/share/8f967adc6cf8d285bf164befd538386a


Comments

Post a Comment

Popular posts from this blog

Creating Financial Statements using Microsoft Excel

Image
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...
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