Learn MS Excel From Scratch | An Ultimate Course in English

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

An Ultimate Course of MS Excel - Learn Everything About MS Excel From Basic to Advanced Level in English

1. Introductions and basic Functions in MS Excel

1. Introduction and overview of course

2. Getting Started with MS Excel and Basic Operators

3.1 Excel Shortcut List.pdf

3. Basic Functions and Operators in Excel

4.1 Excel Training Book.pdf

4.2 marksheet1.xlsx

4. Using Functions into assignment or Task

2. More about Excel function and formattings

1. Important Functions for Excel sheets

2. PMT and NPER Functions in Excel

3. Creating a Students Marks Sheet AND Other sheets

4. Basic Formattings in MS Excel

3. Advanced Functions of Excel

1. Sumif Function in Excel

2. Sumifs and Averageifs Functions in Excel

3. if and ifs Functions in MS Excel

4. Count, Countif and Countifs Functions in Excel

5.1 attendance sheet.xlsx

5. Creating an Attendance Sheet in Excel

4. Important and effective Options in MS Excel

1. Page setup and Print Preview in MS Excel

2. Conditional Formatting and other Formatting

3. Filter and sorting Data in MS Excel

4. Working with Drawings, Pictures or chart in Excel

5. Working with Advanced Functions of MS Excel

1.1 and or.xlsx

1. Use of and Or Functions in Excel

2. Use of if(and if(or in MS Excel

3. Use of Lookup Function and payment sheet in Excel

6. Super Advanced Functions of MS Excel

1. Protect sheet, workbook and password

2.1 DASHBOARD.xlsx

2. Pivot Table in MS Excel

3. Creating Data Entry Form in MS Excel

4. Calculations through Sheets and Final Words

139,000 تومان

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

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

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

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