Save Out Excel Worksheets to CSV Files Using Visual Basic

Introduction                Ever found yourself needing to separate Excel worksheets into CSV flat files to make it easier to ingest for ETL? Well I’m going to walk you through the steps to take to get this done using Visual Basic(VBA). With the help of VBA and Macros in Excel, we can get the job done […]

Excel Calculations: Unlock the Power of Operators!

Microsoft Excel is still one of many analytics and data tools used within corporations. Being it’s included in the Office 365 suite helps as there are no additional subscriptions or charges required in order to be used by the users. Its versatility, ease of use, and a lot of online learning materials assist Excel to […]