Excel for Beginners

60 dərslik YouTube seriyası — Kevin Stratvert

Kevin Stratvert 2h 10m 60 dərs English

Başlanğıc

YouTube embed

Bu kurs tamamilə pulsuzdur — bütün dərslər açıqdır.

Kurs haqqında

Bu kurs Kevin Stratvert YouTube kanalının “Excel for Beginners” pleylistidir və 60 dərsdən ibarətdir. Videolar YouTube pleyeri ilə göstərilir, yəni izləmələriniz kanalın özünə gedir və bütün müəllif hüquqları kanal sahibinə aiddir. Mir19 burada yalnız yönləndirmə rolunu oynayır: dərsləri ardıcıl düzür, kateqoriyalara ayırır və izlədiyin yeri yadda saxlayır. Kurs tamamilə pulsuzdur, abunə tələb etmir. Orijinal pleylist: https://www.youtube.com/playlist?list=PLlKpQrBME6xLDnoK7OovAVVsGNV55MS3K

Kurikulum

60 dərs · 2h 10m

Rəylər

Bu kursa hələ rəy yazılmayıb. İlk sən ol.

Rəy yazmaq üçün daxil ol →

Excel for Beginners

Kurs haqqında

Kurikulum

11-1. Introduction: Welcome to Excel for BeginnersPulsuz1 min

21-2. Introduction: What is ExcelPulsuz1 min

31-3. Introduction: How to get ExcelPulsuz2 min

42-1. Main interface: Start screenPulsuz2 min

52-2. Main interface: Workbook and worksheetPulsuz1 min

62-3. Main interface: Tabs and ribbonPulsuz1 min

72-4. Main interface: Navigate through a worksheetPulsuz3 min

82-5. Main interface: Navigate through a workbookPulsuz1 min

92-6. Main interface: HelpPulsuz1 min

103-1. Enter data: NumbersPulsuz4 min

113-2. Enter data: Column width and row heightPulsuz1 min

123-3. Enter data: Dates and timesPulsuz2 min

133-4. Enter data: Select cells to enter data quicklyPulsuz1 min

144-1. Save workbook: Save workbookPulsuz1 min

154-2. Save workbook: Benefits of saving a workbook in the cloudPulsuz1 min

165-1. Format, layout, and design: Basic formattingPulsuz5 min

175-2. Format, layout, and design: TablesPulsuz3 min

185-3. Format, layout, and design: Insert rows and columnsPulsuz2 min

195-4. Format, layout, and design: Copy and movePulsuz2 min

205-5. Format, layout, and design: Conditional formattingPulsuz1 min

215-6. Format, layout, and design: Hide rows and columnsPulsuz2 min

225-7. Format, layout, and design: Find and replacePulsuz1 min

236-1. Formulas and functions: Status bar for basic metricsPulsuz2 min

246-2. Formulas and functions: Enter a basic formula with addition and subtractionPulsuz3 min

256-3. Formulas and functions: Repeat formulasPulsuz2 min

266-4. Formulas and functions: Relative and absolute referencesPulsuz5 min

276-5. Formulas and functions: DivisionPulsuz1 min

286-6. Formulas and functions: Order of operationsPulsuz2 min

296-7. Formulas and functions: Commons functions including SUM, MAX, MIN, COUNT, and AVERAGEPulsuz7 min

306-8. Formulas and functions: VLOOKUP functionPulsuz6 min

316-9. Formulas and functions: XLOOKUP functionPulsuz3 min

327-1. Charts: Insert and format chartsPulsuz6 min

337-2. Charts: Analyze data to generate chartsPulsuz2 min

348-1. Sorting and filtering: SortPulsuz3 min

358-2. Sorting and filtering: FilterPulsuz3 min

368-3. Sorting and filtering: Worksheet viewsPulsuz1 min

379-1. Pivot tables: All about pivot tablesPulsuz13 min

3810-1. Flash fill: Separate and merge data using flash fillPulsuz2 min

3911-1. Adjust worksheet views: Freeze panesPulsuz3 min

4011-2. Adjust worksheet views: Split panesPulsuz2 min

4112-1. Multiple worksheets and workbooks: Rename and color worksheetsPulsuz1 min

4212-2. Multiple worksheets and workbooks: Add and delete worksheetsPulsuz1 min

4312-3. Multiple worksheets and workbooks: Hide and unhide worksheetsPulsuz1 min

4412-4. Multiple worksheets and workbooks: Move and copy worksheetsPulsuz1 min

4512-5. Multiple worksheets and workbooks: Worksheet groupsPulsuz1 min

4613-1. Share and collaborate: Protect worksheetPulsuz3 min

4713-2. Share and collaborate: Protect workbookPulsuz1 min

4813-3. Share and collaborate: Password protect workbookPulsuz1 min

4913-4. Share and collaborate: Share workbookPulsuz2 min

5013-5. Share and collaborate: Version historyPulsuz1 min

5114-1. Print: Print selectionPulsuz3 min

5214-2. Print: Set print areaPulsuz1 min

5314-3. Print: Hide columnPulsuz1 min

5414-4. Print: Page settingsPulsuz1 min

5514-5. Print: Adjust columnsPulsuz1 min

5614-6. Print: Repeat headersPulsuz1 min

5714-7 Print: Headers and footersPulsuz2 min

5814-8. Print: Show gridlinesPulsuz1 min

5914-9. Print: Page break viewPulsuz2 min

6015-1. Wrap up: Wrap upPulsuz1 min

Rəylər