- Went through the csv and the images....
- Can be done like this. You specify the folder where the csv files are, and have the duration entered ie start date and end date....
- Based on the period the chart can be populated.....
- But note if the duration is within a month, we can have daily in X axis and have the graphs plotted
- But if it is within a year then weekly plots can be done, for more than a year it would be monthly calls in the graph.
- You dont have to convert any csvs manually would be automatically taken acre by the program.
- Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs.
- Extensively the macros/VBA to automate:
- Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells,, data camparision using formulas, lookups and bringing up summaries.,
- Data extraction using API.
- Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them.
- With summary data plotting graphs, bringing pivot tables
- Pl. review my portfolio on recent projects.