Customize Consent Preferences

Privacy Policy
Last Updated On 09-Aug-2023
Effective Date 01-Aug-2023

This Privacy Policy describes the policies of Shem Opolot, email: info@shemopolot.com, phone: 0772100100 on the collection, use and disclosure of your information that we collect when you use our website ( https://shemopolot.com ). (the “Service”). By accessing or using the Service, you are consenting to the collection, use and disclosure of your information in accordance with this Privacy Policy. If you do not consent to the same, please do not access or use the Service.
We may modify this Privacy Policy at any time without any prior notice to you and will post the revised Privacy Policy on the Service. The revised Policy will be effective 180 days from when the revised Policy is posted in the Service and your continued access or use of the Service after such time will constitute your acceptance of the revised Privacy Policy. We therefore recommend that you periodically review this page.

Information We Collect:
We will collect and process the following personal information about you:

Name
Email
Mobile

How We Use Your Information:
We will use the information that we collect about you for the following purposes:

Testimonials
Customer feedback collection
Processing payment
Support
Manage customer order
Manage user account
If we want to use your information for any other purpose, we will ask you for consent and will use your information only on receiving your consent and then, only for the purpose(s) for which grant consent unless we are required to do otherwise by law.

Retention Of Your Information:
We will retain your personal information with us for 90 days to 2 years after user accounts remain idle or for as long as we need it to fulfill the purposes for which it was collected as detailed in this Privacy Policy. We may need to retain certain information for longer periods such as record-keeping / reporting in accordance with applicable law or for other legitimate reasons like enforcement of legal rights, fraud prevention, etc. Residual anonymous information and aggregate information, neither of which identifies you (directly or indirectly), may be stored indefinitely.

Your Rights:
Depending on the law that applies, you may have a right to access and rectify or erase your personal data or receive a copy of your personal data, restrict or object to the active processing of your data, ask us to share (port) your personal information to another entity, withdraw any consent you provided to us to process your data, a right to lodge a complaint with a statutory authority and such other rights as may be relevant under applicable laws. To exercise these rights, you can write to us at info@shemopolot.com. We will respond to your request in accordance with applicable law.
You may opt-out of direct marketing communications or the profiling we carry out for marketing purposes by writing to us at info@shemopolot.com.
Do note that if you do not allow us to collect or process the required personal information or withdraw the consent to process the same for the required purposes, you may not be able to access or use the services for which your information was sought.

Cookies Etc.
To learn more about how we use these and your choices in relation to these tracking technologies, please refer to our Cookie Policy.

Security:
The security of your information is important to us and we will use reasonable security measures to prevent the loss, misuse or unauthorized alteration of your information under our control. However, given the inherent risks, we cannot guarantee absolute security and consequently, we cannot ensure or warrant the security of any information you transmit to us and you do so at your own risk.

Grievance / Data Protection Officer:
If you have any queries or concerns about the processing of your information that is available with us, you may email our Grievance Officer at Shem Opolot, 256 Kampala, Uganda, email: info@shemopolot.com. We will address your concerns in accordance with applicable law.

Always Active

Necessary cookies are required to enable the basic features of this site, such as providing secure log-in or adjusting your consent preferences. These cookies do not store any personally identifiable data.

No cookies to display.

Functional cookies help perform certain functionalities like sharing the content of the website on social media platforms, collecting feedback, and other third-party features.

No cookies to display.

Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics such as the number of visitors, bounce rate, traffic source, etc.

No cookies to display.

Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.

No cookies to display.

Advertisement cookies are used to provide visitors with customized advertisements based on the pages you visited previously and to analyze the effectiveness of the ad campaigns.

No cookies to display.

Top 3 time-saving techniques in Excel

Hi! In this week’s YouTube video, I talk about leveraging Excel for your money management. In the process, I touched on the Jewish Star principles I learned from my uncle over 6 years ago. The Jewish star principles state that for every monetary increase you get, at the minimum, you should tithe (10%), save (10%), invest (20%), offer (10%) and spend (50%). Obviously, this rule may not be applicable if you live from hand-to-mouth but if it makes sense for you, then I highly recommend it.

Also, I used Google Sheets in the video, but this post will be useful for you to replicate the budget in Excel.

Here is this week’s full video:

Because the technical aspects of the video, are concepts I have touched on before, this week I want to share 3 time-saving techniques in Excel that will save you loads of time.

Format Paint

When you format the contents of a cell in a specific way, by bolding the characters or adding a colour fill, you may want to repeat this action for multiple cells. Instead of repeating the process organically, the Format Paint feature in Excel will replicate your formatting over your desired range. Simply click inside the cell with the desired formatting, click Format Paint then select the area you want to format.

Autofit columns and rows

Ever encountered an Excel sheet that looks like an unmade bed? Columns and rows unevenly displayed, making it impossible to read their contents? I’d share an example of such a dataset, but I could not bear it. After selecting all the data in the sheet with CTRL + A, the shortcuts ALT + H-O-A and ALT + H-O-I will autofit the rows and columns to your data respectively.

Flash Fill

If you want to extract the first names from a list of full names, instead of using a complex formula such as LEFT—or worse, doing it manually—simply enter the first name to be extracted from the first full name in the list and Excel will intuitively do the same for the rest. All you will have to do is click ENTER to confirm Excel’s clayorvoyance. And if in the off chance Excel has taken leave of working miracles, go to Data and manually select Flash Fill after extracting the first name from the first full name

Conclusion

There are several time-saving techniques in Excel, such as Pivot tables, Power Query, and so on, but these 3 are fundamental for every user’s experience.

Have a great week!