excel

As an R&D engineer, working within one of the largest wafer fabs in Europe, I spend a lot of my time analyzing data and generating reports, in order to make informed decisions about product design and process. It’s essential to use tools that can help analyze data quickly and easily, so I can identify trends and problems and take corrective action. Two popular data analysis tools for engineers like myself are SAS JMP and Microsoft Power BI....

I’ve been using VBA to generate pivot tables in Excel for a few years now, and I’ve found it to be a very powerful tool. I can use VBA to quickly and easily create pivot tables that summarize large amounts of data. I can also use VBA to update pivot tables as my data changes. In this blog post, I’ll show you how I use VBA to generate pivot tables. I’ll start by explaining what pivot tables are and why they are useful....