[UDEMY] MIS Professional - Excel + Macro + Access + SQL - [FTU]
- Category Other
- Type Tutorials
- Language English
- Total size 7.5 GB
- Uploaded By SunRiseZone
- Downloads 1275
- Last checked 5 days ago
- Date uploaded 7 years ago
- Seeders 0
- Leechers 0
Infohash : E0F59BCBBD12BA32BD718ABC82BCDD4E5719ABE8
MIS Training - Complete Data Management and Automation Training
Created by : Himanshu Dhar
Last updated : 10/2018
Language: English
[b]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/

Files:
[FreeTutorials.Eu] [UDEMY] MIS Professional - Excel + Macro + Access + SQL - [FTU] 1. MS Excel- 10. Print related options in Excel Part 2.mp4 (74.4 MB)
- 10. Print related options in Excel Part 2.vtt (8.4 KB)
- 1.1 Excel Excercise.zip.zip (1.3 MB)
- 11. Text Function - Upper, Lower, Proper, Trim.mp4 (66.7 MB)
- 11. Text Function - Upper, Lower, Proper, Trim.vtt (5.9 KB)
- 12. Text Function - Right, Left.mp4 (45.3 MB)
- 12. Text Function - Right, Left.vtt (3.8 KB)
- 13. Text Function - Find and task.mp4 (71.1 MB)
- 13. Text Function - Find and task.vtt (5.6 KB)
- 14. Text Function - Solution and Nested Left.mp4 (62.9 MB)
- 14. Text Function - Solution and Nested Left.vtt (5.2 KB)
- 15. Text Function - Find and Left Nesting.mp4 (34.3 MB)
- 15. Text Function - Find and Left Nesting.vtt (2.7 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)
- 18. Text Function - Concatenate.mp4 (33.3 MB)
- 18. Text Function - Concatenate.vtt (3.4 KB)
- 19. Text Function - Concatenate task and solution.mp4 (20.8 MB)
- 19. Text Function - Concatenate task and solution.vtt (2.0 KB)
- 1. Excel structure.mp4 (131.5 MB)
- 1. Excel structure.vtt (7.9 KB)
- 20. Text Function - Replace.mp4 (53.5 MB)
- 20. Text Function - Replace.vtt (4.4 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)
- 23. Text Function - Len, Rept, Exact, search.mp4 (30.4 MB)
- 23. Text Function - Len, Rept, Exact, search.vtt (2.8 KB)
- 24. Text to column.mp4 (95.8 MB)
- 24. Text to column.vtt (8.3 KB)
- 25. Workbook protect.mp4 (33.4 MB)
- 25. Workbook protect.vtt (4.0 KB)
- 26. Protect sheet.mp4 (58.2 MB)
- 26. Protect sheet.vtt (7.5 KB)
- 27. Hide Formulas and unlocked Cell.mp4 (49.2 MB)
- 27. Hide Formulas and unlocked Cell.vtt (4.0 KB)
- 28. Protect File with password.mp4 (23.7 MB)
- 28. Protect File with password.vtt (2.1 KB)
- 29. If Function - Logical Test.mp4 (72.3 MB)
- 29. If Function - Logical Test.vtt (8.1 KB)
- 2. Cell properties.mp4 (30.2 MB)
- 2. Cell properties.vtt (3.1 KB)
- 30. If Function - with Equation and task.mp4 (28.5 MB)
- 30. If Function - with Equation and task.vtt (2.6 KB)
- 31. If Function - Nested If.mp4 (37.9 MB)
- 31. If Function - Nested If.vtt (3.6 KB)
- 32. If Function - advance.mp4 (43.9 MB)
- 32. If Function - advance.vtt (4.4 KB)
- 33. If Function - advance - 2.mp4 (47.0 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)
- 35. AND, OR, IF Nested.mp4 (61.9 MB)
- 35. AND, OR, IF Nested.vtt (4.5 KB)
- 36. AND, OR Advance.mp4 (20.3 MB)
- 36. AND, OR Advance.vtt (2.5 KB)
- 37. Pivot Table - Intro.mp4 (59.0 MB)
- 37. Pivot Table - Intro.vtt (5.6 KB)
- 38. Pivot Table - Manage Field Area.mp4 (70.2 MB)
- 38. Pivot Table - Manage Field Area.vtt (7.1 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)
- 3. Autofill value and text.mp4 (29.1 MB)
- 3. Autofill value and text.vtt (5.0 KB)
- 40. Pivot Table - Slicer and Dublicate Pivot.mp4 (72.4 MB)
- 40. Pivot Table - Slicer and Dublicate Pivot.vtt (6.9 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.0 KB)
- 42. Pivot Table - Insert Calculated Field.mp4 (35.1 MB)
- 42. Pivot Table - Insert Calculated Field.vtt (3.2 KB)
- 43. Goal seek.mp4 (54.5 MB)
- 43. Goal seek.vtt (7.3 KB)
- 44. Scenario manager.mp4 (52.6 MB)
- 44. Scenario manager.vtt (6.2 KB)
- 45. PMT function - EMI calculator.mp4 (36.0 MB)
- 45. PMT function - EMI calculator.vtt (4.7 KB)
- 46. Data table - Create Loan Table.mp4 (88.7 MB)
- 46. Data table - Create Loan Table.vtt (6.8 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)
- 49. Chart Preperation - Advance.mp4 (47.4 MB)
- 49. Chart Preperation - Advance.vtt (5.1 KB)
- 4. Autofill date.mp4 (19.9 MB)
- 4. Autofill date.vtt (2.5 KB)
- 50. Chart Preperation - Customize.mp4 (35.2 MB)
- 50. Chart Preperation - Customize.vtt (3.8 KB)
- 51. Conditional Formatting.mp4 (37.4 MB)
- 51. Conditional Formatting.vtt (3.0 KB)
- 52. Conditional Formatting - Types of Rules.mp4 (61.8 MB)
- 52. Conditional Formatting - Types of Rules.vtt (5.9 KB)
- 53. Conditional Formatting - Apply.mp4 (145.5 MB)
- 53. Conditional Formatting - Apply.vtt (11.5 KB)
- 54. Conditional Formatting - Create New Rules.mp4 (52.7 MB)
- 54. Conditional Formatting - Create New Rules.vtt (4.8 KB)
- 55. Conditional Formatting - Mange Rules.mp4 (47.2 MB)
- 55. Conditional Formatting - Mange Rules.vtt (4.4 KB)
- 56. Data Validation.mp4 (38.3 MB)
- 56. Data Validation.vtt (4.5 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)
- 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)
- 5. Autofill Adv tools.mp4 (36.2 MB)
- 5. Autofill Adv tools.vtt (4.3 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.0 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.0 KB)
- 6. Cell reference.mp4 (28.9 MB)
- 6. Cell reference.vtt (4.5 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)
- 7. Math Function in Excel.mp4 (96.9 MB)
- 7. Math Function in Excel.vtt (13.1 KB)
- 8. Operators based equation in Excel.mp4 (56.1 MB)
- 8. Operators based equation in Excel.vtt (8.5 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)
- 1. Access Intro.mp4 (19.4 MB)
- 1. Access Intro.vtt (5.6 KB)
- 2. Create table in MS Access.mp4 (99.9 MB)
- 2. Create table in MS Access.vtt (13.8 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)
- 4. Create form from table.mp4 (30.7 MB)
- 4. Create form from table.vtt (4.5 KB)
- 5. Create Blank Form in Access.mp4 (184.0 MB)
- 5. Create Blank Form in Access.vtt (12.7 KB)
- 6. Creating Report in Access.mp4 (36.3 MB)
- 6. Creating Report in Access.vtt (2.8 KB)
- 7. Query in access.mp4 (115.6 MB)
- 7. Query in access.vtt (10.9 KB)
- 8. SQL Queries Part 1.mp4 (69.5 MB)
- 8. SQL Queries Part 1.vtt (8.0 KB)
- 9. SQL Queries part 2.mp4 (43.0 MB)
- 9. SQL Queries part 2.vtt (3.7 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)
- 12. Methods related to sheets and its properties.mp4 (125.0 MB)
- 12. Methods related to sheets and its properties.vtt (9.6 KB)
- 13. Sheet related task.mp4 (15.1 MB)
- 13. Sheet related task.vtt (1.8 KB)
- 14. Sheet Related Task Solution.mp4 (26.9 MB)
- 14. Sheet Related Task Solution.vtt (3.4 KB)
- 15. Methods to Refer to Workbooks.mp4 (25.0 MB)
- 15. Methods to Refer to Workbooks.vtt (2.5 KB)
- 16. Methods related to workbook.mp4 (46.7 MB)
- 16. Methods related to workbook.vtt (2.9 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)
- 19. Data Types in Variable.mp4 (86.4 MB)
- 19. Data Types in Variable.vtt (6.1 KB)
- 1. Introduction to Macro.mp4 (72.2 MB)
- 1. Introduction to Macro.vtt (8.6 KB)
- 20. Object variable related project.mp4 (23.4 MB)
- 20. Object variable related project.vtt (2.5 KB)
- 21. Solution for the task - Object Variable.mp4 (30.8 MB)
- 21. Solution for the task - Object Variable.vtt (3.2 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)
- 24. Project related to IF.mp4 (13.3 MB)
- 24. Project related to IF.vtt (1.7 KB)
- 25. Solution of IF task.mp4 (30.6 MB)
- 25. Solution of IF task.vtt (2.0 KB)
- 26. Select Case.mp4 (24.1 MB)
- 26. Select Case.vtt (3.3 KB)
- 27. Select Case 2nd Scenario.mp4 (40.3 MB)
- 27. Select Case 2nd Scenario.vtt (3.2 KB)
- 28. Select Case 3rd Scenario.mp4 (86.2 MB)
- 28. Select Case 3rd Scenario.vtt (6.5 KB)
- 29. Understanding Loop.mp4 (69.4 MB)
- 29. Understanding Loop.vtt (5.6 KB)
- 2. Start Macro Programming.mp4 (27.8 MB)
- 2. Start Macro Programming.vtt (7.3 KB)
- 30. Loop Practical example.mp4 (54.6 MB)
- 30. Loop Practical example.vtt (4.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)
- 33. For Loopcounter.mp4 (50.8 MB)
- 33. For Loopcounter.vtt (5.4 KB)
- 34. For Loopcounter Step importance.mp4 (34.9 MB)
- 34. For Loopcounter Step importance.vtt (3.1 KB)
- 35. For Loopcounter Step Example 2.mp4 (52.1 MB)
- 35. For Loopcounter Step Example 2.vtt (5.4 KB)
- 36. For Each Loop.mp4 (42.9 MB)
- 36. For Each Loop.vtt (4.0 KB)
- 37. For Each Example.mp4 (34.6 MB)
- 37. For Each Example.vtt (3.1 KB)
- 38. For Each Task Solution.mp4 (26.1 MB)
- 38. For Each Task Solution.vtt (1.8 KB)
- 39. Loop Related Task.mp4 (15.2 MB)
- 39. Loop Related Task.vtt (1.4 KB)
- 3. Macro Task Basic.mp4 (23.6 MB)
- 3. Macro Task Basic.vtt (3.3 KB)
- 40. Loop Solution and Futher Task.mp4 (55.2 MB)
- 40. Loop Solution and Futher Task.vtt (4.9 KB)
- 41. Loop Related Project.mp4 (153.6 MB)
- 41. Loop Related Project.vtt (10.0 KB)
- 42. How to create Events.mp4 (78.7 MB)
- 42. How to create Events.vtt (8.6 KB)
- 43. Events Example and task.mp4 (23.0 MB)
- 43. Events Example and task.vtt (2.8 KB)
- 44. Event Task Solution.mp4 (16.0 MB)
- 44. Event Task Solution.vtt (2.3 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.0 KB)
- 47. Function Related Task.mp4 (13.5 MB)
- 47. Function Related Task.vtt (1.5 KB)
- 48. Function Related task Solution.mp4 (13.7 MB)
- 48. Function Related task Solution.vtt (1.3 KB)
- 49. Create Optional Parameter in Function.mp4 (29.7 MB)
- 49. Create Optional Parameter in Function.vtt (3.9 KB)
- 4. Methods to Refer Range.mp4 (58.6 MB)
- 4. Methods to Refer Range.vtt (6.2 KB)
- 50. VBA to control Outlook for mail.mp4 (57.3 MB)
- 50. VBA to control Outlook for mail.vtt (8.0 KB)
- 51. Outlook Related Project.mp4 (49.3 MB)
- 51. Outlook Related Project.vtt (4.1 KB)
- 52. Create Userform.mp4 (165.4 MB)
- 52. Create Userform.vtt (15.6 KB)
- 53. Create Pivot Table with VBA.mp4 (88.7 MB)
- 53. Create Pivot Table with VBA.vtt (7.6 KB)
- 54. File System Object in VBA.mp4 (44.4 MB)
- 54. File System Object in VBA.vtt (5.1 KB)
- 55. File in FSO.mp4 (26.1 MB)
- 55. File in FSO.vtt (2.5 KB)
- 56. FSO Practical Example.mp4 (56.1 MB)
- 56. FSO Practical Example.vtt (5.8 KB)
- 57. Late Binding Technique in Macro.mp4 (35.6 MB)
- 57. Late Binding Technique in Macro.vtt (4.3 KB)
- 5. Selection of multiple cell.mp4 (60.0 MB)
- 5. Selection of multiple cell.vtt (5.2 KB)
- 6. Formatting through VBA.mp4 (66.9 MB)
- 6. Formatting through VBA.vtt (6.4 KB)
- 7. End Command in VBA.mp4 (59.9 MB)
- 7. End Command in VBA.vtt (5.5 KB)
- 8. Offset in VBA.mp4 (46.1 MB)
- 8. Offset in VBA.vtt (4.1 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 (0.3 KB)
- [TGx]Downloaded from torrentgalaxy.org.txt (0.5 KB)
- Torrent Downloaded From GloDls.to.txt (0.1 KB)
Comments
Code:
- https://tracker.fastdownload.xyz:443/announce
- udp://tw.opentracker.ga:36920/announce
- udp://tracker.tiny-vps.com:6969/announce
- https://seeders-paradise.org:443/announce
- udp://open.stealth.si:80/announce
- udp://hk1.opentracker.ga:6969/announce
- udp://open.stealth.si:80/announce
- https://opentracker.xyz:443/announce
- https://t.quic.ws:443/announce
- https://tracker.fastdownload.xyz:443/announce
- udp://tracker.opentrackr.org:1337/announce
- udp://ipv4.tracker.harry.lu:80/announce
- udp://tracker.coppersurfer.tk:6969/announce
- udp://zephir.monocul.us:6969/announce
- udp://open.demonii.si:1337/announce