Official TechTrain Academy Facebook account.
We help individuals drive their businesses through the use of data
We advocate the use of open source tools for data science such as R, Python, QGIS, DHIS2 and ODK
Email: [email protected]
Phone#1: +255 714 620 265
Phone#2: +255 743 496 966 We train and consult in everything data including Programming, Machine Learning, Business Intelligence, GIS, Management Information Systems and many mor
02/08/2025
🇹🇿👍🫶👌I posted the solution below (click / copy and paste the link) to the Power Query challenge 309 posted by Excel (Vijay A. Verma) BI.
https://www.linkedin.com/feed/update/urn:li:activity:7357258963681193984?commentUrn=urn%3Ali%3Acomment%3A%28activity%3A7357258963681193984%2C7357283386173861888%29&dashCommentUrn=urn%3Ali%3Afsd_comment%3A%287357283386173861888%2Curn%3Ali%3Aactivity%3A7357258963681193984%29
26/07/2025
My MVP status was renewed by Microsoft for the second year in a row on July 10, 2025 👌✍️🫶🇹🇿
28/03/2025
Jifunze namna ya kutumia LOOKUP function kutafuta grade ukipewa marks za somo husika. Angalia kupitia YouTube link hapo chini
https://youtu.be/Fz55whM2RUM
Usikose ku subscribe YouTube channel yetu ya TechTrain Academy
LOOKUP function for Approximate Match Lookup Jifunze jinsi ya kutumia LOOKUP function kwenye Microsoft Excel kutafuta grade ikiwa umepewa marks za somo husika. Kwenye video hii tumeonesha namna zote mbi...
27/03/2025
Jifunze namna ya kutumia LOOKUP function kutafuta grade ukipewa marks za somo husika. Angalia kupitia YouTube link hapo chini
https://youtu.be/Fz55whM2RUM
Usikose ku subscribe YouTube channel yetu ya TechTrain Academy
01/10/2024
💹 My three solutions to Excel BI's Excel challenge 555.
Excel Formula, Power Query and Python in Excel 🐍
Excel Formula: 📉 📊 💹
=DROP(REDUCE("",A2:A19,LAMBDA(x,y,LET(a,A1:E1,b,OFFSET(y,,,,5),c,MAP(a,b,LAMBDA(u,v,IF(v="","",u))),VSTACK(x,SORTBY(c,b,IF(MOD(ROW(y),2),-1,1)))))),1)
Challenge Link: https://lnkd.in/daCHxJ-h
29/08/2024
💹Python in Excel solution to Excel BI's Excel challenge 531🐍
Challenge Link: https://lnkd.in/duQEs-bd
25/08/2024
💹Cleaning up messy data with Power Query and Python in Excel 🐍
My two solutions to Excel BI's Power Query challenge 211
Challenge Link: https://lnkd.in/dzXsYcsv
GitHub Link: https://lnkd.in/dmhWYVW9
19/08/2024
🚀 Unlock Your Data Potential with TechTrain Academy's Advanced Data Analytics Courses! 🚀
Join our Advanced Excel Part 2: Excel Automation and Big Data Analytics course, led by a Microsoft MVP and certified Microsoft Office Specialist with over 10 years of experience in data analytics!
📊 What You'll Learn:
- Master dynamic arrays and lambda functions
- Manage data with Power Query
- Advanced data manipulation using M code
- Data modeling with Power Pivot
- Create stunning visualizations
- Automate tasks with Macros and Python
📅 Limited spots available! Don’t miss out on this opportunity to elevate your Excel skills to the next level!
👉 Contact us! +255 714 620 265
18/08/2024
You can use Power Query to clean messy data. In this post, I'm attaching images showing a Power Query's data mashup (M) code chunck for cleaning the a data and how the final solution looks like after cleaning together with the original data.
13/08/2024
Linear interpolation using 🐍 Python in Excel (Easy, single line 🤔)
Challenge Link: https://lnkd.in/dB3qK627
GitHub Solution Link: https://lnkd.in/dycdMx6Y
09/08/2024
I used the power of itertools to simplify my code. Making the code cleaner and run faster. Python in Excel has made all these packages available in Excel so you can run your codes without requiring any installation of these packages.
Original Excel BI's post: https://lnkd.in/d2cFbsts
My comment: https://lnkd.in/dwYFKkGd
23/07/2024
Unakosaje hii?