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

للحصول على شهادة

  • 1- التسجيل
  • 2- مشاهدة الكورس كاملا
  • 3- متابعة نسبة اكتمال الكورس تدريجيا
  • 4- بعد الانتهاء تظهر الشهادة في الملف الشخصي الخاص بك