REPLACEB Function in Excel: Replace by Bytes
TextLevel: ExpertAvailable in: Excel 2007+REPLACEB is the byte-based version of REPLACE.Syntax=REPLACEB(text,1,2,"**")ArgumentWhat it meanstextText to.
Read article →Atul Vij
How to Spot a Phishing Email in 30 Seconds (7 Checks)
How to Spot a Phishing Email in 30 Seconds (7 Checks)
Seven quick checks — sender domain, link preview, urgency, attachments, requests for OTP — to recognise phishing emails and messages at work and at…
Read article →Passwords, Passkeys and 2FA: A Practical Setup for Normal People
Passwords, Passkeys and 2FA: A Practical Setup for Normal People
A simple, realistic plan to protect your email, bank and work accounts: a password manager, passkeys where available, and the right kind of two-factor…
Read article →ROWS Function in Excel: How Many Rows in a Range
ROWS Function in Excel: How Many Rows in a Range
ROWS counts the rows in a range or array — the classic helper for top-N lists that fill down.
Read article →Count Unique Values With Criteria in Excel (365 and Older Versions)
Count Unique Values With Criteria in Excel (365 and Older Versions)
How many different customers bought in North? How many distinct products did Asha sell? Count unique values with UNIQUE+FILTER, SUMPRODUCT+COUNTIFS for older Excel, and…
Read article →LOGINV Function in Excel: Inverse Lognormal (Older Name)
LOGINV Function in Excel: Inverse Lognormal (Older Name)
LOGINV returns the value at a lognormal probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still…
Read article →Python for Office Automation: The Complete Starter Guide
Python for Office Automation: The Complete Starter Guide
Use Python to automate everyday office work: set up Python, handle files and folders, read and write Excel, create Word reports, send emails safely,…
Read article →Dynamic Arrays in Excel: SORT, FILTER and UNIQUE in Plain English
Dynamic Arrays in Excel: SORT, FILTER and UNIQUE in Plain English
Understand Excel 365 dynamic arrays: spilling results, the # spill reference, FILTER with AND/OR, SORT and SORTBY, UNIQUE counts, SEQUENCE, LET, and fixing #SPILL!…
Read article →Conditional Formatting with Formulas: 10 Rules Worth Knowing
Conditional Formatting with Formulas: 10 Rules Worth Knowing
Ten formula-based conditional formatting rules for real reports: highlight whole rows, overdue dates, duplicates, top N, weekends, missing values and differences between lists.
Read article →Power Automate Intermediate Lesson 8: Project – Invoice Processing From Email
Power Automate Intermediate Lesson 8: Project – Invoice Processing From Email
Final project: save invoice attachments from email to dated OneDrive folders, log them in Excel, route big invoices for approval and alert on failures.
Read article →COUPDAYS Function in Excel: Days in the Current Coupon Period
COUPDAYS Function in Excel: Days in the Current Coupon Period
COUPDAYS returns the number of days in the coupon period that contains settlement. Used for bond pricing and accrued interest on half-yearly coupons.
Read article →Power Automate Intermediate Lesson 7: Monitoring, Ownership and Sharing
Power Automate Intermediate Lesson 7: Monitoring, Ownership and Sharing
Keep flows running when people leave: co-owners and service accounts, run history and analytics, connection references, solutions, and the licence limits to know.
Read article →