Chain Research Organisation and Consultancy - CROC

12/05/2026

"Discover Your Best Self by Embracing Learning." Join our Online Free Courses for May 2026 intake by Chain Research Organization and Consultancy.

Elevate your skills, boost your career, and make 2026 your year of growth! 🌐💡 Hurry, join the group using the link now and seize the opportunity to gain valuable insights. Knowledge is the key to success! 🎓🔗

Join the WhatsApp group using the link below
Group: https://chat.whatsapp.com/KDDEnEy2UgMISK2Yzam3qt

Like our page at
Chain Research Organisation and Consultancy - CROC

14/04/2026

𝐖𝐞𝐛𝐢𝐧𝐚𝐫 𝐀𝐧𝐧𝐨𝐮𝐧𝐜𝐞𝐦𝐞𝐧𝐭: 𝐆𝐫𝐚𝐧𝐭 𝐏𝐫𝐨𝐩𝐨𝐬𝐚𝐥 𝐖𝐫𝐢𝐭𝐢𝐧𝐠 𝐟𝐨𝐫 𝐍𝐆𝐎𝐬

Access to funding remains one of the biggest challenges for organizations, startups, and individuals. At Chain Research Organization and Consultancy (CROC), we are committed to building capacity in proposal development and grant acquisition.

Join our upcoming webinar where we will cover:

-Key components of a winning proposal
-How to identify and approach funding opportunities
-Practical strategies to improve grant success rates
-Common pitfalls in proposal writing

This session is ideal for professionals in NGOs, the private sector, government, and students interested in securing funding for impactful projects.

📅 Date: 15th April 2026
⏰ Time: 19:00 - 20:30
📍 Location: Online

🔗 Register here: https://forms.gle/CEhFpFR8Ffm8eNiC9

𝙆𝙞𝙣𝙙𝙡𝙮 𝙣𝙤𝙩𝙚 𝙩𝙝𝙖𝙩 𝙧𝙚𝙜𝙞𝙨𝙩𝙧𝙖𝙩𝙞𝙤𝙣 𝙞𝙨 𝙧𝙚𝙦𝙪𝙞𝙧𝙚𝙙. 𝙒𝙚𝙗𝙞𝙣𝙖𝙧 𝙖𝙘𝙘𝙚𝙨𝙨 𝙙𝙚𝙩𝙖𝙞𝙡𝙨 𝙬𝙞𝙡𝙡 𝙗𝙚 𝙨𝙝𝙖𝙧𝙚𝙙 𝙪𝙥𝙤𝙣 𝙘𝙤𝙣𝙛𝙞𝙧𝙢𝙖𝙩𝙞𝙤𝙣.

13/04/2026

𝐄𝐱𝐜𝐞𝐥 𝐓𝐢𝐩: 𝐒𝐔𝐌𝐈𝐅 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧

Need to calculate totals for a specific category in Excel?

Use SUMIF.

Example:

You have phone sales data for:

iPhone
Samsung
Tecno

Formula:
=SUMIF(B2:B10,"iPhone",C2:C10)

This calculates total sales for iPhones only.

A simple and powerful way to analyze your data.

Follow the page for more practical Excel tips.

09/04/2026

𝐄𝐱𝐜𝐞𝐥 𝐓𝐢𝐩: 𝐒𝐔𝐁𝐓𝐎𝐓𝐀𝐋 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧

Did you know the normal SUM function still counts hidden rows when you filter data?

Use 𝐒𝐔𝐁𝐓𝐎𝐓𝐀𝐋 instead.

Formula:
=SUBTOTAL(9,C2:C10)

The number 9 tells Excel to SUM the visible rows only.

In this example, I filter phone sales by province and the total updates automatically.

A simple but powerful function for reports and dashboards.

Follow the page for more practical Excel tips.

07/04/2026

"Discover Your Best Self by Embracing Learning." Join our Online Free Courses for April 2026 intake by Chain Research Organization and Consultancy.

Elevate your skills, boost your career, and make 2026 your year of growth! 🌐💡 Hurry, join the group using the link now and seize the opportunity to gain valuable insights. Knowledge is the key to success! 🎓🔗

Join the WhatsApp group using the link below
Group: https://chat.whatsapp.com/CC9mRyDT6jBJE1h1FxqSDX

Like our page at
Chain Research Organisation and Consultancy - CROC

31/03/2026

31/03/2026

𝐄𝐱𝐜𝐞𝐥 𝐓𝐢𝐩: 𝐅𝐥𝐚𝐬𝐡 𝐅𝐢𝐥𝐥 (𝐂𝐭𝐫𝐥 + 𝐄)

Did you know Excel can automatically extract data for you without formulas?

Using Flash Fill, you just type the result once, press Ctrl + E, and Excel fills the rest.

Example:

From a list of full names, you can quickly extract:
✔ First name
✔ Last name

This is a quick and powerful way to clean your data.

Follow the page for more simple and practical Excel tips.

27/03/2026

𝐄𝐱𝐜𝐞𝐥 𝐓𝐢𝐩: 𝐓𝐄𝐗𝐓𝐒𝐏𝐋𝐈𝐓 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧

Instead of manually separating text or using Text to Columns, you can use 𝐓𝐄𝐗𝐓𝐒𝐏𝐋𝐈𝐓.

Example:

John Banda - 12/05/1998

Formula:
=TEXTSPLIT(A2,"- ")

Result:
John Banda | 12/05/1998

This helps you quickly split data into different columns and keep your dataset clean.

Follow for more simple and practical Excel tips.

26/03/2026

Excel Tip: TEXTBEFORE Function

Did you know you can extract names from combined text in Excel automatically?

Using the TEXTBEFORE function, you can return everything that appears before a selected character.

Example:

John Banda - 12/05/1998

Formula:
=TEXTBEFORE(A2,"- ")

Result: John Banda

This is very useful when working with combined data like names and dates in one cell.

Follow for more simple and practical Excel tips.