Excel resources
Excel Macros
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 1 of 4 · 33 articles
Dynamic Data Placement on Images in SpreadsheetWeb Applications Using Excel Data
Learn how to dynamically place data on images in SpreadsheetWeb applications and enhance your applications with visualization.
Exploring Eta Lambda in Excel: A Comprehensive and Detailed Guide with Examples
Learn how to use Eta Lambda functions with examples, practical tips, and advanced use cases to enhance your data analysis skills.
The Microsoft Excel World Championship
Get ready for the ultimate challenge at the Excel World Championship. Test your skills and compete against the best.
Using VBA SpecialCells as an Excel Formula Checker
Finding cells with errors can be tricky. Let us show you how to display cell formulas in Excel that contain errors using VBA SpecialCells.
Add Excel Comments and How to Highlight Them Using VBA?
Finding comments inside a workbook can be challenging if you don't know where to look. Let's show you how to highlight Excel comments.
How to Create a Macro in Excel
Macros are great for automating most repetitive tasks. In this article, we are going to show you how to create a macro in Excel.
How to Loop through Each Character within a String in Excel
In this guide we will show how to efficiently loop through text data using this simple VBA code to analyze or manipulate strings.
How to Combine Data from Multiple Sheets in Excel
By leveraging Excel Tables and the intuitive Power Query interface, users can effortlessly merge information from distinct sheets.
How to delete all named ranges with #REF Excel errors using VBA
#REF errors can be annoying. In this article, we're going to show you how to delete named ranges with #REF Excel errors using VBA.