Complete Microsoft Excel 2016 Beginner to Advanced Course

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

1. The Basics

1. Introduction

2. Cells, Colors and Text

3. Wrap Text, Numbers and Sheets

4. The Basics Quiz.html

5. Assignment 1.html

2. Tables, Columns, Rows and Filtering Data

1. Tables, Filtering and Sorting

2. Inserting Columns and Rows

3.1 Excel June and July 2019 sales.xlsx

3. Group and Ungroup

4.1 Excel Events and Activities.xlsx

4. Slicer and Object

5.1 Excel Format Table.xlsx

5. Formatting

6. Tables, Filtering, Columns, Rows and Formatting Quiz.html

7. Assignment 2.html

3. Text Shortcuts, Tools and Skills

1.1 Excel Name and Surname.xlsx

1. Flash Fill

2. Text to Columns

3. Concatenate

4.1 Excel Kids Birthday Party.xlsx

4. Find, Replace and Go to

5.1 Excel Employee Info.xlsx

5. Drop down List

6. Text Shortcuts, Tools and Skills Quiz.html

7. Assignment 3.html

4. Basic Formulas

1.1 Excel Hotdog Sales.xlsx

1. Basic Formulas, Sum and Average

2.1 Excel Hotdog Sales Subtotal.xlsx

2. Subtotal

3. Countif

4. Sumif

5. Basic Formulas Quiz.html

6. Assignment 4.html

5. Shapes, Pictures and Symbols

1. Shapes and Effects

2. Insert a Picture

3. Symbols, Equations and Text

4. Shapes and Pictures Quiz.html

5. Assignment 5.html

6. Charts, Forecast Sheet and Sparklines

1. Charts

2.1 Excel Games Sold.xlsx

2. Forecast Sheet

3. Sparklines

4. Charts, Forecast Sheet and Sparklines Quiz.html

5. Assignment 6.html

7. More About Formulas

1. Vlookup

2.1 Excel Hardware Store Tools Index and Match.xlsx

2. Index and Match

3.1 Excel Hardware Store Tools Tax 2.xlsx

3. Absolute Cells

4.1 Excel Score Tables.xlsx

4. If

5. Define Name

6.1 Excel Hardware Store Tools Tax.xlsx

6. Tracing Precedents and Dependents

7. Error Checking, Show and Evaluate Formulas

8. More about Formulas Quiz.html

9. Assignment 7.html

8. Pivot Table, Timeline and Query

1.1 Assignment 8 Excel table 1.xlsx

1. Pivot Table

2. Timeline

3.1 Excel Vehicle Stock.xlsx

3.2 Excel Vehicles Sold.xlsx

3. Query

4. Pivot Table, Timeline and Query Quiz.html

5. Assignment 8.html

9. What If Analysis and Consolidate

1.1 Excel Test Percentage.xlsx

1. Goal Seek

2.1 Excel Car Tyres Table.xlsx

2. Data Table

3.1 Excel Hotdog Sales 2.xlsx

3. Scenario Manager

4.1 Excel Warm Beverages.xlsx

4. Consolidate

5. What If Analysis and Consolidate quiz..html

6. Assignment 9.html

10. View and Review

1. View tab

2. Review your work

3. View and Review Quiz.html

4. Assignment 10.html

45,900 تومان

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

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

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

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