From time to time we will publish, what we think, are interesting articles regarding Excel features or functions.
You can always email us to suggest an article to include. If you do, we will include, if you wish, your name at the bottom of the article stating 'Suggested by ...' and you can choose your full name or a nickname.
If you would like to send us a full article, we will attempt to add it to the list as soon as possible.
Learn how to use the SUMIFS function in Excel to total values based on multiple criteria. Whether you are analysing sales by date, filtering regions, or building reports, this step-by-step guide shows how to get it done like a pro — with real examples and best practices.
Read MoreWant to create clean, powerful Excel dashboards — even if you’re not a designer? This guide covers everything from layout and font choices to interactivity and KPIs. Learn practical, no-fluff design tips that’ll make your dashboards easier to use and better to look at.
Read MorePower Query is one of Excel’s hidden gems. These 5 tips will change the way you work with data.
Read MoreThree Excel shortcuts that every user should know.
Read MoreDiscover why XLOOKUP is the ultimate replacement for VLOOKUP, HLOOKUP, and even INDEX/MATCH. With directional flexibility, built-in error handling, exact match by default, and no more column guessing, XLOOKUP makes your formulas simpler, smarter, and far more powerful. If you're still using old-school lookup functions, it's time for an upgrade.
Read MoreLearn how to create structured drop-down lists in Excel using data validation, named ranges, and dynamic dependencies. From simple yes/no menus to category-based selectors, this guide walks you through practical techniques to make your spreadsheets cleaner and smarter.
Read MoreLearn how to create interactive checklists in Excel using in-cell checkboxes, conditional formatting, and live progress tracking. This step-by-step guide shows you how to build functional, visually engaging lists for tasks, goals, or routines—no coding required.
Read MoreExcel 365 brings powerful new functions, and XLOOKUP leads the pack. This post shows how XLOOKUP simplifies your formulas, eliminates the need for older lookup methods, and handles real-world data scenarios with ease. If you're still clinging to VLOOKUP, this is your sign to upgrade.
Read MoreExcel’s new dynamic array functions like SORT, FILTER, SEQUENCE, and UNIQUE allow formulas to spill across multiple cells automatically. Say goodbye to dragging formulas and hello to smarter, faster spreadsheets. Learn how these tools can transform your lists, reports, and dashboards with minimal effort.
Read MoreINDEX MATCH has long been the expert’s choice for lookups in Excel, but XLOOKUP is now the modern standard. This post compares the two in terms of performance, readability, and flexibility—helping you decide which to use and when.
Read MoreMessy spreadsheets are inevitable — but Excel gives you the tools to clean them up fast. From removing extra spaces and strange characters to splitting columns and using Power Query, this guide walks you through everything you need to turn chaos into clean, usable data.
Read MoreDiscover how to use Excel’s IF formulas to automate decisions and save time.
Read More