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-25 23:29
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