VINAY KUMAR

Course available for 3 months after purchase

Recorded Videos + PDF Notes + Practice Files

Syllabus

1. Introduction to MS Excel
2. Fill Series & Fill Handle
3. Advanced Conditional Formatting
4. Advance Sorting & Filtering
5. Pivot Table ( Pivot Chart)
6. Custom Data Format & Validation
7. Create & Manage Tables
8. Create Charts & Objects
9. Protect Workbook & Worksheet
10. Create Custom Number Formats
11. Configure Data Validation
12. Define Name Range & Objects
13. Create Advance Charts & Tables
14. Define Name Manager
15. Formula Auditing
16. Using Subtotal
17. Using Data Tools
18. Using Developer Tab
19. Using Macro & View Code
20. Create Dynamic Charts & Tables
21. Create Barcode
22. Using Wildcard with Formulas
23. Using Google Sheets
24. Mathematical Function
25. Text Function
26. Date & Time Function
27. Logical Function
28. Financial Function
29. Lookup & Reference Function
30. Vlookup with Multiple Sheets
31. Double Vlookup
32. Reverse Vlookup
33. Image Vlookup
34. Vlookup with Match
35. Vlookup with Columns

Practical Training
1. Employee Salary Detail
2. Inventory Stocks
3. Inventory Management with GST
4. Attendance Report
5. Attendance Sheet with Salary
6. Banking Accounting Database
7. Employee Time Schedule
8. Employee Working Hours with Overtime
9. Calculate Human Age
10. Marksheet Report
11. Day & Night Shift Hours
12. Weekly Work Schedule
13. Sales Report
14. Purchase Report
15. Store Report
16. Sales Tracking Report
17. Salary Chart of Govt. Officers
18. Salary Pay Slip
19. Petty Cash Log
20. Visitors Data Record
21. Online Shopping Invoice Database
22. Credit Card Transactions Report
23. Bank Passbook Statement
24. Monthly Expense Report
25. Property Sales Report
26. Bank Loan Interest
Y27. early Sales Turn Over
28. Annually Bond for Share Market
29. Annually RD Account
30. FD Account

After completed this course, you will be able to Data Entry Operator / Data Analysis



Don't Waste Your Time & Join Now

We will support Lifetime

M. 9650597419
Web. www.vinaytips.com

Advanced Excel Course (MIS Job Training)

U2FsdGVkX1/IqXK8mZ6WhPvTue0Cjg+CQsDii1l8uAI=

1. INTRODUCTION TO EXCEL

U2FsdGVkX19P5MshqCVkd9xCXZuKy8jmnGWOlP6EGQ4=

2. SUM FORMULA IN EXCEL

U2FsdGVkX1+n3mADmUU2ZJQpf4zLJu/AtX8o/dczwo4=

VLOOKUP WITH MATCH

Buy this course in 2 instalments and start learning now.

Running tight on budget? 
Pay amount in instalments

VINAYTIPS

Maharashtra

Hey! I’m learning with VINAYTIPS and you can too. Here’s a course you might like: Advanced Excel Course (MIS Job Training) by VINAY KUMAR
    https://zbdey.courses.store/320280?utm_source=whatsapp&utm_medium=social&utm_campaign=web-course-share

Hey! I’m learning with VINAYTIPS and you can too. Here’s a course you might like: Advanced Excel Course (MIS Job Training) by VINAY KUMAR
    https://zbdey.courses.store/320280?utm_source=facebook&utm_medium=social-fb&utm_campaign=web-course-share

Hey! I’m learning with VINAYTIPS and you can too. Here’s a course you might like: Advanced Excel Course (MIS Job Training) by VINAY KUMAR
    https://zbdey.courses.store/320280?utm_source=telegram&utm_medium=social&utm_campaign=web-course-share

Hey! I’m learning with VINAYTIPS and you can too. Here’s a course you might like: Advanced Excel Course (MIS Job Training) by VINAY KUMAR
    https://zbdey.courses.store/320280?utm_source=linkedin&utm_medium=social-link&utm_campaign=web-course-share

Hey! I’m learning with VINAYTIPS and you can too. Here’s a course you might like: Advanced Excel Course (MIS Job Training) by VINAY KUMAR
    https://zbdey.courses.store/320280?utm_source=copy-link&utm_medium=social&utm_campaign=web-course-share

You have Successfully Published Advanced Excel Course (MIS Job Training)

Others

Andaman and Nicobar Islands

Andhra Pradesh

Arunachal Pradesh

Assam

Bihar

Chandigarh

Chhattisgarh

Dadra and Nagar Haveli

Daman and Diu

Delhi

Gujarat

Haryana

Himachal Pradesh

Jammu and Kashmir

Jharkhand

Karnataka

Kerala

Ladakh

Lakshadweep

Madhya Pradesh

Manipur

Meghalaya

Mizoram

Nagaland

Odisha

Puducherry

Punjab

Rajasthan

Sikkim

Tamil Nadu

Telangana

Tripura

Uttar Pradesh

Uttarakhand

West Bengal

Daahir Cali

priyankasingh5558272@gmail.com

Priyanka

Amit Kumar

Join live trial classes to learn more about the course