| 1. Access Intro.mp4 | 19.4 MB | ||
| 1. Access Intro.vtt | 5.6 KB | ||
| 1. Excel structure.mp4 | 131.5 MB | ||
| 1. Excel structure.vtt | 7.9 KB | ||
| 1. Introduction to Macro.mp4 | 72.2 MB | ||
| 1. Introduction to Macro.vtt | 8.6 KB | ||
| 1.1 Excel Excercise.zip.zip | 1.3 MB | ||
| 10. Print related options in Excel Part 2.mp4 | 74.4 MB | ||
| 10. Print related options in Excel Part 2.vtt | 8.4 KB | ||
| 10. Solution for the task.mp4 | 38.8 MB | ||
| 10. Solution for the task.vtt | 4.4 KB | ||
| 11. Methods to refer to sheets.mp4 | 67.8 MB | ||
| 11. Methods to refer to sheets.vtt | 8.3 KB | ||
| 11. Text Function - Upper, Lower, Proper, Trim.mp4 | 66.7 MB | ||
| 11. Text Function - Upper, Lower, Proper, Trim.vtt | 5.9 KB | ||
| 12. Methods related to sheets and its properties.mp4 | 125 MB | ||
| 12. Methods related to sheets and its properties.vtt | 9.6 KB | ||
| 12. Text Function - Right, Left.mp4 | 45.3 MB | ||
| 12. Text Function - Right, Left.vtt | 3.8 KB | ||
| 13. Sheet related task.mp4 | 15.1 MB | ||
| 13. Sheet related task.vtt | 1.8 KB | ||
| 13. Text Function - Find and task.mp4 | 71.1 MB | ||
| 13. Text Function - Find and task.vtt | 5.6 KB | ||
| 14. Sheet Related Task Solution.mp4 | 26.9 MB | ||
| 14. Sheet Related Task Solution.vtt | 3.4 KB | ||
| 14. Text Function - Solution and Nested Left.mp4 | 62.9 MB | ||
| 14. Text Function - Solution and Nested Left.vtt | 5.2 KB | ||
| 15. Methods to Refer to Workbooks.mp4 | 25 MB | ||
| 15. Methods to Refer to Workbooks.vtt | 2.5 KB | ||
| 15. Text Function - Find and Left Nesting.mp4 | 34.3 MB | ||
| 15. Text Function - Find and Left Nesting.vtt | 2.7 KB | ||
| 16. Methods related to workbook.mp4 | 46.7 MB | ||
| 16. Methods related to workbook.vtt | 2.9 KB | ||
| 16. Text Function - MID.mp4 | 38.8 MB | ||
| 16. Text Function - MID.vtt | 3.6 KB | ||
| 17. Text Function - Mid task and solution.mp4 | 54.4 MB | ||
| 17. Text Function - Mid task and solution.vtt | 6.2 KB | ||
| 17. Workbook related project.mp4 | 108.4 MB | ||
| 17. Workbook related project.vtt | 9.2 KB | ||
| 18. Declared Variable.mp4 | 74.5 MB | ||
| 18. Declared Variable.vtt | 8.6 KB | ||
| 18. Text Function - Concatenate.mp4 | 33.3 MB | ||
| 18. Text Function - Concatenate.vtt | 3.4 KB | ||
| 19. Data Types in Variable.mp4 | 86.4 MB | ||
| 19. Data Types in Variable.vtt | 6.1 KB | ||
| 19. Text Function - Concatenate task and solution.mp4 | 20.8 MB | ||
| 19. Text Function - Concatenate task and solution.vtt | 2 KB | ||
| 2. Cell properties.mp4 | 30.2 MB | ||
| 2. Cell properties.vtt | 3.1 KB | ||
| 2. Create table in MS Access.mp4 | 99.9 MB | ||
| 2. Create table in MS Access.vtt | 13.8 KB | ||
| 2. Start Macro Programming.mp4 | 27.8 MB | ||
| 2. Start Macro Programming.vtt | 7.3 KB | ||
| 20. Object variable related project.mp4 | 23.4 MB | ||
| 20. Object variable related project.vtt | 2.5 KB | ||
| 20. Text Function - Replace.mp4 | 53.5 MB | ||
| 20. Text Function - Replace.vtt | 4.4 KB | ||
| 21. Solution for the task - Object Variable.mp4 | 30.8 MB | ||
| 21. Solution for the task - Object Variable.vtt | 3.2 KB | ||
| 21. Text Function - Replace task and Solution.mp4 | 64.7 MB | ||
| 21. Text Function - Replace task and Solution.vtt | 4.9 KB | ||
| 22. Text Function - Substitute.mp4 | 46.5 MB | ||
| 22. Text Function - Substitute.vtt | 3.8 KB | ||
| 22. Variable Project.mp4 | 67.3 MB | ||
| 22. Variable Project.vtt | 6.5 KB | ||
| 23. AND OR in VBA.mp4 | 73.1 MB | ||
| 23. AND OR in VBA.vtt | 7.5 KB | ||
| 23. Text Function - Len, Rept, Exact, search.mp4 | 30.4 MB | ||
| 23. Text Function - Len, Rept, Exact, search.vtt | 2.8 KB | ||
| 24. Project related to IF.mp4 | 13.3 MB | ||
| 24. Project related to IF.vtt | 1.7 KB | ||
| 24. Text to column.mp4 | 95.8 MB | ||
| 24. Text to column.vtt | 8.3 KB | ||
| 25. Solution of IF task.mp4 | 30.6 MB | ||
| 25. Solution of IF task.vtt | 2 KB | ||
| 25. Workbook protect.mp4 | 33.4 MB | ||
| 25. Workbook protect.vtt | 4 KB | ||
| 26. Protect sheet.mp4 | 58.2 MB | ||
| 26. Protect sheet.vtt | 7.5 KB | ||
| 26. Select Case.mp4 | 24.1 MB | ||
| 26. Select Case.vtt | 3.3 KB | ||
| 27. Hide Formulas and unlocked Cell.mp4 | 49.2 MB | ||
| 27. Hide Formulas and unlocked Cell.vtt | 4 KB | ||
| 27. Select Case 2nd Scenario.mp4 | 40.3 MB | ||
| 27. Select Case 2nd Scenario.vtt | 3.2 KB | ||
| 28. Protect File with password.mp4 | 23.7 MB | ||
| 28. Protect File with password.vtt | 2.1 KB | ||
| 28. Select Case 3rd Scenario.mp4 | 86.2 MB | ||
| 28. Select Case 3rd Scenario.vtt | 6.5 KB | ||
| 29. If Function - Logical Test.mp4 | 72.3 MB | ||
| 29. If Function - Logical Test.vtt | 8.1 KB | ||
| 29. Understanding Loop.mp4 | 69.4 MB | ||
| 29. Understanding Loop.vtt | 5.6 KB | ||
| 3. Autofill value and text.mp4 | 29.1 MB | ||
| 3. Autofill value and text.vtt | 5 KB | ||
| 3. How to Import and Export in Access.mp4 | 72.8 MB | ||
| 3. How to Import and Export in Access.vtt | 6.8 KB | ||
| 3. Macro Task Basic.mp4 | 23.6 MB | ||
| 3. Macro Task Basic.vtt | 3.3 KB | ||
| 30. If Function - with Equation and task.mp4 | 28.5 MB | ||
| 30. If Function - with Equation and task.vtt | 2.6 KB | ||
| 30. Loop Practical example.mp4 | 54.6 MB | ||
| 30. Loop Practical example.vtt | 4.6 KB | ||
| 31. If Function - Nested If.mp4 | 37.9 MB | ||
| 31. If Function - Nested If.vtt | 3.6 KB | ||
| 31. Loop Related Task Solution.mp4 | 41.5 MB | ||
| 31. Loop Related Task Solution.vtt | 3.1 KB | ||
| 32. Do While Loop.mp4 | 18.9 MB | ||
| 32. Do While Loop.vtt | 2.2 KB | ||
| 32. If Function - advance.mp4 | 43.9 MB | ||
| 32. If Function - advance.vtt | 4.4 KB | ||
| 33. For Loopcounter.mp4 | 50.8 MB | ||
| 33. For Loopcounter.vtt | 5.4 KB | ||
| 33. If Function - advance - 2.mp4 | 47 MB | ||
| 33. If Function - advance - 2.vtt | 3.7 KB | ||
| 34. AND , OR Function.mp4 | 61.6 MB | ||
| 34. AND , OR Function.vtt | 6.6 KB | ||
| 34. For Loopcounter Step importance.mp4 | 34.9 MB | ||
| 34. For Loopcounter Step importance.vtt | 3.1 KB | ||
| 35. AND, OR, IF Nested.mp4 | 61.9 MB | ||
| 35. AND, OR, IF Nested.vtt | 4.5 KB | ||
| 35. For Loopcounter Step Example 2.mp4 | 52.1 MB | ||
| 35. For Loopcounter Step Example 2.vtt | 5.4 KB | ||
| 36. AND, OR Advance.mp4 | 20.3 MB | ||
| 36. AND, OR Advance.vtt | 2.5 KB | ||
| 36. For Each Loop.mp4 | 42.9 MB | ||
| 36. For Each Loop.vtt | 4 KB | ||
| 37. For Each Example.mp4 | 34.6 MB | ||
| 37. For Each Example.vtt | 3.1 KB | ||
| 37. Pivot Table - Intro.mp4 | 59 MB | ||
| 37. Pivot Table - Intro.vtt | 5.6 KB | ||
| 38. For Each Task Solution.mp4 | 26.1 MB | ||
| 38. For Each Task Solution.vtt | 1.8 KB | ||
| 38. Pivot Table - Manage Field Area.mp4 | 70.2 MB | ||
| 38. Pivot Table - Manage Field Area.vtt | 7.1 KB | ||
| 39. Loop Related Task.mp4 | 15.2 MB | ||
| 39. Loop Related Task.vtt | 1.4 KB | ||
| 39. Pivot Table - Value Field, Report and more.mp4 | 54.8 MB | ||
| 39. Pivot Table - Value Field, Report and more.vtt | 5.5 KB | ||
| 4. Autofill date.mp4 | 19.9 MB | ||
| 4. Autofill date.vtt | 2.5 KB | ||
| 4. Create form from table.mp4 | 30.7 MB | ||
| 4. Create form from table.vtt | 4.5 KB | ||
| 4. Methods to Refer Range.mp4 | 58.6 MB | ||
| 4. Methods to Refer Range.vtt | 6.2 KB | ||
| 40. Loop Solution and Futher Task.mp4 | 55.2 MB | ||
| 40. Loop Solution and Futher Task.vtt | 4.9 KB | ||
| 40. Pivot Table - Slicer and Dublicate Pivot.mp4 | 72.4 MB | ||
| 40. Pivot Table - Slicer and Dublicate Pivot.vtt | 6.9 KB | ||
| 41. Loop Related Project.mp4 | 153.6 MB | ||
| 41. Loop Related Project.vtt | 10 KB | ||
| 41. Pivot Table - Group to mange date and values.mp4 | 50.6 MB | ||
| 41. Pivot Table - Group to mange date and values.vtt | 5 KB | ||
| 42. How to create Events.mp4 | 78.7 MB | ||
| 42. How to create Events.vtt | 8.6 KB | ||
| 42. Pivot Table - Insert Calculated Field.mp4 | 35.1 MB | ||
| 42. Pivot Table - Insert Calculated Field.vtt | 3.2 KB | ||
| 43. Events Example and task.mp4 | 23 MB | ||
| 43. Events Example and task.vtt | 2.8 KB | ||
| 43. Goal seek.mp4 | 54.5 MB | ||
| 43. Goal seek.vtt | 7.3 KB | ||
| 44. Event Task Solution.mp4 | 16 MB | ||
| 44. Event Task Solution.vtt | 2.3 KB | ||
| 44. Scenario manager.mp4 | 52.6 MB | ||
| 44. Scenario manager.vtt | 6.2 KB | ||
| 45. PMT function - EMI calculator.mp4 | 36 MB | ||
| 45. PMT function - EMI calculator.vtt | 4.7 KB | ||
| 45. Sheet Specific Events.mp4 | 21.9 MB | ||
| 45. Sheet Specific Events.vtt | 3.2 KB | ||
| 46. Create Function in VBA.mp4 | 38.1 MB | ||
| 46. Create Function in VBA.vtt | 6 KB | ||
| 46. Data table - Create Loan Table.mp4 | 88.7 MB | ||
| 46. Data table - Create Loan Table.vtt | 6.8 KB | ||
| 47. Function Related Task.mp4 | 13.5 MB | ||
| 47. Function Related Task.vtt | 1.5 KB | ||
| 47. Share book.mp4 | 20.6 MB | ||
| 47. Share book.vtt | 2.1 KB | ||
| 48. Chart Preperation.mp4 | 136.3 MB | ||
| 48. Chart Preperation.vtt | 14.4 KB | ||
| 48. Function Related task Solution.mp4 | 13.7 MB | ||
| 48. Function Related task Solution.vtt | 1.3 KB | ||
| 49. Chart Preperation - Advance.mp4 | 47.4 MB | ||
| 49. Chart Preperation - Advance.vtt | 5.1 KB | ||
| 49. Create Optional Parameter in Function.mp4 | 29.7 MB | ||
| 49. Create Optional Parameter in Function.vtt | 3.9 KB | ||
| 5. Autofill Adv tools.mp4 | 36.2 MB | ||
| 5. Autofill Adv tools.vtt | 4.3 KB | ||
| 5. Create Blank Form in Access.mp4 | 184 MB | ||
| 5. Create Blank Form in Access.vtt | 12.7 KB | ||
| 5. Selection of multiple cell.mp4 | 60 MB | ||
| 5. Selection of multiple cell.vtt | 5.2 KB | ||
| 50. Chart Preperation - Customize.mp4 | 35.2 MB | ||
| 50. Chart Preperation - Customize.vtt | 3.8 KB | ||
| 50. VBA to control Outlook for mail.mp4 | 57.3 MB | ||
| 50. VBA to control Outlook for mail.vtt | 8 KB | ||
| 51. Conditional Formatting.mp4 | 37.4 MB | ||
| 51. Conditional Formatting.vtt | 3 KB | ||
| 51. Outlook Related Project.mp4 | 49.3 MB | ||
| 51. Outlook Related Project.vtt | 4.1 KB | ||
| 52. Conditional Formatting - Types of Rules.mp4 | 61.8 MB | ||
| 52. Conditional Formatting - Types of Rules.vtt | 5.9 KB | ||
| 52. Create Userform.mp4 | 165.4 MB | ||
| 52. Create Userform.vtt | 15.6 KB | ||
| 53. Conditional Formatting - Apply.mp4 | 145.5 MB | ||
| 53. Conditional Formatting - Apply.vtt | 11.5 KB | ||
| 53. Create Pivot Table with VBA.mp4 | 88.7 MB | ||
| 53. Create Pivot Table with VBA.vtt | 7.6 KB | ||
| 54. Conditional Formatting - Create New Rules.mp4 | 52.7 MB | ||
| 54. Conditional Formatting - Create New Rules.vtt | 4.8 KB | ||
| 54. File System Object in VBA.mp4 | 44.4 MB | ||
| 54. File System Object in VBA.vtt | 5.1 KB | ||
| 55. Conditional Formatting - Mange Rules.mp4 | 47.2 MB | ||
| 55. Conditional Formatting - Mange Rules.vtt | 4.4 KB | ||
| 55. File in FSO.mp4 | 26.1 MB | ||
| 55. File in FSO.vtt | 2.5 KB | ||
| 56. Data Validation.mp4 | 38.3 MB | ||
| 56. Data Validation.vtt | 4.5 KB | ||
| 56. FSO Practical Example.mp4 | 56.1 MB | ||
| 56. FSO Practical Example.vtt | 5.8 KB | ||
| 57. Data Validation - Input message and Error Alert.mp4 | 82.1 MB | ||
| 57. Data Validation - Input message and Error Alert.vtt | 10.7 KB | ||
| 57. Late Binding Technique in Macro.mp4 | 35.6 MB | ||
| 57. Late Binding Technique in Macro.vtt | 4.3 KB | ||
| 58. Advance Math Function.mp4 | 84.3 MB | ||
| 58. Advance Math Function.vtt | 7.1 KB | ||
| 59. Advance Math Function 2.mp4 | 73.3 MB | ||
| 59. Advance Math Function 2.vtt | 6.3 KB | ||
| 6. Cell reference.mp4 | 28.9 MB | ||
| 6. Cell reference.vtt | 4.5 KB | ||
| 6. Creating Report in Access.mp4 | 36.3 MB | ||
| 6. Creating Report in Access.vtt | 2.8 KB | ||
| 6. Formatting through VBA.mp4 | 66.9 MB | ||
| 6. Formatting through VBA.vtt | 6.4 KB | ||
| 60. Using of Wild Card in Math Function.mp4 | 30.2 MB | ||
| 60. Using of Wild Card in Math Function.vtt | 2.7 KB | ||
| 61. Vlookup Function.mp4 | 80.9 MB | ||
| 61. Vlookup Function.vtt | 8.4 KB | ||
| 62. Vlookup with Iferror.mp4 | 49.6 MB | ||
| 62. Vlookup with Iferror.vtt | 4.9 KB | ||
| 63. Vlookup Nesting with If.mp4 | 31.7 MB | ||
| 63. Vlookup Nesting with If.vtt | 2.4 KB | ||
| 64. Hlookup.mp4 | 32.7 MB | ||
| 64. Hlookup.vtt | 2.8 KB | ||
| 65. Match Function.mp4 | 41.4 MB | ||
| 65. Match Function.vtt | 3.5 KB | ||
| 66. Index and match nested.mp4 | 85.6 MB | ||
| 66. Index and match nested.vtt | 8.6 KB | ||
| 67. Vlookup array.mp4 | 47 MB | ||
| 67. Vlookup array.vtt | 4.4 KB | ||
| 68. Vlookup column func trick.mp4 | 41.8 MB | ||
| 68. Vlookup column func trick.vtt | 4.7 KB | ||
| 69. Vlookup TRUE.mp4 | 32.3 MB | ||
| 69. Vlookup TRUE.vtt | 4 KB | ||
| 7. End Command in VBA.mp4 | 59.9 MB | ||
| 7. End Command in VBA.vtt | 5.5 KB | ||
| 7. Math Function in Excel.mp4 | 96.9 MB | ||
| 7. Math Function in Excel.vtt | 13.1 KB | ||
| 7. Query in access.mp4 | 115.6 MB | ||
| 7. Query in access.vtt | 10.9 KB | ||
| 70. Advance VLOOKUP.mp4 | 63.3 MB | ||
| 70. Advance VLOOKUP.vtt | 6.6 KB | ||
| 71. Macro Recording part 1.mp4 | 139.3 MB | ||
| 71. Macro Recording part 1.vtt | 13.6 KB | ||
| 72. Macro Recording part 2.mp4 | 55.9 MB | ||
| 72. Macro Recording part 2.vtt | 5.2 KB | ||
| 73. Macro Recording part 3.mp4 | 26.1 MB | ||
| 73. Macro Recording part 3.vtt | 3.1 KB | ||
| 74. Types of ways to run macros.mp4 | 66.6 MB | ||
| 74. Types of ways to run macros.vtt | 5.4 KB | ||
| 8. Offset in VBA.mp4 | 46.1 MB | ||
| 8. Offset in VBA.vtt | 4.1 KB | ||
| 8. Operators based equation in Excel.mp4 | 56.1 MB | ||
| 8. Operators based equation in Excel.vtt | 8.5 KB | ||
| 8. SQL Queries Part 1.mp4 | 69.5 MB | ||
| 8. SQL Queries Part 1.vtt | 8 KB | ||
| 9. Print related options in Excel Part 1.mp4 | 143.6 MB | ||
| 9. Print related options in Excel Part 1.vtt | 11.7 KB | ||
| 9. SQL Queries part 2.mp4 | 43 MB | ||
| 9. SQL Queries part 2.vtt | 3.7 KB | ||
| 9. Task on Data Entry Automate.mp4 | 12.9 MB | ||
| 9. Task on Data Entry Automate.vtt | 2.4 KB | ||
| Discuss.FreeTutorials.Us.html | 165.7 KB | ||
| FreeCoursesOnline.Me.html | 108.3 KB | ||
| FreeTutorials.Eu.html | 102.2 KB | ||
| How you can help Team-FTU.txt | 307.2 B | ||
| Torrent Downloaded From GloDls.to.txt | 102.4 B | ||
| [TGx]Downloaded from torrentgalaxy.org.txt | 512 B | ||
| ▲ 287 total files | |||
MIS Training - Complete Data Management and Automation Training
Created by : Himanshu Dhar
Last updated : 10/2018
Language: English
Torrent Contains : 287 Files, 3 Folders
Course Source : https://www.udemy.com/mis-professional-excel-macro-access-sql/
What you'll learn
• Expert MIS Level Excel, Macro, Automation, Database and queries knowledge
Requirements
• Basic Computer Knowledge is must
Description
A management information system (MIS) provides organisation with the information they require in an organised manner to take upon management and crucial decisions. MIS tools and knowledge is very important nowadays. There is a very high demand for MIS Professionals in the market and the manpower supply of it is very less because of the obvious reason that the skill-sets required is not a part of any academic curriculum. A professional training in it hence becomes mandatory.
This training will endow every student with the skill sets required to be a successful MIS professional. Our course curriculum comprises of all the important aspects requires in the real world to get the job done in MIS. The student will get the enhance knowledge in Data management, Reporting and Analysis through MS Excel, MS Access & RDBMS. Moreover training will be given on the most demanding technology , which is MACRO -Automation.
Who this course is for?
• MIS Aspirants
• Management Graduates
• Want Data Management Expertise
For More Udemy Free Courses >>> http://www.freetutorials.eu
For more Lynda and other Courses >>> https://www.freecoursesonline.me/
Our Forum for discussion >>> https://discuss.freetutorials.eu/ 
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 1 MB | freecoursewb | 2 years | 1 | 0 |
All Comments