دورة Excel للمبتدئين

المصدر: Kevin Stratvert

• 1-1. Introduction: Welcome to Excel for Beginners مقفل 1 د
• 1-2. Introduction: What is Excel مقفل 1 د
• 1-3. Introduction: How to get Excel مقفل 1 د
• 2-1. Main interface: Start screen مقفل 2 د
• 2-2. Main interface: Workbook and worksheet مقفل 32 ث
• 2-3. Main interface: Tabs and ribbon مقفل 1 د
• 2-4. Main interface: Navigate through a worksheet مقفل 2 د
• 2-5. Main interface: Navigate through a workbook مقفل 44 ث
• 2-6. Main interface: Help مقفل 1 د
• 3-1. Enter data: Numbers مقفل 4 د
• 3-2. Enter data: Column width and row height مقفل 1 د
• 3-3. Enter data: Dates and times مقفل 2 د
• 3-4. Enter data: Select cells to enter data quickly مقفل 58 ث
• 4-1. Save workbook: Save workbook مقفل 46 ث
• 4-2. Save workbook: Benefits of saving a workbook in the cloud مقفل 47 ث
• 5-1. Format, layout, and design: Basic formatting مقفل 4 د
• 5-2. Format, layout, and design: Tables مقفل 3 د
• 5-3. Format, layout, and design: Insert rows and columns مقفل 1 د
• 5-4. Format, layout, and design: Copy and move مقفل 2 د
• 5-5. Format, layout, and design: Conditional formatting مقفل 1 د
• 5-6. Format, layout, and design: Hide rows and columns مقفل 1 د
• 5-7. Format, layout, and design: Find and replace مقفل 1 د
• 6-1. Formulas and functions: Status bar for basic metrics مقفل 1 د
• 6-2. Formulas and functions: Enter a basic formula with addition and subtraction مقفل 3 د
• 6-3. Formulas and functions: Repeat formulas مقفل 1 د
• 6-4. Formulas and functions: Relative and absolute references مقفل 4 د
• 6-5. Formulas and functions: Division مقفل 35 ث
• 6-6. Formulas and functions: Order of operations مقفل 1 د
• 6-7. Formulas and functions: Commons functions including SUM, MAX, MIN, COUNT, and AVERAGE مقفل 6 د
• 6-8. Formulas and functions: VLOOKUP function مقفل 5 د
• 6-9. Formulas and functions: XLOOKUP function مقفل 3 د
• 7-1. Charts: Insert and format charts مقفل 5 د
• 7-2. Charts: Analyze data to generate charts مقفل 2 د
• 8-1. Sorting and filtering: Sort مقفل 3 د
• 8-2. Sorting and filtering: Filter مقفل 2 د
• 8-3. Sorting and filtering: Worksheet views مقفل 1 د
• 9-1. Pivot tables: All about pivot tables مقفل 13 د
• 10-1. Flash fill: Separate and merge data using flash fill مقفل 2 د
• 11-1. Adjust worksheet views: Freeze panes مقفل 2 د
• 11-2. Adjust worksheet views: Split panes مقفل 1 د
• 12-1. Multiple worksheets and workbooks: Rename and color worksheets مقفل 1 د
• 12-2. Multiple worksheets and workbooks: Add and delete worksheets مقفل 49 ث
• 12-3. Multiple worksheets and workbooks: Hide and unhide worksheets مقفل 31 ث
• 12-4. Multiple worksheets and workbooks: Move and copy worksheets مقفل 1 د
• 12-5. Multiple worksheets and workbooks: Worksheet groups مقفل 1 د
• 13-1. Share and collaborate: Protect worksheet مقفل 2 د
• 13-2. Share and collaborate: Protect workbook مقفل 32 ث
• 13-3. Share and collaborate: Password protect workbook مقفل 38 ث
• 13-4. Share and collaborate: Share workbook مقفل 2 د
• 13-5. Share and collaborate: Version history مقفل 36 ث
• 14-1. Print: Print selection مقفل 2 د
• 14-2. Print: Set print area مقفل 1 د
• 14-3. Print: Hide column مقفل 33 ث
• 14-4. Print: Page settings مقفل 1 د
• 14-5. Print: Adjust columns مقفل 1 د
• 14-6. Print: Repeat headers مقفل 50 ث
• 14-7 Print: Headers and footers مقفل 1 د
• 14-8. Print: Show gridlines مقفل 44 ث
• 14-9. Print: Page break view مقفل 1 د
• 15-1. Wrap up: Wrap up مقفل 53 ث