Excel Classes PDF- Run By Er. Anjnee Sir

Excel का PDF Download करने के लिए दिए गये निचे के लिंक पर क्लिक करके Download कर सकते है।

1.vlookup in multiple work book
2.stock maintance
3. excel cell automatic lock
4.login form
5. id card
6. GST invoce
7. Dynmaically auto update vlookup
8. Condinational Formatting part1
9. condinational part2
10. Cash Memo
11. convert Number to Word
12. convert Number to Hindi
13. advanced Filter Part 1
14. advanced Filter Part 2
15 data transfer on Multiple Sheet use Macro function
16. excel use Macro
17. how to automatically transfer data to another work sheet use macro function
18. Consolidate Function Part-1
19. Consolidate Function Part-2
20. Goal Seek
21. Calculate age
22. LCM
23. GCD(Greatest Common Division)
24. Ratio
25. Bar code
26. Formula Auditing( Trace Precedents, Trace Dependents, show Formulas )
27. How To Send Email From Excel
28. Stcok Maintains
29.How to Use Vlookup Formula in Userform Excel VBA
30. user Form Calculation two add no in excel VBA
31.user Form Calculation use two no addition,subtraction, multi, division in excel VBA
32. create Student Marksheet in excel VBA
33.UserForm with Multiple Option Buttons in Excel and VBA
34. Data Entry Form in Excel VBA
35. Electricity Bills in Excel VBA
36. Employee Data Entry Form in Excel VBA
37.Fully automated Data Entry user Form in Excel VBA
38.Stock[inventory]Management in Excel Without VBA Code
39. use indirect formula with sum,max,avg,count formula
40.Create Depanded drop down list
41. use popup
42. use calculator
43. use background color changing
44. use formula week day
45. use formula workday
46. use weeknum and yearfrac
47. use emonth and eomonth
48. use formula Networkday
49 age calculage from dob today
50 projectg managmenet
51. contact 91xxxxxx
52. use scroll bar
53 chart with target
54 projectg managment