Microsoft Excel – Beginner to Advanced Users in 2024

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

Microsoft Excel Essentials, Spreadsheet Application in real world for Beginners to Advanced Users

1. Introduction

1. Excel Introduction

2. Lecture 2 Save Options in MS Excel

1. Saving an Excel File

3. Entering Data in Excel File

1. Entering Data in Excel File

4. WorkBook and Sheets

1. Workbooks and Sheets in Excel

5. Copy and Paste Special

1. Copy and Paste Special

6. Relative and Absolute References

1. Relative Vs Absolute Reference

7. Formatting in Excel

1. Formatting in Excel Part 1

2. Formatting in Excel Part 2

3. Formatting in Excel Part 3

8. Conditional Formatting

1. Conditional Formatting Part 1

2. Conditional Formatting Part 2

3. Conditional Formatting Part 3

9. Freeze Panes in Excel

1. Freeze Panes In excel

10. Sorting & Filtering Data in Excel

1. Basic Sort in Excel

2. Advanced Sort in Excel

3. Filter in Excel Part 1

4. Filters in Excel Part 2

5. Advanced Filter in Excel

11. Basic Functions

1. Basic Functions in Excel

2. FLASH FILL Filling Data at once

12. Data Handling in Excel

1. Text to Columns

2. Data Validation in Excel Part 1

3. Data Validation in Excel Part 2

4. Consolidate Data from Multiple Sheets

13. Logical Test

1. Logical Test

14. Text Function in Excel

1. Text Functions Part 1

2. Text Functions Part 2

3. Text Functions Part 3

4. Text Functions Part 4

15. Logical Functions of Excel

1. IF Function in Excel

2. Nested IF Part 1

3. Nested IF Part 2

4. SUMIF, SUMIFS, COUNTIF, COUNTIFS

5. AND Function

6. OR Function

7. NOT Function

8. IFERROR Function

9. IFS Function

16. Mathematical Functions in Excel

1. SUMPRODUCT Function

2. SUBTOTAL Function

17. Date And Time Functions in Excel

1. Date and Time Functions Part 1

2. Date and Time Functions Part 2

3. Date and Time Functions Part 3

4. Date and Time Functions Part 4

18. Tables in Excel

1. Basic Table

2. Advanced Table

19. PIVOT TABLES & LOOKUP FUNCTIONALITY

1. Pivot Tables Part 1

2. Pivot Table Part 2

3. Pivot Table Part 3

4. VLOOKUP

5. HLOOKUP

6. XLOOKUP

7. INDEX FUNCTION

8. MATCH FUNCTION

9. INDEX & MATCH

20. What-If Analysis in Excel

1. Scenario manager and Goal Seek

2. Data table

21. Charts in MS EXcel

1. Basics of Charts

2. Formatting Chart Elements Part 1

3. Formatting Chart Elements Part 2

4. Sparkline Charts

5. Bar Chart

6. Column Chart

7. Line Chart

8. Pie Chart

9. Area Chart

10. Scatter Chart

11. Bubble Chart

139,000 تومان

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

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

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

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