2️⃣ Loan of 30,000 to be paid in 2 years (24 months) with 1% annual interest → calculated monthly payment. Why this matters This practice shows how Excel can simplify real-world finance by automating loan repayment schedules — useful for individuals, businesses, & institutions.

to determine fixed monthly payments based on loan amount, interest rate, and repayment period. * Applied the *PMT formula* *Scenarios tested:* 1️⃣ Loan of *20,000* to be paid in *10 years (120 months)* with *5% annual interest* → calculated monthly payment

🔍 *Day 2️⃣8️⃣ of #90DaysOfData: Loan Payment Calculator (Excel)* 💳📊 Today’s Excel practice focused on *Loan Payment Calculations* using my earlier formula knowledge along with the powerful *PMT function*. *What I built:* * Created an *automated loan payment calculator*

With Excel, all these calculations can be automated, accurate, and easy to visualize. \#Excel #Finance #InterestRate #Automation #DataJourney #Consistency #90DaysOfData #DeterminerEdu

* Compared *growth differences* between Simple vs Compound Interest across different time periods. *Why this matters* These formulas are not just for classrooms — businesses, investors, and even individuals use them for *loan repayments, savings plans, and investment projections

What I built: * Automated formula for Simple Interest = (Principal × Rate × Time) ÷ 100 * Automated formula for Amount A= (P + I) * Automated formula for Interest I= (A - P) * Flexible input fields for Principal, Rate, & Time so users can change values & instantly see results.

🔍 *Day 2️⃣7️⃣ of #90DaysOfData: Simple & Compound Interest (Excel)* 💹📊 Today’s practice was about Financial Calculations in Excel. Using my growing knowledge of some basic Arithmetic Operations, I designed a sheet to calculate both Simple Interest (SI) & Compound Interest (CI)

*Why this matters* This exercise connects *Data + Finance + Operations*, showing how simple formulas can automate HR tasks, reduce errors, and save time. #Excel #Finance #Payroll #Automation #HRAnalytics #DataJourney #Consistency #90DaysOfData #DeterminerEdu

* Applied formulas for accuracy, so changes to allowances or deductions instantly update results. * Filtered final list by *employees using OPAY Bank*. * Exported results showing *Employee Name, Account Number, and Net Salary* — ready for payroll submission to OPAY for payment.

* Salary breakdown with *Basic Salary, Housing (10%), Transport (5%), and Health (15%) allowances*, plus *Overtime*. * Automated calculation of: ✅ *Gross Salary* ✅ *Deductions* (lateness, offenses, etc.) ✅ *Employee Monthly Savings* ✅ *Net Salary*

🔍 *Day 2️⃣6️⃣ of #90DaysOfData: Automated Salary Calculator (Excel)* 💰📊 After searching for more practice datasets, I decided to build something practical for *DETERMINER EDU-CONSULT* — an *Automated Salary Calculation Sheet* for employees. *What I built*

On to refining analytics from the log (late vs on-time, weekly summaries, top punctual staff). 🚀 \#Excel #Automation #Attendance #DataEntry #90DaysOfData #DeterminerEdu #LearningInPublic #DataJourney #Consistency

* Kept a separate *Admin/Setup* area for employee lists and protected rules. *Why this matters* * Removes manual errors, speeds onboarding each morning, and creates *audit-ready* records. * A practical step from pure learning to *real operational value*.

* Used a *clean input table* with Data Validation (drop-down for employee names). * Auto-timestamp logic to capture *Date (`TODAY()`/`NOW()`)* at the moment of entry. * Applied *Sheet/Range Protection* so the formulas/code can’t be edited or manipulated by users.

* When an employee enters/selects their *name*, Excel *auto-generates the current date and time* of resumption. * Each entry is *time-stamped* and stored for tracking punctuality and attendance. *How I built it*

🔍 *Day 2️⃣5️⃣ of #90DaysOfData: Automated Clock-In Attendance (Excel)*⏱️📋 After days of searching for new datasets, I decided to *build a real solution*: an *automated clock-in attendance register* for a company. *What it does*

👉 I’ve reached out to my tutor for more *real-life data application projects*, and I’m hopeful that by *Day 25*, I’ll dive into fresh practical work. This pause reminds me that the journey is not just about consistency in posting, but about *gaining real, applicable skills*. 🚀

💡 However, in the last *2–3 days*, I’ve been in search of more datasets to deepen my practical skills. It hasn’t been easy getting the right data to work on, but that’s part of the data analyst’s journey — data is the fuel, and sometimes finding quality data is just challenging

🔍 *Day 2️⃣4️⃣ of #9️⃣0️⃣DaysOfData: Pause, Reflect, and Prepare for More* From *Day 1 to Day 23*, I have successfully completed: ✔️ Excel Basics ✔️ Intermediate Excel ✔️ Advanced Excel ✔️ Beginnings of Data Application projects

*Here is the link to the Google form: https://t.co/OPA26cBQmX* Data is not just numbers—it’s bridge between me and my audience. And with the right collection tools, we can build stronger, more impactful connections. #DataJourney #Consistency #GoogleForms #DataCollection