Microsoft Excel – from Beginner to Advanced & VBA by IITian

سرفصل های دوره

Master Excel 2016, 2013 and 2010 - Formulas, Functions, Charts, LOOKUP, Pivot Table, What-If Analysis, Macros & VBA

1. Introduction to Excel 2016

1. Starting Excel 2016

2. Excel 2016 user Interface

3. The Excel 2016 Backstage View

2. Working with Workbook and Worksheets

1.1 Data Files.zip

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

1. Workbooks and Worksheets

2. Editing Worksheets

3. Entering Data

4. Naming Cell Range

5. Handling Worksheets

6. Assignments for the section.html

3. Introduction to Microsoft Excel Tables, Formulas and References

1. Introduction to Tables in Excel 2016

2. Excel 2016 Functions

3. Operators in Excel 2016

4. Cell Referencing in Microsoft Excel 2016

5. Using Paste Preview to Transpose Rows into Columns

6. Assignment for Section 3.html

4. Formatting Data in Excel 2016

1. Formatting Data in Excel 2016 - 1

2. Formatting Data in Excel 2016 - 2

3. Formatting Numbers in Excel 2016

4. Text Rotation and Other Formatting Techniques

5. Practice assignment for section 4.html

5. Managing Your Data in Excel 2016

1. Using Named Ranges and Sorting Data in Excel 2016

2. Filtering Data in Excel 2016 Worksheet

3. Using Comments to explain your data in Excel 2016

4. Finding and Replacing Data in your Worksheet

5. Tracking Changes to Your Worksheet in Excel 2016

6. Practice assignment for section 5.html

6. Formulas in Excel

1.1 MSE Chapter 6 Text Formulas Case Study.pdf

1. Text Formulas in Excel

2. Text Formulas Case Study Solution

3.1 MSE Chapter 6 Date and Time Formulas Case Study.pdf

3. Date and Time Formulas in Excel 2016

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

5.1 MSE Chapter 6 Logical Formulas Case Study.pdf

5. Logical Formulas in Excel 2016

6. Solution to Logical Formulas Case Study

7.1 MSE Chapter 6 Information Formulas Case Study.pdf

7. Information Formulas in Excel 2016 - Case Study

8. Information Formulas Case Study - Solution

9.1 MSE Chapter 6 Mathematical and Statistical Formulas.pdf

9. Mathematical Formulas Case Study

10. Mathematical Formulas Case Study - Solution

11.1 MSE Chapter 6 Statistical Formulas Case Study.pdf

11. Statistical Formulas Case Study

12. Statistical Formulas Case Study - Solution

13.1 MSE Chapter 6 Financial Formulas Case Study.pdf

13. Financial Formulas Case Study

14. Financial Formulas Case Study - Solution

15. Practice Assignment for Section 6.html

7. Inserting and Formatting Objects Some

1.1 MSE Chapter 7 Inserting Objects Case Study.pdf

1. Inserting Objects Case Study

2. Inserting Objects Case Study - Solution

3. Practice Assignment for Section 7.html

8. Lookup and Reference Functions

1. LOOKUP Functions

2. Transpose Function

3. Comparing Lists

4.1 MSE Chapter 8 Lookup and Reference Formulas Case Study.pdf

4. Lookup and Reference Formulas Case Study

5. Lookup and Reference Formulas Case Study - Solution

6. Assignment for Section 8.html

9. Advanced Excel Tables

1.1 MSE Chapter 9 Excel Tables Case Study.pdf

1. Excel Tables Case Study

2. Excel Table Case Study - Solution

3. Printing Excel Tables

4. Assignment for Section 9.html

10. Using Charts in Excel 2016

1.1 MSE Chapter 10 Charts Case Study.pdf

1. Charts Case Study

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

3. Line Charts and Sparklines - Solution

4. 3D Maps in Excel - Solution

5. Assignment for Section 10.html

11. Pivot Table

1.1 MSE Chapter 11 PivotTable Case Study.pdf

1. Pivot Table Case Study

2. Pivot Table Case Study Solution - Part 1

3. Pivot Table Case Study Solution - Part 2

4. Pivot Table Case Study Solution - Part 3

5. Assignment for Section 11.html

12. What If Analysis

1.1 MSE Chapter 12 What If Analysis Case Study.pdf

1. What If Analysis Case Study

2. What If Analysis Case Study - Solution

3. Assignment for Section 12.html

13. Data Analysis and Validation

1. Importing Data in Excel 2016

2. Formula Auditing in Excel

3. Converting Text to Columns

4. Using Power Pivot to Import Data in Excel 2016

5.1 MSE Chapter 13 Data Analysis and Validation Case Study.pdf

5. Data Analysis and Validation Case Study

6. Data Analysis and Validation Case Study Solution - 1

7. Data Analysis and Validation Case Study Solution - 2

8. Assignment for Section 13.html

14. Printing Excel Workbooks and Sheets

1.1 MSE Chapter 14 Printing.pdf

1. Printing Case Study

2. Printing Case Study Solution

3. Assignment for Section 14.html

15. Macros

1.1 MSE Chapter 15 Macros Case Study.pdf

1. Macros Case Study

2. Macros Case Study Solution

3. Assignment for Section 15.html

16. Managing Excel Files

1. Saving and Sharing Workbooks in Excel

2. Splitting A Worksheet

3. Protecting Workbook and Worksheets

17. Visual Basic for Applications (VBA)

1. Visual Basic For Applications

2. Procedures and Variables

3. Loops And Conditional Logic

18. VBA Case Study 1

1.1 mse chapter 17 vba case study1 solution.zip

1.2 MSE Chapter 17 VBA Case Study1.xlsx

1.3 VBA Case Study-1.pdf

1. Case Study Solution - Record the Macro

2. Case Study Solution - Understanding Macro

3. Case Study Solution - Editing the Macro

4. Case Study Solution - Worksheets Object

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

19. VBA Case Study 2

1.1 VBA Case Study-2.pdf

1. Case Study Description

2. Case Study Solution - Creating a User Form

3. Case Study Solution - Adding Controls to Form

4. Case Study Solution - Editing Properties of Form Controls

5. Case Study Solution - Adding Items to A ComboBox

6. Case Study Solution - Change Event for ComboBox Control

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

8. Case Study Solution - Setting TextBox Control Value

9.1 mse chapter 17 vba case study2 solution.zip

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

20. VBA Case Study 3

1.1 VBA Case Study-3.pdf

1. VBA Case Study 3 Description

2. Case Study Solution - Creating a Custom Excel Function

3. Case Study Solution - Adding Conditional Logic to Function

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

5.1 mse chapter 17 vba case study3 solution.zip

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

21. VBA Case Study 4

1.1 MSE Chapter 17 VBA Case Study4.xlsx

1.2 VBA Case Study-4.pdf

1. Case Study 4 Description

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

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

22. Practice assignment for VBA

1. Assignment for VBA.html

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy