FileMood

Download [ DevCourseWeb.com ] Udemy - Microsoft Excel - from Beginner to Advanced and VBA by IITian

DevCourseWeb com Udemy Microsoft Excel from Beginner to Advanced and VBA by IITian

Name

[ DevCourseWeb.com ] Udemy - Microsoft Excel - from Beginner to Advanced and VBA by IITian

  DOWNLOAD Copy Link

Trouble downloading? see How To

Total Size

3.9 GB

Total Files

271

Last Seen

2025-04-04 23:37

Hash

B8F60E2E8459EFEEDAB5D30160053BA5795594B1

/

Get Bonus Downloads Here.url

0.2 KB

/.../1. Introduction to Excel 2016/

1. Starting Excel 2016.mp4

39.8 MB

1. Starting Excel 2016.srt

1.8 KB

2. Excel 2016 user Interface.mp4

69.6 MB

2. Excel 2016 user Interface.srt

7.8 KB

3. The Excel 2016 Backstage View.mp4

29.0 MB

3. The Excel 2016 Backstage View.srt

4.3 KB

/.../10. Using Charts in Excel 2016/

1. Charts Case Study.mp4

17.7 MB

1. Charts Case Study.srt

1.7 KB

1.1 MSE_Chapter 10_Charts _Case Study.pdf

387.0 KB

2. Column, Bar, Pie, Histogram and Treemaps - Solution.mp4

98.3 MB

2. Column, Bar, Pie, Histogram and Treemaps - Solution.srt

11.4 KB

3. Line Charts and Sparklines - Solution.mp4

49.4 MB

3. Line Charts and Sparklines - Solution.srt

4.1 KB

4. 3D Maps in Excel - Solution.mp4

64.6 MB

4. 3D Maps in Excel - Solution.srt

5.8 KB

5. Assignment for Section 10.html

0.2 KB

/.../11. Pivot Table/

1. Pivot Table Case Study.mp4

11.8 MB

1. Pivot Table Case Study.srt

1.4 KB

1.1 MSE_Chapter 11_PivotTable_Case Study.pdf

365.8 KB

2. Pivot Table Case Study Solution - Part 1.mp4

95.9 MB

2. Pivot Table Case Study Solution - Part 1.srt

11.1 KB

3. Pivot Table Case Study Solution - Part 2.mp4

43.8 MB

3. Pivot Table Case Study Solution - Part 2.srt

5.3 KB

4. Pivot Table Case Study Solution - Part 3.mp4

25.6 MB

4. Pivot Table Case Study Solution - Part 3.srt

2.6 KB

5. Assignment for Section 11.html

0.2 KB

/.../12. What If Analysis/

1. What If Analysis Case Study.mp4

17.1 MB

1. What If Analysis Case Study.srt

2.2 KB

1.1 MSE_Chapter 12_What_If_Analysis_Case Study.pdf

554.9 KB

2. What If Analysis Case Study - Solution.mp4

69.3 MB

2. What If Analysis Case Study - Solution.srt

8.5 KB

3. Assignment for Section 12.html

0.2 KB

/.../13. Data Analysis and Validation/

1. Importing Data in Excel 2016.mp4

19.8 MB

1. Importing Data in Excel 2016.srt

2.4 KB

2. Formula Auditing in Excel.mp4

71.0 MB

2. Formula Auditing in Excel.srt

7.9 KB

3. Converting Text to Columns.mp4

21.3 MB

3. Converting Text to Columns.srt

3.1 KB

4. Using Power Pivot to Import Data in Excel 2016.mp4

36.8 MB

4. Using Power Pivot to Import Data in Excel 2016.srt

6.2 KB

5. Data Analysis and Validation Case Study.mp4

15.4 MB

5. Data Analysis and Validation Case Study.srt

1.9 KB

5.1 MSE_Chapter 13_Data Analysis and Validation_Case Study.pdf

354.9 KB

6. Data Analysis and Validation Case Study Solution - 1.mp4

78.8 MB

6. Data Analysis and Validation Case Study Solution - 1.srt

7.6 KB

7. Data Analysis and Validation Case Study Solution - 2.mp4

23.6 MB

7. Data Analysis and Validation Case Study Solution - 2.srt

1.9 KB

8. Assignment for Section 13.html

0.2 KB

/.../14. Printing Excel Workbooks and Sheets/

1. Printing Case Study.mp4

12.2 MB

1. Printing Case Study.srt

1.0 KB

1.1 MSE_Chapter 14_Printing.pdf

1.1 MB

2. Printing Case Study Solution.mp4

89.1 MB

2. Printing Case Study Solution.srt

7.0 KB

3. Assignment for Section 14.html

0.2 KB

/15. Macros/

1. Macros Case Study.mp4

10.3 MB

1. Macros Case Study.srt

0.9 KB

1.1 MSE_Chapter 15_Macros_Case Study.pdf

345.2 KB

2. Macros Case Study Solution.mp4

53.2 MB

2. Macros Case Study Solution.srt

4.7 KB

3. Assignment for Section 15.html

0.2 KB

/.../16. Managing Excel Files/

1. Saving and Sharing Workbooks in Excel.mp4

43.1 MB

1. Saving and Sharing Workbooks in Excel.srt

4.1 KB

2. Splitting A Worksheet.mp4

34.2 MB

2. Splitting A Worksheet.srt

2.3 KB

3. Protecting Workbook and Worksheets.mp4

54.3 MB

3. Protecting Workbook and Worksheets.srt

4.6 KB

/.../17. Visual Basic for Applications (VBA)/

1. Visual Basic For Applications.mp4

18.5 MB

1. Visual Basic For Applications.srt

2.2 KB

2. Procedures and Variables.mp4

28.2 MB

2. Procedures and Variables.srt

4.4 KB

3. Loops And Conditional Logic.mp4

40.0 MB

3. Loops And Conditional Logic.srt

3.6 KB

/.../18. VBA Case Study 1/

1. Case Study Solution - Record the Macro.mp4

42.6 MB

1. Case Study Solution - Record the Macro.srt

3.1 KB

1.1 MSE_Chapter 17_VBA_Case Study1_Solution.xlsm

34.4 KB

1.2 MSE_Chapter 17_VBA_Case Study1.xlsx

22.2 KB

1.3 VBA_Case Study-1.pdf

487.2 KB

2. Case Study Solution - Understanding Macro.mp4

24.1 MB

2. Case Study Solution - Understanding Macro.srt

2.1 KB

3. Case Study Solution - Editing the Macro.mp4

45.2 MB

3. Case Study Solution - Editing the Macro.srt

4.5 KB

4. Case Study Solution - Worksheets Object.mp4

36.4 MB

4. Case Study Solution - Worksheets Object.srt

4.2 KB

5. Case Study Solution - Accepting User Input while Your Macro is Running.mp4

42.3 MB

5. Case Study Solution - Accepting User Input while Your Macro is Running.srt

4.0 KB

/.../19. VBA Case Study 2/

1. Case Study Description.mp4

14.2 MB

1. Case Study Description.srt

1.3 KB

1.1 VBA_Case Study-2.pdf

546.6 KB

2. Case Study Solution - Creating a User Form.mp4

19.2 MB

2. Case Study Solution - Creating a User Form.srt

1.9 KB

3. Case Study Solution - Adding Controls to Form.mp4

22.1 MB

3. Case Study Solution - Adding Controls to Form.srt

2.4 KB

4. Case Study Solution - Editing Properties of Form Controls.mp4

30.5 MB

4. Case Study Solution - Editing Properties of Form Controls.srt

2.9 KB

5. Case Study Solution - Adding Items to A ComboBox.mp4

56.7 MB

5. Case Study Solution - Adding Items to A ComboBox.srt

5.6 KB

6. Case Study Solution - Change Event for ComboBox Control.mp4

25.6 MB

6. Case Study Solution - Change Event for ComboBox Control.srt

2.6 KB

7. Case Study Solution - Adding code to a CommandButton control.mp4

20.0 MB

7. Case Study Solution - Adding code to a CommandButton control.srt

1.9 KB

8. Case Study Solution - Setting TextBox Control Value.mp4

37.1 MB

8. Case Study Solution - Setting TextBox Control Value.srt

20.0 MB

9. Case Study Solution - Adding Code to Open Event of Workbook.mp4

30.6 MB

9. Case Study Solution - Adding Code to Open Event of Workbook.srt

2.7 KB

9.1 MSE_Chapter 17_VBA_Case Study2_Solution.xlsm

44.7 KB

/.../2. Working with Workbook and Worksheets/

1. Workbooks and Worksheets.mp4

23.5 MB

1. Workbooks and Worksheets.srt

2.9 KB

1.2 Mastering Excel 2016 with Assignments and Case Studies - paperback.pdf

25.4 MB

2. Editing Worksheets.mp4

44.1 MB

2. Editing Worksheets.srt

4.2 KB

3. Entering Data.mp4

32.1 MB

3. Entering Data.srt

3.2 KB

4. Naming Cell Range.mp4

25.9 MB

4. Naming Cell Range.srt

2.4 KB

5. Handling Worksheets.mp4

33.1 MB

5. Handling Worksheets.srt

3.6 KB

6. Assignments for the section.html

0.2 KB

/.../2. Working with Workbook and Worksheets/Data Files/

Chapter 13 Product Names.accdb

417.8 KB

Chapter 7_Logo image.jpg

5.7 KB

MSE_Chapter 10_Charts _Case Study.xlsx

23.9 KB

MSE_Chapter 10_Charts _Case Study_Solution.xlsx

200.9 KB

MSE_Chapter 11_PivotTable_Case Study.xlsx

19.5 KB

MSE_Chapter 11_PivotTable_Case Study_Solution.xlsx

26.8 KB

MSE_Chapter 12_Goal Seek Case Study.xlsx

11.7 KB

MSE_Chapter 12_Goal Seek Case Study_Solution.xlsx

13.9 KB

MSE_Chapter 13_Data Analysis and Validation_Case Study.xlsx

15.8 KB

MSE_Chapter 13_Data Analysis and Validation_Case Study_Solution.xlsx

25.0 KB

MSE_Chapter 14_Printing_Case_Study.xlsx

18.7 KB

MSE_Chapter 15_Macros_Case Study.xlsx

25.9 KB

MSE_Chapter 15_Macros_Case Study_Solution.xlsm

34.6 KB

MSE_Chapter 6_Date and Time Formulas Case Study.xlsx

18.1 KB

MSE_Chapter 6_Date and Time Formulas Case Study_Solution.xlsx

18.1 KB

MSE_Chapter 6_Financial Formulas Case Study.xlsx

10.1 KB

MSE_Chapter 6_Financial Formulas Case Study_Solution.xlsx

10.5 KB

MSE_Chapter 6_Information formulas_Case Study.xlsx

21.2 KB

MSE_Chapter 6_Information formulas_Case Study_Solution.xlsx

23.1 KB

MSE_Chapter 6_Logical Formulas Case Study.xlsx

19.7 KB

MSE_Chapter 6_Logical Formulas Case Study_Solution.xlsx

19.8 KB

MSE_Chapter 6_Math Formulas Case Study.xlsx

17.2 KB

MSE_Chapter 6_Math Formulas Case Study_Solution.xlsx

17.0 KB

MSE_Chapter 6_Statistical formulas_Case Study.xlsx

20.0 KB

MSE_Chapter 6_Statistical formulas_Case Study_Solution.xlsx

21.8 KB

MSE_Chapter 6_Text Formulas Case Study.xlsx

9.8 KB

MSE_Chapter 6_Text Formulas Case Study_Solution.xlsx

10.8 KB

MSE_Chapter 7_New Hire On Boarding.xlsx

8.5 KB

MSE_Chapter 7_New Hire On Boarding_Solution.xlsx

658.5 KB

MSE_Chapter 8_Lookup and Reference Formulas_Case Study.xlsx

10.6 KB

MSE_Chapter 8_Lookup and Reference Formulas_Case Study_Solution.xlsx

10.8 KB

MSE_Chapter 9_Excel_Tables_Case Study_Solution.xlsx

26.8 KB

MSE_Chapter7_Mobile Phone Retail Store.pptx

628.5 KB

ManipulatingData.xlsx

13.1 KB

MonthlySalesData.xlsx

15.5 KB

Sales Channel Analysis.pdf

514.8 KB

SalesDataFormatting.xlsx

17.5 KB

SalesDataManaging.xlsx

18.1 KB

/.../20. VBA Case Study 3/

1. VBA Case Study 3 Description.mp4

26.3 MB

1. VBA Case Study 3 Description.srt

2.2 KB

1.1 VBA_Case Study-3.pdf

400.4 KB

2. Case Study Solution - Creating a Custom Excel Function.mp4

33.2 MB

2. Case Study Solution - Creating a Custom Excel Function.srt

2.8 KB

3. Case Study Solution - Adding Conditional Logic to Function.mp4

35.2 MB

3. Case Study Solution - Adding Conditional Logic to Function.srt

2.7 KB

4. Case Study Solution - Adding Help to Custom User Function.mp4

25.4 MB

4. Case Study Solution - Adding Help to Custom User Function.srt

2.2 KB

5. Case Study Solution - Using Defined Function within Excel Worksheet.mp4

29.5 MB

5. Case Study Solution - Using Defined Function within Excel Worksheet.srt

1.9 KB

5.1 MSE_Chapter 17_VBA_Case Study3_Solution.xlsm

45.2 KB

/.../21. VBA Case Study 4/

1. Case Study 4 Description.mp4

18.1 MB

1. Case Study 4 Description.srt

1.4 KB

1.1 MSE_Chapter 17_VBA_Case Study4.xlsx

24.3 KB

1.2 VBA_Case Study-4.pdf

392.6 KB

2. Case Study Solution - Automate the SUM Function for One Worksheet.mp4

69.3 MB

2. Case Study Solution - Automate the SUM Function for One Worksheet.srt

6.2 KB

3. Case Study Solution - Automate the SUM Function for all Worksheets.mp4

47.9 MB

3. Case Study Solution - Automate the SUM Function for all Worksheets.srt

5.6 KB

/.../22. Practice assignment for VBA/

1. Assignment for VBA.html

0.2 KB

/.../3. Introduction to Microsoft Excel Tables, Formulas and References/

1. Introduction to Tables in Excel 2016.mp4

28.9 MB

1. Introduction to Tables in Excel 2016.srt

3.0 KB

2. Excel 2016 Functions.mp4

49.0 MB

2. Excel 2016 Functions.srt

4.9 KB

3. Operators in Excel 2016.mp4

18.5 MB

3. Operators in Excel 2016.srt

1.6 KB

4. Cell Referencing in Microsoft Excel 2016.mp4

33.3 MB

4. Cell Referencing in Microsoft Excel 2016.srt

3.3 KB

5. Using Paste Preview to Transpose Rows into Columns.mp4

29.6 MB

5. Using Paste Preview to Transpose Rows into Columns.srt

2.6 KB

6. Assignment for Section 3.html

0.2 KB

/.../4. Formatting Data in Excel 2016/

1. Formatting Data in Excel 2016 - 1.mp4

45.7 MB

1. Formatting Data in Excel 2016 - 1.srt

4.2 KB

2. Formatting Data in Excel 2016 - 2.mp4

35.7 MB

2. Formatting Data in Excel 2016 - 2.srt

3.1 KB

3. Formatting Numbers in Excel 2016.mp4

66.1 MB

3. Formatting Numbers in Excel 2016.srt

5.5 KB

4. Text Rotation and Other Formatting Techniques.mp4

47.1 MB

4. Text Rotation and Other Formatting Techniques.srt

3.9 KB

5. Practice assignment for section 4.html

0.2 KB

/.../5. Managing Your Data in Excel 2016/

1. Using Named Ranges and Sorting Data in Excel 2016.mp4

52.5 MB

1. Using Named Ranges and Sorting Data in Excel 2016.srt

4.3 KB

2. Filtering Data in Excel 2016 Worksheet.mp4

32.8 MB

2. Filtering Data in Excel 2016 Worksheet.srt

2.9 KB

3. Using Comments to explain your data in Excel 2016.mp4

24.6 MB

3. Using Comments to explain your data in Excel 2016.srt

2.4 KB

4. Finding and Replacing Data in your Worksheet.mp4

34.4 MB

4. Finding and Replacing Data in your Worksheet.srt

3.1 KB

5. Tracking Changes to Your Worksheet in Excel 2016.mp4

57.7 MB

5. Tracking Changes to Your Worksheet in Excel 2016.srt

4.6 KB

6. Practice assignment for section 5.html

0.2 KB

/.../6. Formulas in Excel/

1. Text Formulas in Excel.mp4

13.9 MB

1. Text Formulas in Excel.srt

2.0 KB

1.1 MSE_Chapter 6_Text_Formulas_Case Study.pdf

361.3 KB

10. Mathematical Formulas Case Study - Solution.mp4

138.1 MB

10. Mathematical Formulas Case Study - Solution.srt

10.3 KB

11. Statistical Formulas Case Study.mp4

19.0 MB

11. Statistical Formulas Case Study.srt

2.1 KB

11.1 MSE_Chapter 6_Statistical Formulas_Case Study.pdf

379.3 KB

12. Statistical Formulas Case Study - Solution.mp4

96.0 MB

12. Statistical Formulas Case Study - Solution.srt

10.6 KB

13. Financial Formulas Case Study.mp4

21.4 MB

13. Financial Formulas Case Study.srt

2.7 KB

13.1 MSE_Chapter 6_Financial Formulas_Case Study.pdf

543.1 KB

14. Financial Formulas Case Study - Solution.mp4

41.3 MB

14. Financial Formulas Case Study - Solution.srt

5.0 KB

15. Practice Assignment for Section 6.html

0.2 KB

2. Text Formulas Case Study Solution.mp4

64.2 MB

2. Text Formulas Case Study Solution.srt

8.7 KB

3. Date and Time Formulas in Excel 2016.mp4

13.8 MB

3. Date and Time Formulas in Excel 2016.srt

1.3 KB

3.1 MSE_Chapter 6_ Date and Time Formulas_Case Study.pdf

367.6 KB

4. Date and Time Formulas in Excel 2016 - Case Study Solution.mp4

34.4 MB

4. Date and Time Formulas in Excel 2016 - Case Study Solution.srt

3.4 KB

5. Logical Formulas in Excel 2016.mp4

21.6 MB

5. Logical Formulas in Excel 2016.srt

1.9 KB

5.1 MSE_Chapter 6_Logical Formulas_Case Study.pdf

350.1 KB

6. Solution to Logical Formulas Case Study.mp4

50.8 MB

6. Solution to Logical Formulas Case Study.srt

5.0 KB

7. Information Formulas in Excel 2016 - Case Study.mp4

8.3 MB

7. Information Formulas in Excel 2016 - Case Study.srt

0.9 KB

7.1 MSE_Chapter 6_Information Formulas_Case Study.pdf

371.3 KB

8. Information Formulas Case Study - Solution.mp4

64.1 MB

8. Information Formulas Case Study - Solution.srt

6.4 KB

9. Mathematical Formulas Case Study.mp4

23.9 MB

9. Mathematical Formulas Case Study.srt

2.2 KB

9.1 MSE_Chapter 6_Mathematical and Statistical_Formulas.pdf

970.8 KB

/.../7. Inserting and Formatting Objects Some/

1. Inserting Objects Case Study.mp4

10.3 MB

1. Inserting Objects Case Study.srt

1.0 KB

1.1 MSE_Chapter 7_Inserting Objects_Case_Study.pdf

368.2 KB

2. Inserting Objects Case Study - Solution.mp4

45.3 MB

2. Inserting Objects Case Study - Solution.srt

4.1 KB

3. Practice Assignment for Section 7.html

0.2 KB

/.../8. Lookup and Reference Functions/

1. LOOKUP Functions.mp4

59.0 MB

1. LOOKUP Functions.srt

5.9 KB

2. Transpose Function.mp4

21.6 MB

2. Transpose Function.srt

2.6 KB

3. Comparing Lists.mp4

51.4 MB

3. Comparing Lists.srt

6.5 KB

4. Lookup and Reference Formulas Case Study.mp4

13.7 MB

4. Lookup and Reference Formulas Case Study.srt

1.3 KB

4.1 MSE_Chapter 8_Lookup and Reference Formulas_Case Study.pdf

372.7 KB

5. Lookup and Reference Formulas Case Study - Solution.mp4

81.8 MB

5. Lookup and Reference Formulas Case Study - Solution.srt

8.1 KB

6. Assignment for Section 8.html

0.2 KB

/.../9. Advanced Excel Tables/

1. Excel Tables Case Study.mp4

12.4 MB

1. Excel Tables Case Study.srt

1.0 KB

1.1 MSE_Chapter 9_Excel_Tables_Case_Study.pdf

449.1 KB

2. Excel Table Case Study - Solution.mp4

114.2 MB

2. Excel Table Case Study - Solution.srt

8.3 KB

3. Printing Excel Tables.mp4

24.2 MB

3. Printing Excel Tables.srt

20.0 MB

4. Assignment for Section 9.html

0.2 KB

/~Get Your Files Here !/

Bonus Resources.txt

0.4 KB

 

Total files 271


Copyright © 2025 FileMood.com