Microsoft Excel – Excel from Beginner to Advanced 2025

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

Basics to Advanced, ChatGPT, AI Tools, Dashboards, Automation, VBA, Macros - All in One Comprehensive Course

1 - E1. MS Excel - Start-up

1 -E1.pdf

1 -E1.1 How to Launch MS Excel

2 -E1.pdf

2 -E1.2 Start Screen - Back Stage Screen - Navigating MS Excel

3 -E1.pdf

3 -E1.3 User Interface - Navigating MS Excel Workbook Screen

4 -E1.xlsx

4 -E1.4 Home Tab - Basic Editing Tools

5 -E1.xlsx

5 -E1.5 Copy and Paste I using Multiple Tools in MS Excel

2 - E2. MS Excel Basic Tools to know

1 -E2.1 Customize Ribbon Bar Tabs, Groups, Commands I Tools

2 -E2.xlsx

2 -E2.2 Text to Column Multiple methods

3 -E2.xlsx

3 -E2.3 Speak Cells Data Reading Tool

4 -E2.xlsx

4 -E2.4 Comments - Add, Edit, Delete, Copy Paste, Background change

5 -E2.xlsx

5 -E2.5 Filters in MS Excel

6 -E2.xlsx

6 -E2.6 Freeze Panes and Split Window

3 - E3. MS Excel Fill Series and Data, Sheet Controls

1 -E3.xlsx

1 -E3.1 Fill Series - Basics

2 -E3.xlsx

2 -E3.2 Fill Series - Advanced

3 -E3.xlsx

3 -E3.3 Fill Series - Flash Fill

4 -E3.xlsx

4 -E3.4 Conditional Formatting

5 -E3.xlsx

5 -E3.5 Hyperlinks to Sheets, Web pages, Files

6 -E3.6 Header and Footer Settings

7 -E3.xlsx

7 -E3.7 Printing and Paper Settings

8 -E3.xlsx

8 -E3.8 Import Data from Web

9 -E3.txt

9 -E3.xlsx

9 -E3.9 Import Data from Text File with Auto Refresh

10 -E3.xlsx

10 -E3.10 Import Objects into Excel

4 - E4. MS Excel Working with Sheets

1 -E4.xlsx

1 -E4.1 Characteristics of a cell

2 -E4.xlsx

2 -E4.2 Cell References Relative Ref, Absolute Ref, Mixed Ref

3 -E4.xlsx

3 -E4.3 Custom View

4 -E4.4 Sheet protection

5 -E4.5 Cell Protection

6 -E4.xlsx

6 -E4.6 Compare sheets side by side I View Sheets side by side

7 -E4.7 Compare sheets from Multiple Files

8 -E4.xlsx

8 -E4.8 Working with cells, rows, columns, Specific Size, Auto Fit

9 -E4.xlsx

9 -E4.9 Working with sheets rename, colour, copy, move, grouping

5 - E5. SUM related formulas

1 -E5.pdf

1 -E5.1 Things to remember before starting formulas

2 -E5.pdf

2 -E5.xlsx

2 -E5.2 SUM

3 -E5.xlsx

3 -E5.3 SUMIF

4 -E5.xlsx

4 -E5.4 SUMIFS

5 -E5.xlsx

5 -E5.5 SUBTOTAL

6 -E5.xlsx

6 -E5.6 AGGREGATE

7 -E5.xlsx

7 -E5.7 SUMPRODUCT

8 -E5.xlsx

8 -E5.8 SUMSQ

9 -E5.xlsx

9 -E5.9 SUMX2MY2, SUMX2PY2, SUMXMY2 I Maths and Trigonometry

10 -E5.xlsx

10 -E5.10 DSUM - DATA BASE SUM

11 -E5.xlsx

11 -E5.11 IMSUM vs IMSUB Complex Data Calculations

6 - E6. AVERAGE related formulas

1 -E6.xlsx

1 -E6.1 AVERAGE

2 -E6.xlsx

2 -E6.2 AVERAGEA

3 -E6.xlsx

3 -E6.3 AVERAGEIF vs AVERAGEIFS

4 -E6.txt

4 -E6.xlsx

4 -E6.4 Weighted Average with VBA Code

7 - E7. COUNT related formulas

1 -E7.xlsx

1 -E7.1 COUNT, COUNTA, COUNTBLANK

2 -E7.xlsx

2 -E7.2 COUNTIF vs COUNTIFS

8 - E8. LOGIAL- IF related formulas

1 -E8.xlsx

1 -E8.1 LOGICAL TEST with Comparative Operators

2 -E8.xlsx

2 -E8.2 IF

3 -E8.xlsx

3 -E8.3 IF AND vs IF OR

4 -E8.xlsx

4 -E8.4 IFS vs NESTEDIF

5 -E8.xlsx

5 -E8.5 IFERROR

6 -E8.xlsx

6 -E8.6 SWITCH

9 - E9. TEXT EXTRACTION AND MANIPULATION

1 -E9.xlsx

1 -E9.1 LEFT, RIGHT, MID and LEN

2 -E9.xlsx

2 -E9.2 FIND vs SEARCH

3 -E9.xlsx

3 -E9.3 REPLACE vs SUBSTITUTE

10 - E10. TEXT FORMATTING AND CONVERSTION

1 -E10.xlsx

1 -E10.1 CONCAT vs CONCATENATE

2 -E10.xlsx

2 -E10.2 TEXT

3 -E10.xlsx

3 -E10.3 UPPER, LOWER, PROPER

4 -E10.xlsx

4 -E10.4 TRIM

5 -E10.txt

5 -E10.xlsx

5 -E10.5 SPELLNUMBER with VBA code

6 -E10.txt

6 -E10.6 TEXT-TO-NUMBER with VBA code

139,000 تومان

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

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

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

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