Microsoft Excel From Beginner to Advanced 2024

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

Learn A-Z in Excel, From Zero to Hero | Become an Advanced Excel User, For Excel 2013, 2016, 2019, 2021, Office 365.

1. Introduction

1. Welcome and Introduction

2. About The Instructor

1. About Dr. Wendy Pierre

3. Course Outline

1. Course Outline

2. Course Certificate

4. MODULE I The importance of Excel in the 21st Century

1. What is excel and what is the importance of excel in todays data-driven world

2. Different Methods to Open Excel, in Windows, macOS, and other Operating System

3. About the Instructor

5. Module II

1. Quick Navigation The status bar Spreadsheet and overview of the Course.

2. What is Excel A brief History about excel what actually ribbon is worksh

6. Module III The Basics of Excel

1. Columns Rows Cells How to enter data into the cells How to change cell

7. Module IV Concatenation

1. Second Method; Using CONCATENATE Function

2. How to merge two columns in Excel without losing data using concatenation or con

8. MODULE V Formulas and Functions

1. Working With Charts and Graphs.

2. How can we sort data in the Excel

3. Formulas and Functions

9. MODULE VI Relative and Absolute Cell Referencing

1. Relative and Absolute Cell Referencing.

10. MODULE VII How to Enter Data in Excel

1. How to Enter Data in Excel

11. MODULE VIII Order of Operations in Excel

1. Order of Operations in Excel

12. MODULE IX Copying and Moving with Drag and Drop in Excel

1. Copying and Moving with Drag and Drop in Excel

13. MODULE X Working with Rows and Columns

1. How to Hide and Unhide Rows and Columns

2. How to Work with Rows and Columns

14. MODULE XI How to Work with Sheets

1. How To Change the Sheets How to Protect Sheets How to Delete Sheets

2. How to Create New Sheets Move Sheets around Sheet Reference

3. How to Work with Sheets

15. MODULE XII How to Filter Data

1. How To Remove Filter The Shortest Method to apply Filter

2. How to Filter Data {Long Method) Applying Filter on one Particular Column

3. About Filtering of Data.

16. MODULE XIII Functions

1. Some Definitions to better understand Functions

2. Functions

3. How to perform a specific calculations in Excel

17. MODULE XIV How to name a number of ranges of cells in Excel

1. How to name a number of ranges of cells in Excel

189,000 تومان

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

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

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

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