MIS Consultant: Advance Excel/ Google sheet workshop
- for Companies MIS Project. on Google Sheet
- Training for School/College.
- Provided online Coaching for individual for Advance Excel vba/ Google Sheet/ Google App Script.
Registration for free online Coaching
please click bellow link to fill registration form (किरपीय नीचे दिये गये फॉर्म लिंक पर क्लिक करे और फ्री कोचिंग के लिए रजिस्ट्रेशन करें
please click bellow link to fill registration form (किरपीय नीचे दिये गये फॉर्म लिंक पर क्लिक करे और फ्री कोचिंग के लिए रजिस्ट्रेशन करें
https://www.dicteducate.com/
Technical
Skills:
- MS Office
2000/2007/13/16.
- Date
base: (Excel/Access/ MySQL/Oracle.)
- Advance
Excel/Macro with vba programming.
- Tally
Account Special Tax.
- Programming Languages: - C & C++/ Sql/ Vb.6/VB.net/Java.
- Web Designing: - HTML, DHTML, Java Script.
Google Drive:
- Google
Spreadsheet/ Docs/ Slides.
- Real Time
Advance Dashboard with Google sheets.
Google Data Studio:
- Real Time Dashboard interface with Data Studio.
- by which you can open reports on your mobile without open google sheet.
·
Retrieve
daily sales data from ERP.
·
Maintain
daily/weekly/monthly sales reports with automation.
·
Auto
generates reports like item/category/brand/value wise, with automation.
·
Auto
generates repots of sales order like approved/hold/rejected.
·
Generates
plan vs actual/ distributor plan vs actual reports.
·
Generates
sales vs expenses/ salesman target vs achievement.
·
Generates
highest sales item and score values.
·
Created
real time dashboard in google spreadsheets.
·
Created
real time dashboard in google data studio.
·
Created
real time employee performance portal in google spreadsheets.
·
Created
real time sales inquiry/Complain form in google form.
Advance Google Sheet/Spreadsheet workshop Training.
All Google Sheet Formula.
Creating all MIS/FMS DASHBOARD
ACTUAL VS PLANNING WORK
WROK NOT DONE
WORK NOT DONE ON TIME
WORK DELAY
Calculation of all above Contents.
Providing Total Industrial/Manufacturing Process
Show your all business activity on cloud/Google Sheet.
Google workshop Google App Scripts
providing all google java scripts programming
Creating Google Form
Approval Form
send E-mail Auto through you google form
etc...
Advance Excel with vba Programming
Course content:
user interface
creating user form
creating Dynamic Reports
advance formula with programming
advance pivot table
ready to one click all Report like daily, weekly, monthly, Yearly, Branch wise, Product wise etc..
