Articles tagged: Microsoft Excel
Follow Microsoft Excel
They land in your feed reader on their own — no account, no email address, nothing to unsubscribe from. Paste this URL into your reader:
https://www.avonture.be/blog/tags/excel/rss.xmlNo feed reader yet? Start here — it takes two minutes.
Markitdown - Convert files and MS Office documents to Markdown →
Easily convert MS Office documents (Word, Excel) and PDFs into Markdown format with Microsoft's Markitdown tool. Includes step-by-step instructions for installation via Docker.
May 4, 2026
MS Excel - Get the list of references used in your modules →
VBA developer? Stop manually checking references! Use this VBS script to automatically retrieve a list of all VBA references in multiple Excel .xlsm or .xlam files.
October 27, 2025
Discovering Pentaho, an ETL program →
Discover Pentaho Data Integration (ETL). Follow this step-by-step guide to install Pentaho (PDI/Kettle) on Linux and load data from an Excel file into a PostgreSQL database using Docker.
June 20, 2025
Excel Formula Beautifier →
Make your complex Excel formulas easy to read! Use the Excel Formula Beautifier to instantly format and clarify your spreadsheet formulas for better understanding.
May 25, 2025
MS Excel - Connect to a SQL Server database, run a query and get the results - Step by step →
Connect MS Excel VBA to SQL Server with this step-by-step tutorial. Learn to run SQL queries, retrieve data, and output results into your spreadsheet. Docker setup included.
March 16, 2025
MS Office - Load dropdown from Excel's range →
Load an Excel range into your custom VBA Ribbon dropdown control. This step-by-step tutorial covers the VBA code, Custom UI XML, and named ranges needed for a dynamic solution.
February 22, 2025
Markdown - Convert CSV to Markdown tables →
Quickly convert CSV content into clean, formatted Markdown tables using the CSV2MD tool. Learn how to use this efficient converter, including options for delimiters and transposing tables.
December 8, 2024
Markdown - Convert Excel ranges to Markdown tables →
Easily convert Excel ranges into clean Markdown tables with the XLS2MD online tool. Just copy your cells and paste to generate the code and a live HTML preview.
December 8, 2024
Pandas - Merge two or more files and create a merged one →
Efficiently merge two or more CSV or Excel files in Python using the powerful Pandas library. Learn step-by-step how to handle mismatched records and consolidate data like employee salaries across multiple years into a single, clean DataFrame.
December 6, 2024
Joomla - Run a SQL statement outside Joomla and display a nice HTML table →
Easily export live Joomla data to Microsoft Excel. Learn to run a custom SQL query outside of Joomla and display the results in a refreshable HTML table for spreadsheet linking.
June 2, 2024
MS Excel - Connect to a SQL Server database, run a query and get the results →
Connect MS Excel to SQL Server with VBA. Run SQL queries, inject results directly into your spreadsheet, and preserve formatting. Learn the best method for data refresh or secure sharing.
April 5, 2024
MS Excel - How to call a SOAP web service →
Master calling SOAP web services from MS Excel using VBA. Get the code and a step-by-step tutorial to validate VAT numbers with the VIES service.
February 21, 2024
MS Office - How to create a ribbon in Excel →
Step-by-step guide on creating a custom VBA Excel Ribbon. Use XML and VBA to add your own tabs, groups, buttons, and powerful features to your Excel workbooks.
December 10, 2023