excel2019

페이지 정보

profile_image
작성자딸바부 조회 0회 작성일 2021-05-17 11:30:13 댓글 0

본문

Excel 2019 Beginner Tutorial

Excel 2019 Beginner Tutorial

For certificates, exams, and badges, join our Patreon community: https://www.patreon.com/learnittraining

Join our online community! - https://www.offsitebylearnit.com

Exercise Files: https://bit.ly/36ZPKzO

Start 0:00
Introduction 0:03
Start Screen \u0026 Templates 0:59
Ribbon \u0026 Quick Access Toolbar 6:04
Backstage View 12:44
Smart Lookup \u0026 Tell Me 15:33
Interface 18:49
Navigation 22:36
Keyboard Shortcuts 26:03
Entering Text 30:18
Number Formats 36:08
Deleting \u0026 Formatting 40:20
AutoSum 44:55:01
Simple Formulas 49:29
Simple Functions (Part 1) 52:57
Simple Functions (Part 2) 59:18
Absolute Referencing 1:03:01
Moving \u0026 Copying Data 1:09:15
Inserting Rows \u0026 Columns 1:12:16
AutoFill 1:16:57
Cell Styles 1:22:52
Worksheet Themes 1:27:26
Excel Templates 1:32:40
Freeze Panes 1:35:39
Grouping Worksheets 1:41:01
Page Layout View 1:43:56
Custom Views 1:45:54
Spell Check 1:48:13
Printing 1:49:58

Excel 2019 Advanced Tutorial

Excel 2019 Advanced Tutorial

For certificates, exams, and badges, join our Patreon community: https://www.patreon.com/learnittraining

Join our online community! - https://www.offsitebylearnit.com

Exercise Files: https://bit.ly/36ZPKzO

Start 0:00
Introduction 0:03
Overview of List Design 1:02
Formatting Lists as Tables 4:47
Filtering Records from Lists or Tables 6:45
Removing Duplicates from Lists or Tables 10:19
Flash Fill 13:40
Single \u0026 Multi-Level Sorting 16:50
Inserting Automatic Subtotals in Lists 21:27
Inserting Data Charts Using Recommended Charts 27:36
Formatting \u0026 Editing Chart Elements 32:28
Creating \u0026 Applying Custom Chart Templates 36:58
Adding \u0026 Removing Data from Charts 40:38
Inserting Sparklines 43:23
Printing Charts 48:52
Inserting Pivot Tables 49:57
Filtering Pivot Tables 55:04
Using Report Layouts in Pivot Tables 59:58
Refreshing \u0026 Changing Source Data in Pivot Tables 1:03:05
Inserting Pivot Charts 1:07:21
Data Validation 1:09:18
Applying Built-In Conditional Formatting 1:14:12
Creating Custom Conditional Formats 1:17:26
Linking Data 1:20:23
Comments 1:24:41
Protection 1:26:56

Excel 2019 Expert Tutorial

Excel 2019 Expert Tutorial

For certificates, exams, and badges, join our Patreon community: https://www.patreon.com/learnittraining

Join our online community! - https://www.offsitebylearnit.com

Exercise Files: https://bit.ly/36ZPKzO

Start 0:00
Introduction 0:03
Creating \u0026 Applying Named Ranges 1:24
Navigating with Named Ranges 9:42
IF Functions (Part 1) 11:26
IF Functions (Part 2) 15:17
Introduction to Nesting Functions 18:07
The Round Function 22:16
Formula Auditing Tools 25:39
Introduction to VLOOKUP 29:40
VLOOKUP 33:58
IFERROR 36:13
Database Functions – SUMIF \u0026 AVERAGEIF 38:37
Database Functions – SUMIFS 42:42
Text Functions 46:13
Consolidate by Position 53:17
Consolidate by Category 57:34
Goal Seek 1:00:31
Introduction to Data Tables 1:03:22
Data Tables 1:06:25
Scenario Manager 1:07:45
Macros – Adding the Developer Tab 1:12:28
Macros – Recording \u0026 Running the Header Macro 1:14:42
Macros – Visual Basic Editor \u0026 Form Control 1:20:29
Macros – Adding Macros to the Ribbon 1:25:02
Macros – Exercise 1:27:38

... 

#excel2019

댓글목록

등록된 댓글이 없습니다.

전체 2,648건 1 페이지
게시물 검색
Copyright © www.donghwasports.co.kr. All rights reserved.  Contact : help@oxmail.xyz