- Went through the Excel file having the
Data Tab (I see about 131 columns)
NFa Tab
- Can got copied the Raw data
- Can get the conditional formattting highlighting a row based on certain condition.
- Removing rows that have duplicated column1 value.
- Recording macro is start of the solution, and there needs to be additional customization of code, to Keep the data in Yello, and remove the columns in Grey.
- Once all done copying the data a new workbook with the name of the file including current date.
These steps could be automated.
- Just the recent project which I completed goes through the same flow, getting raw data
highlighting rows based on columns
Additional analysis and filtering of data.
Filtering data based on certain conditions.
My Skills:
- 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.,
- 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 projects done - https://www.freelancer.com/u/satishtl