Microsoft Excel for all levels | From Zero to Hero (2022)

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

Become the master of MS Excel. Updated course 2022

1. Getting Started with Excel

1. What is Excel used for

2. Excel Toolbars and shortcut menues

3. Workbooks and Worksheets

4. How to look for Help on Excel - Using Excel Help

2. Data entry, Editing and AutoFill

1. Data entry, Editing and AutoFill

2. Entering Dates and Time

3. Formulas and Functions

1.1 Data source_Pivot.xlsx

1. Working with Simple formulas

2. Using the SUM() function

3. Using MIN() and MAX() Functions

4. Using the AVERAGE() function

4. Basic Formatting

1. Font styles and effects

2. Borders and color background

3. Adjusting row height and column width

4. Insert, Hide, Delete a column or a row

5. Move, Copy and Insert Data

6. Find and Replace

5. Charts

1. How to Create Charts in Excel

2. Chart Types

3. Exploring Excel Ideas

6. PivotTables in Excel - Part 1

1.1 Data source_Pivot.xlsx

1. Introduction

2. Create your first PivotTable

3. Configure your PivotTable

4. Create a PivotTable from external data source

5. Manage PivotTables

7. Summarizing PivotTable Data - Part 2

1. Subtotals and Grand Totals

2. Operations of the Data field summary

3. Adding more than one data field

4. Managing Dates in PivotTables

5. Creating Calculated Fields

6. Drilling down the data

7. Sorting the data

8. Filtering the data

9. Filter by rules

10. Filtering with search

11. Filtering using Slicers

12. Formatting the slicers

13. More on filtering your data

14. Clearing and re-applying filters

15. Filtering the PivotTable with a Timeline

16. Changing the style of the PivotTable

17. Changing the Layout of the PivotTable

18. Formatting the numbers in the PivotTable

8. Conditional formatting for PivotTables - Part 3

1. Highlighting cells by applying a rule

2. Highlight the top values in a PivotTable

3. Formatting cells using data bars

4. Formatting cells using colour scale

5. Formatting cells using icon sets

6. Edit a conditional formatting rule

7. Multiple formatting

9. Creating and Formatting PivotCharts

1. Create a Pivot Chart

2. Pivot a PivotChart

3. Filter a PivotChart

4. Format a PivotChart

5. Change a PivotChart typelayout

6. Add a trendline to a PivotChart

10. Advanced Formulas and Functions

1. Display and highlight formulas

2. Auditing tools

3. Use entire rowcolumn reference

4. Change formulas to values and update values with formulas

5. Debugging formulas with the F9 key

6. Improve readability with cells and range names

7. IF logical test and the use of relational operators

8. Nested IF statement

9. Compound logical tests with AND, OR

10. Use IFS for multiple conditions

11. COUNTIF, AVERAGEIF, SUMIF

45,900 تومان

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

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

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

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