fbpx
Madonna House, Westlands Road - Nairobi
+254790706395
info@opencastlabs.co.ke

Free Excel Tips, Templates, Videos and Tutorials

Uncategorized

Analyzing Data with Pivot Tables Module Dataset

Read More
Uncategorized

Grouping Sales Data by Period

https://youtu.be/rcTXmtHrUjQ Download Class FileHow to group sales data by period
Read More
Download Loan Amortisation Schedule
Templates

Download Loan Amortisation Schedule

Enter your rate, principal, number it payments and # of years and you have your amortisation with reducing balance
Read More
How to crack an Excel Password using VBA
Macros & VBA

How to crack an Excel Password using VBA

You have developed or downloaded this nice spreadsheet template or mode but has a sheet level password (a password is...
Read More
Balanced Score Card (BSC) Template
Templates

Balanced Score Card (BSC) Template

The Balanced Scorecard, referred to as the BSC, is a framework to implement and manage strategy. It links a vision to strategic objectives, measures, targets, and initiatives. It balances financial measures with performance measures and objectives related to all other parts of the organisation. It is a business performance management tool.
Read More
Financial Modeling Templates

2 Bedroom Apartment Units Financial Model

This model consists of the following tables Input SheetFinancial ModelAssumptionsCAPEXModel Payback Disclaimer: This Model is for learning purposes. The numbers...
Read More
Uncategorized

Formulas and Functions Dictionary

Here is a Microsoft Excel Functions workbook with over 100 commonly used functions you can download. We have outlined the...
Read More
The future of Microsoft Technology Associate (MTA) certifications
Microsoft Certification

The future of Microsoft Technology Associate (MTA) certifications

Adapted from Microsoft Tech Community Page While the responsibilities of IT professionals have become increasingly complex, the importance of having...
Read More
Camtasia Review – The Go-To Software to Create Video Tutorials and Courses
E-Learning

Camtasia Review – The Go-To Software to Create Video Tutorials and Courses

If you are looking to create online courses or tutorials as part of your business model, then you are going...
Read More
Download Periodic Table Template
Uncategorized

Download Periodic Table Template

The periodic table, also known as the periodic table of elements, is a tabular display of the chemical elements, which...
Read More
1 2 3 7