Excel for Beginners
4.0
(1)
8 learners
What you'll learn
This course includes
- 2 hours of video
- Certificate of completion
- Access on mobile and TV
Course content
1 modules • 60 lessons • 2 hours of video
Excel for Beginners
60 lessons
• 2 hours
Excel for Beginners
60 lessons
• 2 hours
- 1-1. Introduction: Welcome to Excel for Beginners 01:23
- 1-2. Introduction: What is Excel 01:16
- 1-3. Introduction: How to get Excel 01:48
- 2-1. Main interface: Start screen 02:09
- 2-2. Main interface: Workbook and worksheet 00:32
- 2-3. Main interface: Tabs and ribbon 01:29
- 2-4. Main interface: Navigate through a worksheet 02:43
- 2-5. Main interface: Navigate through a workbook 00:44
- 2-6. Main interface: Help 01:20
- 3-1. Enter data: Numbers 04:14
- 3-2. Enter data: Column width and row height 01:24
- 3-3. Enter data: Dates and times 02:28
- 3-4. Enter data: Select cells to enter data quickly 00:58
- 4-1. Save workbook: Save workbook 00:46
- 4-2. Save workbook: Benefits of saving a workbook in the cloud 00:47
- 5-1. Format, layout, and design: Basic formatting 04:42
- 5-2. Format, layout, and design: Tables 03:24
- 5-3. Format, layout, and design: Insert rows and columns 01:37
- 5-4. Format, layout, and design: Copy and move 02:11
- 5-5. Format, layout, and design: Conditional formatting 01:27
- 5-6. Format, layout, and design: Hide rows and columns 01:50
- 5-7. Format, layout, and design: Find and replace 01:15
- 6-1. Formulas and functions: Status bar for basic metrics 01:56
- 6-2. Formulas and functions: Enter a basic formula with addition and subtraction 03:00
- 6-3. Formulas and functions: Repeat formulas 01:47
- 6-4. Formulas and functions: Relative and absolute references 04:59
- 6-5. Formulas and functions: Division 00:35
- 6-6. Formulas and functions: Order of operations 01:41
- 6-7. Formulas and functions: Commons functions including SUM, MAX, MIN, COUNT, and AVERAGE 06:56
- 6-8. Formulas and functions: VLOOKUP function 05:55
- 6-9. Formulas and functions: XLOOKUP function 03:07
- 7-1. Charts: Insert and format charts 05:51
- 7-2. Charts: Analyze data to generate charts 02:06
- 8-1. Sorting and filtering: Sort 03:11
- 8-2. Sorting and filtering: Filter 02:41
- 8-3. Sorting and filtering: Worksheet views 01:08
- 9-1. Pivot tables: All about pivot tables 13:26
- 10-1. Flash fill: Separate and merge data using flash fill 02:16
- 11-1. Adjust worksheet views: Freeze panes 02:48
- 11-2. Adjust worksheet views: Split panes 01:35
- 12-1. Multiple worksheets and workbooks: Rename and color worksheets 01:02
- 12-2. Multiple worksheets and workbooks: Add and delete worksheets 00:49
- 12-3. Multiple worksheets and workbooks: Hide and unhide worksheets 00:31
- 12-4. Multiple worksheets and workbooks: Move and copy worksheets 01:07
- 12-5. Multiple worksheets and workbooks: Worksheet groups 01:17
- 13-1. Share and collaborate: Protect worksheet 02:56
- 13-2. Share and collaborate: Protect workbook 00:32
- 13-3. Share and collaborate: Password protect workbook 00:38
- 13-4. Share and collaborate: Share workbook 02:01
- 13-5. Share and collaborate: Version history 00:36
- 14-1. Print: Print selection 02:56
- 14-2. Print: Set print area 01:00
- 14-3. Print: Hide column 00:33
- 14-4. Print: Page settings 01:22
- 14-5. Print: Adjust columns 01:13
- 14-6. Print: Repeat headers 00:50
- 14-7 Print: Headers and footers 01:36
- 14-8. Print: Show gridlines 00:44
- 14-9. Print: Page break view 01:47
- 15-1. Wrap up: Wrap up 00:53
Take this course with you
Download the app to continue lessons from your phone anytime.
