Tutorials, Exercises & Own Projects which involves Excel-VBA & Word-VBA has been staged here. This Repository has a Tutorial which is helping me in my Learning Curve from the Ground Basics.

Compare 12 stock performances for 2 years as well as refactor code to improve the runtime of calculation.

Analysis of stock data to determine investment decisions

Excel VBA assignment covering for loops, if-else loops, conditional formatting, and more in VBA script (Due: 03-13-2021)

VBA Scripting to Analyze Real Stock Market Data.

Refactoring code and measuring VBA script performance.

Researching Historical Stock Data with VBA Scripting

Stock Analysis using Excel and VBScript

Spreadsheet - Accounting Excel and VBA

Penn Data Boot Camp Assignment 2 - VBA scripting to analyze real stock market data by automating process and summarizing stock information.

Stock market data analysis using VBA.

Analysis of green energy stocks using Excel and VBA.

Generate VBA script to analyze generated stock market data.

💷 Automating Stock analysis over different sheets using VBA 👉

Playing with VBA for automating data analysis of stock data calculations.

VBA Excel macro that reads excel workbook containing stock data, (each worksheet containing one year's data) and outputs required information.

If the ActiveCell is in a certain range, then colour the cell AND copy the cell AND minimise the window.

Year-Over-Year Stock Analysis in Excel