Category Microsoft

Microsoft News

Power Automate Basics: Understanding Connectors & Triggers | DAY-2

In the Day 1 blog, we explored the foundation of Power Automate—What it is, Why it matters, Where it can be used, and When it’s most useful.Now, let’s move one step further into the heart of Power Automate: 👉 Connectors…

Make Your Excel Reports Interactive with Spin Buttons!

When working with Excel, many users struggle with adjusting product prices, margins, and quantities dynamically. Instead of manually updating product quantities and margins, why not use Spin Buttons to adjust them dynamically? I recently created a pricing model where both…

Formulas to Create Stylish Number Lists in Excel

When working with Excel, we often create lists with plain serial numbers. But did you know you can create stylish or structured number lists with just a simple formula? By combining the UNICHAR and ROW functions, you can replace standard…

How to Sum Weight Values Like “12 KG” or “105 KG” in Excel – 4 Formula Comparison

When you’re working with weights like “12 KG” in Excel, =SUM() won’t work because these are text values. In this post, we’ll walk through 4 common formulas and explain which one you should use — and why. Here’s the test…

How to Split Long Text into Rows and Columns in Excel Using TEXTSPLIT + WRAPROWS

If you’ve ever received a long line of data like this in Excel: CopyEditRam-39,Male,Haryana, Sita-32,Female,Uttar Pradesh, Mohan-45,Male,Rajasthan, … …and wanted to split it into a clean, readable table like: Name Age Gender Location Ram 39 Male Haryana Sita 32 Female…