CODE Magazine / Articles
Excel
Articles filed under Excel
Articles
Showing 1–2 of 2
-
The Excellent Schemer
Updated
Have you hoped for a good replacement for VBA for old versions of Office, but with the power of the .NET Framework and available to use with Microsoft 365? Try Accelerate's Visual Scheme for Applications (VSA), which you can use to create customer functions and more in Excel for Microsoft 365. Bob finds that the Scheme tool makes writing user-defined functions in Excel easy.
-
Power Query: Excel’s Hidden Weapon
Updated
Helen talks about how to use Power Query, a tool that's part of Excel and Power BI that enables you to automate the ETL process of bringing data into Excel. Learn to create an elegant ETL process in Power Query to first bring in the data, then later refresh it with a single button