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

Month: March 2021

How to change text cases in Microsoft Excel

Unlike Microsoft Word, Microsoft Excel doesn’t have a Change Case button for changing capitalization. However, you can use the UPPER, LOWER, or PROPER functions to automatically change the case of existing text to uppercase, lowercase, or proper case. Functions are just built-in formulas that are designed to accomplish specific tasks—in this case, converting text case.…
Read more

Fetching Live Data from Kobo using Power Query

Power Query for Excel allows you to fetch/pull your Live Data from Kobo Data Collection database (submissions). Use the power of Power Query to Extract, Transform and Load your data to Excel

Dynamics 365 Business Central Adoption Guide

The most successful companies are already reaping the rewards of digital transformation. Digital transformation enables organizations to attract the best talent, empower employees, and deliver innovative products and services all with streamlined operations—centered around exceptional customer experiences.

Business Owners Guide to Replacing Accounting Software

Replacing your accounting software is easier and more affordable than you may think. Use this guide to learn about the benefits of a modern technology platform, better understand the advantages of a cloud-based solution, and know what questions to ask when evaluating your options. Why choose Microsoft Dynamics 365 to run your business? Microsoft Dynamics…
Read more