Formulas Articles
Articles tagged Formulas, including related tutorials, examples, and walkthroughs.
15 articles
How to Change Case in Excel: Uppercase, Lowercase, and Proper Case
Learn how to change case in Excel with UPPER, LOWER, PROPER, Flash Fill, and Paste Special so you can safely replace text values....
Compare Two Columns in Excel
Learn how to compare two columns in Excel for matches, differences, duplicates, missing values, and case-sensitive text....
How to Find and Fix Circular References in Excel
Learn how to find a circular reference in Excel, trace the formula loop, fix common circular reference errors, and handle intentional iterative formulas....
How to Calculate Percentage Change in Excel
Learn the percentage change formula in Excel, including examples for increases, decreases, percentage formatting, and avoiding divide-by-zero errors....
The Karpathy Loop for Excel: How Autoresearch Changes the Way We Optimize Spreadsheets
Learn how Karpathy's autoresearch pattern — the AI experiment loop that ran 700 tests in two days — applies to Excel formula optimization, VBA macros, and AI-assisted spreadsheet workflows....
Claude for Excel Review: Best for Complex Models and Error Tracing?
Review Claude for Excel for complex models, error tracing, and careful workbook analysis, including the limits that still matter in beta....
ChatGPT for Excel: What It Does Well and Where It Still Needs Review
Review ChatGPT for Excel after the March 5, 2026 launch and see where it helps most with formulas, workbook analysis, and spreadsheet workflows....
How to Use =COPILOT in Excel
Learn how to use the =COPILOT function in Excel, what kinds of prompts work best in cells, and where this feature still needs careful review....
Can AI Fix Broken Excel Formulas? Real Tests With VLOOKUP, XLOOKUP, and SUMIFS
I tested whether AI can fix broken Excel formulas in real scenarios involving VLOOKUP, XLOOKUP-style logic, and SUMIFS errors caused by dirty data....
How to Use AI to Explain Excel Formulas Step by Step
Learn how to use AI to explain Excel formulas step by step, including how to verify the explanation and catch what the model still gets wrong....
Best AI for Excel Formulas: Copilot vs ChatGPT vs Claude
Compare Copilot, ChatGPT, and Claude for Excel formulas using the same prompt, the same workbook task, and the same verification standard....
How to Use Copilot in Excel for Formulas, Analysis, and Cleanup
Learn how to use Copilot in Excel for real workbook tasks such as formula writing, data cleanup, and quick analysis without trusting the first answer blindly....
How to Use XLOOKUP with Multiple Criteria in Excel
Learn how to use XLOOKUP with multiple criteria in Excel by combining Boolean logic or concatenation for cleaner, more flexible lookups....
How to Add Cells in Excel to Sum Up Totals Automatically
Excel's great for displaying data and even better at crunching numbers. Here's how to add cells in Excel to sum up totals automatically... Even when you change the numbers....
How to Use the SUMIF and SUMIFS Functions in Excel
Lessen the time it takes to compute complex equations with the SUMIF and SUMIFS functions on MS Excel. This update may be just what you've been waiting for. Follow this in-depth, easy-to-follow guide to get started...
About Excel Semi Pro
Since 2010, we have been helping people improve their Excel skills. Here, you will find beginner and intermediate tips on navigating spreadsheets to achieve results.
Read more about us