I have 5 years experience in designing user friendly Excel templates, spreadsheet solutions using VBA (Visual Basic for Applications) and preparing Dashboards.
Read More »
I focus on developing easy to use applications, quality of data & reports by applying checks & validations. I have conducted corporate trainings on Basic & Advanced features of Excel (data entry, data management and analysis). I also specialize in Word documentation, PowerPoint presentations.
The key skills that I possess include:
1) Design MIS & Reporting Formats - Using advanced Excel (Complex formulas, Macros, VBA Forms)
2) Data Entry, Collation & Cleansing – Formatting, de-duplication, validations, Sorting, Filter
3) Data Analysis – Trend analysis, Pareto analysis, Charts, graphical presentation
4) Automated Reports & Dashboards – Pivot tables, Productivity & Performance Dashboards
5) Budget Management – Monthly & yearly business plan (Revenue, Capex & Opex)
6) Object Linking & Embedding – MS Office Applications (Word, Excel & PowerPoint)
7) MS Word documentation, MS PowerPoint presentation
8) Data Transformation/Conversion - PDF to Excel, Word to Excel, Word to Image
Completed Assignments :-
1. Vocational Training & Placements:
Developed stand-alone application “Student Enrollment System” using MS Excel as Back-end and Visual Basic Form as Front-end.
2. Travel & Tourism:
Designed stand-alone application on Travel & Tourism using advanced features of MS Excel.
Apart from these applications, I have designed Excel templates for Cash Book, Budget management, Trainer utilization, Student attendance, Micro-level Batch Planning and Sending Bulk Emails.
Read More »