Excel 2021 – Intermediate

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

Expand existing Excel 2021 knowledge

1. Introduction

1. Introduction

2. Linking Workbooks and Worksheets

1. Linking Workbooks and Worksheets

2. Linking Worksheets with 3D References

3. Understanding the Consolidate Feature

3. Working with Range Names

1. Understanding Range Names

2. Creating Range Names in the Name Box and Define Name Feature

3. Creating Range Names from a Selection

4. Sorting, Filtering, and Subtotaling

1. Understanding Sorting versus Filtering

2. Sorting Lists

3. Filtering Lists

4. Creating Subtotals

5. Analyzing and Organizing with Tables

1. Understanding and Creating Tables

2. Understanding the Elements of a Table

3. Formatting a Table

4. Sorting Tables

5. Filtering with Slicers

6. Calculating with Tables

7. Removing Erroneous Table Data

8. Exporting, Refreshing, and Converting Tables

6. Using Conditional Formatting

1. Working with Conditional Formatting

2. Highlighting Cells and Finding Top & Bottom Values

3. Applying Conditional Formatting Data Bars, Icon Sets, and Color Scales

4. Using Custom Fonts and Colors

5. Using Custom Conditional Formatting

6. Modifying or Removing Conditional Formatting

7. Displaying Data Graphically

1. Understanding Charts

2. Creating Charts

3. Working with Chart Elements

4. Changing and Moving Charts

5. Filtering a Chart

6. Formatting Charts

7. Formatting Numbers

8. Creating Dual Axis Charts

9. Forecasting with Trendlines

10. Creating a Chart Template

11. Displaying Trends with Sparklines

8. Understanding PivotTables, PivotCharts, and Slicers

1. Introducing PivotTables

2. Creating a PivotTable

3. Working with the PivotTable Fields Pane

4. Formatting PivotTables

5. Creating a PivotChart

6. Modifying and Formatting a PivotChart

7. Working with Slicers and Timeline Slicers

9. Working with Advanced PivotTables and PowerPivot Features

1. Using the PivotTable and PivotChart Wizard

2. Adding a Calculated Field

3. Adding a Calculated Item

4. Applying Conditional Formatting to a PivotTable

5. Using Filters in a PivotTable

6. Creating Filter Pages for a PivotTable

7. Enabling the PowerPivot Add-In

10. Conclusion

1. Course Recap

11. Excel 2021 Intermediate Assessment

1. Excel 2021 Intermediate Assessment.html

189,000 تومان

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

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

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

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