❖ 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