Tutorial: How to Create an Audio-Enabled Lexicon in Excel Using VBA

This video introduces an XLSM file (macro-enabled Excel) with advanced features designed as an audio-enabled lexicon. This versatile tool can also be adapted for other purposes. I created this file during my journey to master standard Project Management terminology, which involves learning over 700 terms. You can download the XLSM file directly from Observable: https://observablehq.com/@christophe-yamahata/dynamic-lexicon-with-excel-and-vba This tool offers several interesting features: • 𝗥𝗮𝗻𝗱𝗼𝗺 𝘀𝗲𝗹𝗲𝗰𝘁𝗶𝗼𝗻 of terms from the glossary • 𝗜𝗻𝘁𝘂𝗶𝘁𝗶𝘃𝗲 𝘀𝗲𝗮𝗿𝗰𝗵 with an integrated engine • 𝗜𝗻𝘁𝗲𝗿𝗮𝗰𝘁𝗶𝘃𝗲 𝘀𝗲𝗹𝗳-𝗮𝘀𝘀𝗲𝘀𝘀𝗺𝗲𝗻𝘁 using Kanban-style cards • 𝗧𝗲𝘅𝘁-𝘁𝗼-𝘀𝗽𝗲𝗲𝗰𝗵 capabilities, with a basic voice via Microsoft SAPI or a more natural one using Azure AI Speech