Google Sheets can create a personalised WhatsApp message for every person on a list, and a link that opens it in WhatsApp Web ready to send. It needs two formulas and no add-on, and it works for numbers that aren’t saved in your contacts. Functions& (join text) and HYPERLINK OpensWhatsApp Web in your browser Good … Read more
The quickest way to make an organization chart in PowerPoint is to type the hierarchy as a bulleted list, using Tab for each level down, and then convert the list to a SmartArt organization chart. FeatureConvert to SmartArt → Organization Chart Works inPowerPoint 2010 and later, Microsoft 365 TimeAbout five minutes Video The hierarchy The … Read more
Claude can build a complete PowerPoint file from one prompt and give you a .pptx to download. It works on the free plan, and you can change the design afterwards just by asking. You needA free Claude account OutputA .pptx file you can open and edit in PowerPoint TimeAbout two minutes Video Step 1: Write … Read more
With Python in Excel you can write a number out in words with a simple cell formula: 1,234.56 becomes One Thousand Two Hundred Thirty-Four Point Five Six, or One Thousand Two Hundred Thirty-Four Rupees and Fifty-Six Paise Only for invoices and cheques. There are two codes: one for words in thousands and millions, and one … Read more
Strava has an official connector for Claude. Once it’s linked, you can ask Claude about your runs, rides and training in plain English, and it answers from your real Strava data: pace, heart rate, distance, routes and gear. You needA paid Strava subscription and a Claude account Works inClaude on the web, the Claude desktop … Read more
VLOOKUP and XLOOKUP stop at the first match. To get every order for a customer, use FILTER in Excel 365 and 2021: one formula returns all the matching rows and spills them into the cells below. Here's how, plus a one-cell list with TEXTJOIN and a formula for older versions. Excel 365 / 2021=FILTER(range,condition) One … Read more
#N/A means not available: the lookup function couldn't find the value. Sometimes the value really is missing. Often it is there, but an extra space, a number stored as text or an unlocked range stops it matching. Here's how to find the cause, fix it, and show a friendly message for values that are genuinely … Read more
An exact match returns a result only when the lookup value is found exactly. An approximate match returns the nearest value below it, which is what you need for grade bands, tax slabs and commission rates. Using the wrong one is the most common reason a lookup returns a wrong answer without showing any error. … Read more
INDEX MATCH is two functions working together. MATCH finds the row number of the value you want, and INDEX returns the value from that row in any column. It looks left as well as right, and it doesn't break when you insert a column. It works in every version of Excel. PatternINDEX(result, MATCH(value, list, 0)) … Read more
In many organizations—whether private companies or government offices—managers require team members to submit daily or weekly work reports. A very common approach is asking employees to send updates through messaging apps like WhatsApp. However, this forces managers to manually copy and paste details into Excel or Google Sheets every single day, creating a tedious administrative … Read more