[UDEMY] MIS Professional - Excel + Macro + Access + SQL - [FTU]

seeders: 0
leechers: 0
Added 7 years ago by SunRiseZone in Other

Download Fast Safe Anonymous
movies, software, shows...

Files

[UDEMY] MIS Professional - Excel + Macro + Access + SQL - [FTU] (Size: 7.5 GB)
  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

Description


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/




Related Torrents

torrent name size uploader age seed leech
0