Microsoft Excel Fundamentals

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

A Practical Workshop for Beginners

1. Introduction

1. Introduction

2. What is a Spreadsheet

3. Home Screen, New and Open

4. Titlebar & Quick Access Toolbar

5. The Ribbon

6. Formula Bar

7. Workbooks & Worksheets

8. Status Bar

9. Summary.html

2. Building Spreadsheets

1. Introduction

2. Entering Data

3. Number Formats

4. Using Functions & Formulas

5.1 assignment 01.pdf

5. Assignment 1

6. Average Function

7. CountIF Function

8. Count Function

9.1 assignment 02.pdf

9. Assignment 2

10. VLookup Function

11.1 assignment 03.pdf

11. Assignment 3

12. Date & Time Functions

13. Relative, Absolute & Mixed Cell References

14. Adding & Deleting Rows & Columns

15. Merging Cells

16. Cut, Copy, Paste & Paste Special

17. Freeze & Split Panes

18. Sorting Data

19. Filtering Data

20. Introduction to Cell Borders & Shading

21. Introduction to Conditional Formatting

22. Introduction to Excel Tables

23. Table Design Ribbon Tab

24. Summary.html

3. Saving, Printing & Exporting Workbooks

1. Introduction

2. Saving Workbooks

3. Opening Workbooks

4. Preparing a Worksheet for Printing

5. Page Margins

6. Print Selection

7. Exporting Workbooks

8. Summary.html

4. Creating Charts

1. Introduction

2. Types of Chart

3. Inserting a Chart

4. Customizing a Chart

5.1 Assignment 04.pdf

5. Assignment 4

6. Summary.html

5. Data Validation

1. Introduction

2. Introduction to Data Validation Rules

3. Adding Validation Rules

4.1 Assignment 05.pdf

4. Assignment 5

5. Summary.html

6. Data Analysis

1. Introduction

2. Introduction to Basic Data Analysis

3. Goal Seek

4.1 Assignment 06.pdf

4. Assignment 6

5. Scenario Manager

6.1 Assignment 07.pdf

6. Assignment 7

7. Introduction to Pivot Tables

8.1 Assignment 08.pdf

8. Assignment 8

9. Summary.html

7. Sharing & Collaboration

1. Introduction

2. Sharing a Workbook

3. Summary.html

8. Macros & Automation

1. Introduction

2. Recording a Macro

3. Executing a Recorded Macro

4. Summary.html

9. Summary & Next Steps

1. Wrap up & Summary

2.1 Additional Excel Tips.html

2.2 Using Excel Textbook.html

2. Bonus Lecture

45,900 تومان

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

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

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

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