iⁿ

Connexion: "Excel: Why using Microsoft's tool caused Covid-19 results to be lost" i-nth.com/resources/connexio… The UK under-reported Covid-19 cases. Excel has been blamed, but the issue is much deeper than that. #MSExcel @ICAEW_Tech

Connexion: "Excel formulas not working: Possible reasons and how to fix it!" This article highlights common issues that are likely the cause of your Excel formulas not working. i-nth.com/resources/connexio… #Excel #spreadsheets

Bibliography: "Gridlets: Reusing spreadsheet grids" A Gridlet is a copy of a range including formatting, with local modifications applied to the range, and a live link to the copied range. i-nth.com/resources/bibliogr… #Excel #spreadsheets

Connexion: "Why implementing a financial modelling standard is hard" Modelers across the globe are beginning to recognise financial modeling as a profession, but many teams do not have consistent quality control systems in place. #msexcel #spreadsheets i-nth.com/resources/connexio…

Bibliography: "XLBlocks: A block-based formula editor for spreadsheet formulas" XLBlocks is a block-based formula editor that supports spreadsheet users to make fewer errors and better focus on the logic of their program. i-nth.com/resources/bibliogr… @heerbommel @Felienne #msexcel

Bibliography: "On the usage of dependency-based models for spreadsheet debugging" This paper presents a novel Model-Based Software Debugging (MBSD) approach for spreadsheets. i-nth.com/resources/bibliogr… #Excel #spreadsheets

Bibliography: "SGUARD: A feature-based clustering tool for effective spreadsheet defect detection" SGUARD clusters spreadsheet cells to recognize anomalous cells as defects. i-nth.com/resources/bibliogr… #MSExcel

Bibliography: "Improvement of spreadsheet quality through reduction of end-user overconfidence" Spreadsheet developers who learn about errors and best practices create more accurate spreadsheets and are less overconfident. i-nth.com/resources/bibliogr… #Excel #spreadsheets

Connexion: The VLOOKUP slayer: XLOOKUP debuts Excel Introducing XLOOKUP, a replacement for VLOOKUP and HLOOKUP. i-nth.com/resources/connexio… #Excel #spreadsheets @MrExcel

Bibliography: "WARDER: Refining cell clustering for effective spreadsheet defect detection via validity properties" i-nth.com/resources/bibliogr… #Excel #spreadsheets

Connexion: "Avoiding keyed in values in Excel formulas" One of the cardinal rules of Excel is don't key-in a value into a formula if that value could change. Tables can be the solution to avoiding keyed-in values. i-nth.com/resources/connexio… #Excel #spreadsheets @ExcelYourself

Connexion: "Care with modifying numbers" Unit conversion is often necessary. By using a custom number format, rather than modifying values, you will never again add or subtract numbers of different orders of magnitude. i-nth.com/resources/connexio… #Excel #spreadsheets @AccountingWEBuk

Connexion: "How to use Conditional Formatting in Excel" This article shows over 20 different ways that you can use Conditional Formatting, starting with some basics and presenting some advanced techniques as well. i-nth.com/resources/connexio… #MSExcel #spreadsheets @Vertex42

Connexion: "Average top 3 scores" This short article shows you how to average the top n values in a set of data. i-nth.com/resources/connexio… #MSExcel #spreadsheets @exceljet

Bibliography: "Now you're thinking with structures: A concept for structure-based interactions with spreadsheets" i-nth.com/resources/bibliogr… We present a concept for structure-aware understanding of and interaction with spreadsheets.

Bibliography: "Automated repair of data faults in templated spreadsheets" This paper proposes an error repair method for input cells in templated spreadsheet based on symbol execution and constraint satisfaction solving. i-nth.com/resources/bibliogr… #Excel #spreadsheets

Bibliography: "Explaining spreadsheets with spreadsheets" i-nth.com/resources/bibliogr… Based on the concept of explanation sheets, we present an approach to make spreadsheets easier to understand and thus easier to use and maintain. #Excel #spreadsheets @jacomecunha

Connexion: "Excel trendline types, equations and formulas" Tutorial with detailed description of all the trendline options available in Excel and when to use them. i-nth.com/resources/connexio… #Excel #spreadsheets @Ablebits

Connexion: "The double negative in Excel formulas" This article shows you how to use the double negative, and other methods, to coerce TRUE or FALSE values to their numeric equivalents. i-nth.com/resources/connexio… #Excel #spreadsheets

Bibliography: "Fragment-based spreadsheet debugging" We propose an interactive spreadsheet algorithmic debugging method, which is based on partitioning the spreadsheet into fragments. i-nth.com/resources/bibliogr… #Excel #spreadsheets