Microsoft Excel
Macro VBA
Google Sheet
AppScript
...
You can view some useful programs for data analysis activities in your day to day work
Google Sheet Analysis
Project - 1
General Ledger Analysis
The project has been built using Google Sheet advanced Query function which performs General Ledger data analysis
MS Excel: Weather Forecast
Webscrapping of weather forecast data using excel
Understanding Data using Google AppScript
Objective: To monitor if the values are running uniquely or the same as before.
Use Case: Useful for salary monitoring. I regularly use it to monitor salary slippages and/or
genuine changes over pay
period
Code: View next tab in the sheet
Understanding Data using Google AppScript
Financial Data Seggregation & Analysis
Objective: To bucket the data into components for claim purpose
Result: This instance gives the progress across the ledger. The formula bar has shown the formula for summing up
Understanding Data using Google AppScript
...
Objective: Compare two tables together, by comparing and contrasting data.
Use Case: I frequently use this technique to compare the budget that we submitted in proposal and
the one that is approved or the draft versus final budget
Code: See the snapshots below the output
This project has been built using isna, match and filter functions
Go to Homepage