Microsoft Excel for Beginners to Advanced

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

1. Introduction

1. Introduction

2. Getting Started

1. Opening Microsoft Excel

2. Excel User Interface - Spreadsheet

3. Excel User Interface - Ribbons

4. Excel User Interface.html

3. Excel Basics

1. Entering Data

2. Selecting Cells

3.1 3. Inserting and Deleting Rows & Columns.xlsx

3. Inserting and Deleting Rows & Columns

4. Formatting Cells - Introduction

5. Formatting Cells - Font, Fill & Format Painter

6. Formatting Cells - Alignment

7. Formatting Cells - Number

8. Hide & Unhide Sheets, Tab Colour & Tab Renaming

9. Excel Basics.html

4. Editing Cell Content

1. Changing cell content

2. Positioning cell content

3. Entering and changing repeated cell content quickly

4. Copy & Paste and Cut & Paste

5. Autofill cell content

6. Sort cell content

7. Applying a Filter on cell content

8. Editing Cell Content.html

5. Insert, Review and View Ribbons

1. Insert - Illustrations

2. Insert - Text

3. Review - Proofing

4. Review - Comments & Notes

5. Review - Protect Sheet & Workbook

6. View - Workbook views

7. View - Window views

8. Insert, Review and View Ribbons.html

6. Formulas - Beginner

1. Introduction to calculations

2.1 2. Formulas - Min & Max.xlsx

2. Formulas - Min & Max

3. Formulas - Sum & Average

4. Formulas - Product, Quotient & Power

5. Formulas - Count, CountA & Countblank

6. Formulas - Beginner.html

7. Formulas - Intermediate

1. Formulas - Index

2. Formulas - Match

3. Formulas - VLookup & HLookup

4. Using Index, Match and VHlookup.html

5. Formulas - Left & Right

6. Formulas - IF

7. Formulas - AND

8. Formulas - OR

9. Left & Right and Logical Functions.html

10. Formulas - Round, Roundup and Rounddown

11. Formulas - SQRT

12. Formulas - Subtotal

13. Formulas - Transpose

14. Formulas - NAME, VALUE AND DIVISION Errors

15. Rounding, Summarisation, Total and Errors.html

8. Formulas - Advanced

1.1 1. Formulas - MINIFS & MAXIFS.xlsx

1. Formulas - MINIFS & MAXIFS

2.1 2. Formulas - SUMIF & SUMIFS.xlsx

2. Formulas - SUMIF & SUMIFS

3.1 3. Formulas - AVERAGEIF & AVERAGEIFS.xlsx

3. Formulas - AVERAGEIF & AVERAGEIFS

4. Using MINMAXIFS, SUMIFS and AVERAGEIFS.html

5.1 5. Formulas - AGGREGATE.xlsx

5. Formulas - AGGREGATE

6. Formulas - CHOOSE

7. Formulas - CONCAT

8. Formulas - IFERROR

9. Formulas - INDIRECT

10. Using AGGREGATE, CHOOSE, INDIRECT, IFERROR AND CONCAT.html

11. Formula - Auditing

9. Conditional Formatting

1. What is Conditional Formatting

2. Conditional Formatting - Highlight Cells Rules

3. Conditional Formatting - TopBottom Rules

4. Conditional Formatting - Data Bars & Colour Scales

5. Conditional Formatting - Icon Sets

6. Conditional Formatting - Creating New Rules

7. Conditional Formatting.html

10. Charts

1. Introduction to Charts

2. Bar Chart & Column Chart

3. Line Chart

4. Combo Chart

5. Pie Chart & Donut Chart

6. Charts.html

11. Dynamic Charts

1. What are Dynamic Charts

2. Dynamic Column Chart

3. Dynamic Pie Chart

4. Dynamic Charts.html

12. Tables

1. Introduction to Tables

2. How to create a Table

3. Tables.html

13. Dynamic Tables

1.1 1. Introduction to Pivot Tables.xlsx

1. Introduction to Pivot Tables

2. Creating a Pivot Table

3. Pivot Table - Number Formatting

4. Pivot Table - Layout & Styles

5. Pivot Charts

6. Dynamic Tables.html

14. Conclusion

1. Conclusion

139,000 تومان

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

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

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

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