|
1. Proficient in SQL Queries using BI platforms or Data Base tools.
2. Proficient in MS Excel
a. If and Nested IF conditions
b. [AND] & [OR] conditions
c. Pivot Table & Pivot Chart
d. Text to Column
e. Advanced Find and Replace
f. H-Lookup & V Look Up
g. Data Cleaning
3. Web Forms
a. Creating online forms for data collection, ex: google forms
b. Understanding of various kinds of fields and their usages.
c. Live reports generation through Google Sheets etc.
4. MS Word
a. Mail Merge Function
5. Office Basics
a. Folder Management
b. Version Management of important files
c. Auto Back Up to cloud etc.
d. Advanced search and find of files
6. Preparing periodic statements
|