❖ Google drive Services Timely, Related To DME Like, Google Sheet, Google Form, Automation MIS, Google Scripting Project, Whatsap API etc…
COMPUTER SKILLS:-
❖ Ms Office ( Advance Excel , Word , PowerPoint )
❖ Filters (Basic, Advance, conditional)
❖ Single and multiple chart/graphs.
❖ Data validation, group/ungroup.
❖ V- Look up , H Lookup , Pivot table and chart, import/export data.
❖ Worksheet formatting and report development.
❖ Google Scripting
❖ Macros, Loops, Function &User Forms, Pivot table , sheet linked, input box , Google Drive Expert – Google Scripting , Google Form, Automation MIS.
❖ Google Drive Formula – Query,Filter, Import data ,Import range ,sheet linked ….etc.
Experience
• Prepare the FMS in Google sheet.
o Depth knowledge of advance functions like - Pivot table, Array, Query, V-lookup , H-lookup, Mail merge, import range other advance functions in Excel and Google sheets.
• Knowledge of scripting in Google Sheets and Excel to make sheets with Email automation, What’s App automation, data filtering etc..
• Advance knowledge of Google Forms, JOT forms.
• Make Flow chart monitoring sheets (FMS) and Project Monitoring sheets (PMS) on Google sheets.
• Automation to generate various MIS Dashboards for the Doers and Management to check actual reports
• Proactively interact with multiple internal/external stakeholders on a daily, weekly and monthly basis for the preparation of MIS reports
• Analyze data and reports from various sources and provide actionable insights and suggestions Prepare Ad hoc reports based on the requirements from the stakeholders
• Identify the opportunities of automating the reports, snapshots and dashboards using advanced formulae, and other techniques
• Make reports contextual - provide information based on the target audience
• Ensure on-time and accurate delivery of reports, analysis and service requests
• Continually monitor trends, performance & assist managers