Mastering Microsoft Excel: From Basics to Advanced Technique

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

Unlock the Full Potential of Excel: From Fundamental Skills to Advanced Data Analysis and Visualization

1. Introduction To Excel

1. What Is Excel What Are The Advantages Of Excel

2. Introduction To Excel Interface (MS Excel 2019)

2. The Building Blocks Of Spreadsheets

1. What Are Rows, Columns And Cells

2. Editing Data In Cells

3. Customize The Quick Access Toolbar And Ribbon

4. Freeze Worksheet Rows And Columns, Change Views And Orientation

5. Navigate Within The Workbooks

3. Editing Data In Microsoft Excel

1. Manipulate Data In Worksheets

2. Working With Different Types Of Data

3. What Are Lists Features Of Lists

4. Create, Format And Modify Tables Database Functions

5. Database Functions

4. Perform Operations By Using Formulas And Functions

1. Structure Of A Function

2. Inbuilt Functions And Logical Operations Using Formulas

3. Troubleshoot Formulas

5. Formatting And Validating Data

1. Cell Aesthetics

2. ormat And Validate Data (Data Validation)

6. Creating Visualization

1. Create Charts

2. Modifying Advanced Charts

7. PivotTables And PivotCharts

1. PivotTables In Excel

2. PivotCharts In Excel

8. LOOKUP Function

1. LOOKUP() And VLOOKUP() Function

2. HLOOKUP() Function

3. INDEX(), MATCH()

9. Macros

1. Macros In Excel

10. Visual Basic For Application In Excel

1. Introduction To Visual Basic For Application

2. Conditional Statements And Loops In VBA

11. Creating Dashboards

1. Creating An Excel Dashboard

139,000 تومان

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

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

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

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