Blog Posts on MS Excel
With one detailed prompt, Claude can build a complete sales dashboard inside Excel: a helper column, five PivotTables, five formatted charts and a slicer, laid out on one screen. Here is the exact prompt I used, the sample data to try it on, and why the prompt is written the way it is. ToolClaude in … Read more
This Excel template works out when each policy, subscription or document expires, counts the days left and flags anything Expired or Expiring Soon in colour. Because it uses TODAY, the alerts update every time you open the file. FunctionsEDATE, TODAY and IF AlertsConditional formatting: red for expired, yellow for due within 7 days Works inExcel … Read more
This Excel form collects new employee details on one sheet and, when you click Submit, saves them as a new row on a database sheet and clears the form. The Submit button runs a macro you record, so there’s no code to write. Built withData Validation, option buttons, IF and a recorded macro Saved asExcel … Read more
A one-page sales dashboard in Excel needs only three things: PivotTables to summarise the data, PivotCharts to show it, and a slicer connected to every chart, so one click on a month updates the whole page. Built withPivotTables, PivotCharts and a slicer ChartsLine, column, bar and pie Works inExcel 2013 and later, Microsoft 365 TimeAbout … Read more
Excel can write a personalised WhatsApp message for everyone on a list and turn it into a link. Click the link and WhatsApp opens with the number and message filled in, ready to send, even if the number isn’t saved in your phone. Functions& (join text), TEXT and HYPERLINK OpensWhatsApp Web in your default browser … Read more
A simple Excel sheet can track your income, expenses and savings month by month. You type the figures; SUM totals each section and one subtraction gives your savings, all updating as you go. FunctionsSUM and a subtraction LayoutMonths across, income and expense items down Works inAny version of Excel, and Google Sheets Video Step 1: … 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
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