top of page
This site was designed with the
.com
website builder. Create your website today.
Start Now
About
Articles
Blog
Contact
More
Use tab to navigate through the menu items.
Subscribe to my blog
Submit
Thanks for submitting!
All Posts
Excel
Google Sheets
Analytics
Productivity
Microsoft Office
Public Health
Life
Search
Shem Opolot
Jun 27, 2022
2 min read
The right way to number your lists
Shem Opolot
May 17, 2022
1 min read
Calculate your simple loan payments
Shem Opolot
Mar 28, 2022
2 min read
Top 3 time-saving techniques in Excel
Shem Opolot
Mar 21, 2022
3 min read
VLOOKUP: in depth
Shem Opolot
Mar 14, 2022
3 min read
VLOOKUP and the IF function
Shem Opolot
Mar 7, 2022
2 min read
Spreadsheets for planning a movie night
Shem Opolot
Feb 14, 2022
4 min read
Real work problems: Custom formatting for better reports
Shem Opolot
Feb 7, 2022
5 min read
Real work problems: Get more from your surveys
Shem Opolot
Jan 17, 2022
4 min read
6 features you should use in Google Sheets
Shem Opolot
Dec 20, 2021
4 min read
Sending personalized bulk emails for free
Shem Opolot
Nov 22, 2021
4 min read
Building a Yearly Calendar III
Shem Opolot
Nov 15, 2021
2 min read
Building a Dynamic Calendar II: Let's go on DATES
Shem Opolot
Nov 8, 2021
2 min read
Build a Dynamic Calendar: Part 1
Shem Opolot
Nov 1, 2021
3 min read
Can you do a split?
Shem Opolot
Oct 11, 2021
4 min read
Excel for criminals
Shem Opolot
Sep 27, 2021
3 min read
Understand the ampersand (&)
Shem Opolot
Sep 20, 2021
3 min read
Heat maps with conditional formatting
Shem Opolot
Sep 6, 2021
6 min read
Checklists and Conditional formatting for task management
bottom of page