Power BI, Excel and MS Industry News

Filter by Category or Experience Level:

VBA Automation using Macros

VBA Automation – A Case Study VBA is the programming language, which is used for writing macros in Microsoft Excel and all other Microsoft Office applications. Learning VBA code allows users to automate tasks, from simple ones in Excel such as entering and editing cell values, to interacting between other apps. VBA is used within Microsoft…

Read more

Excel Automation

Excel Automation – Plain English, Please! When I introduce our company to new clients, I tell them that we specialise in data analysis, Excel dashboards, Excel automation, and more. When I get to the phrase “Excel Automation” I often see a puzzled look on people’s faces. They don’t seem to understand what I mean by…

Read more