Microsoft Excel 365 – Beginner to Advanced Level 2022

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

Excel Beginner to Advance. Excel Formatting, Excel Functions, Excel Charts, Excel Pivot Table.. (2016, 2019 & Excel 365)

1. Lets Start with Excel Fundamentals

1.1 Chart Preperation.xlsx

1.2 Compare Data.xlsx

1.3 Function Data.xlsx

1.4 Pivot Table.xlsx

1.5 Real Data - Copy.xlsx

1.6 Real Data.xlsx

1.7 sum if.xlsx

1. Excel Intro - New File and Title Bar

2. Excel Structure and Worksheets

3. Customize Ribbons and Quick Access Toolbar

4. Data Entry and Formatting

5. Fill Series in Excel

6. Flash Fill in Excel

7. Cell Reference Understanding

2. Mastering Mathematical Functions

1. Math Operators in Excel

2. Math Functions in Excel

3. Advance Math Function in Excel

4. Database Math Function

3. Mastering Logical Functions Use

1. IF Function in Excel

2. Nesting IF Methodology

3. IF Related Project Solution

4. IF Project Task

5. IF Project Task Solution

6. IFS Function - Newly Introduced

7. AND & OR Function in Excel

8. XOR Function

4. Data Filter and Sorting in Excel

1.1 Function Data.xlsx

1.2 Real Data.xlsx

1. Filter in Excel

2. Date and Color Filter

3. Advanced Filter Option

4. Sort and Custom Sort

5. Conditional Formatting in Excel

1.1 Function Data.xlsx

1. Conditional Formatting - How to Apply

2. Types of Rules in Conditional Formatting

3. Manage Rules in Conditional Formatting

6. Mastering Text Functions and Tools

1.1 Function Data.xlsx

1. UPPER, LOWER, PROPER and TRIM Function

2. LEFT, RIGHT and FIND Function

3. Find Related Task Solution

4. Nesting LEFT, RIGHT and FIND Function

5. MID Function

6. CONCATENATE Function

7. CONCATENATE Project Task Solution

8. CONCAT and TEXTJOIN Function

9. REPLACE Function

10. REPLACE Function Project Solution

11. SUBSTITUTE Function

12. REPT, LEN Function and Project

13. Project Task Solution

14. NUMBERVALUE Function

15. Text to Column Option

7. Mastering Chart Presentation in Excel

1. Chart Preparation in Excel

2. Designing and Format Chart

3. Chart Customization - Part 1

4. Chart Customization - Part 2

5. Pie Chart in Excel

6. Quick Analysis and Chart Recommendation

7. Power Map in Excel

8. Mastering Pivot Table and Power Pivot

1.1 Pivot Table.xlsx

1. Pivot Table in Excel

2.1 Client Info.xlsx

2.2 Items Info.xlsx

2.3 order info.xlsx

2. Power Pivot in Excel - Most Powerful Analysis Tool

9. Financial Functions and What if Analysis Tools

1. PDURATION Function

2. PMT Function - EMI Calculator

3. Data Table in Excel

4. Goal Seek in Excel

5. Solver Plugin in Excel

6. Scenario Manager in Excel

10. Data Grouping and Linking

1. Define Name Feature in Excel

2. Hyperlink in Excel

3. Group and Subtotal in Excel

4. Draw Tab in Excel

11. How to Print Spreadsheet Efficiently

1. Print Options in Excel - Part 1

2. Print Options in Excel - Part 2

12. Protect your Data in Excel

1. Protect Workbook in Excel

2. Protect Sheet in Excel

3. Hide Formula and Unlocked Cell

4. Protect Excel File with Password

13. Date and Time Management

1. Date and Time Setting

2. Date and Time Format in Excel

3. Date and Time Functions

4. NETWORKDAYS Function

5. DATEDIF Function

14. Mastering Lookup and Reference Functions

1.1 Real Data - Copy.xlsx

1.2 Real Data - Copy.xlsx

1.3 Real Data.xlsx

1. VLOOKUP Function

2. IFERROR Function with VLOOKUP

3. Array VLOOKUP Function

4. HLOOKUP Function in Excel

5. MATCH and INDEX Functions

6. MATCH and INDEX Functions Nesting

7. VLOOKUP TRUE Feature

8. Amazing Trick in LOOKUP Functions

9. XLOOKUP Function

15. Mastering Macro Recording Feature

1. Macro Recording in Excel

2. Macro Recording Examples

3. Ways to Run Macros in Excel

53,700 تومان

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

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

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

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