Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Excel 2016 Beginner Level Course
About this Course
Microsoft Excel 2016 Beginner Level Course (by Hudson) (1:17)
Course Introduction
1. Introduction to your tutor (0:43)
2. Introduction to the course (0:29)
3. Who is this course for? (0:56)
Introduction to Microsoft Excel 2016
4. What can Excel 2016 do for you (1:49)
Understanding Common Terms used in Excel and Spreadsheets
5. Understanding common terms used in Excel and spreadsheets - Part 1 (0:54)
5. Understanding common terms used in Excel and spreadsheets - Part 2 (0:56)
5. Understanding common terms used in Excel and spreadsheets - Part 3 (1:08)
5. Understanding common terms used in Excel and spreadsheets - Part 4 (0:34)
5. Understanding common terms used in Excel and spreadsheets - Part 5 (0:44)
5. Understanding common terms used in Excel and spreadsheets - Part 6 (0:20)
Navigating Your Way Around Excel
6. Navigating your way around Excel - Part 1 (3:40)
6. Navigating your way around Excel - Part 2 (1:42)
6. Navigating your way around Excel - Part 3 (1:21)
6. Navigating your way around Excel - Part 4 (2:18)
Excel General Options
7. Excel general options - Part 1 (2:47)
7. Excel general options - Part 2 (0:57)
7. Excel general options - Part 3 (2:10)
7. Excel general options - Part 4 (1:42)
7. Excel general options - Part 5 (1:20)
Adding, Copying and Moving Worksheets
8. Adding, copying and moving worksheets - Part 1 (1:21)
8. Adding, copying and moving worksheets - Part 2 (2:29)
8. Adding, copying and moving worksheets - Part 3 (2:27)
8. Adding, copying and moving worksheets - Part 4 (1:55)
Working with Cells, Columns and Rows
9. Working with cells, columns and rows - Part 1 (1:08)
9. Working with cells, columns and rows - Part 2 (2:07)
9. Working with cells, columns and rows - Part 3 (2:13)
9. Working with cells, columns and rows - Part 4 (1:00)
9. Working with cells, columns and rows - Part 5 (1:51)
9. Working with cells, columns and rows - Part 6 (1:34)
Excel Basic Formatting
10. Excel basic formatting - Part 1 (4:55)
10. Excel basic formatting - Part 2 (4:21)
10. Excel basic formatting - Part 3 (2:06)
10. Excel basic formatting - Part 4 (3:03)
10. Excel basic formatting - Part 5 (3:03)
Autofill and Flash Fill Options
11. Autofill and flash fill options - Part 1 (6:14)
11. Autofill and flash fill options - Part 2 (2:27)
Workbook View Options
12. Workbook view options - Part 1 (5:52)
12. Workbook view options - Part 2 (2:42)
Saving Workbooks
13. Saving workbooks (4:48)
Basic Calculations and Cell References
14. Basic calculations and cell references - Part 1 (4:46)
14. Basic calculations and cell references - Part 2 (4:19)
14. Basic calculations and cell references - Part 3 (3:04)
14. Basic calculations and cell references - Part 4 (2:45)
14. Basic calculations and cell references - Part 5 (5:07)
14. Basic calculations and cell references - Part 6 (2:49)
Working with Comments
15. Working with comments (3:46)
Working with Paste Special Commands
16. Working with paste special commands - Part 1 (5:17)
16. Working with paste special commands - Part 2 (5:42)
Optimizing the Data (Autofilter)
17. Optimizing the data (Autofilter) - Part 1 (3:54)
17. Optimizing the data (Autofilter) - Part 2 (2:50)
17. Optimizing the data (Autofilter) - Part 3 (5:30)
17. Optimizing the data (Autofilter) - Part 4 (2:18)
Basic Sorting Methods
18. Basic sorting methods - Part 1 (2:47)
18. Basic sorting methods - Part 2 (3:01)
18. Basic sorting methods - Part 3 (3:46)
Using Subtotal Functions to Analyze the Data
19. Using subtotal function to analyze the data - Part 1 (3:21)
19. Using subtotal function to analyze the data - Part 2 (4:28)
Search and Editing the Data
20. Search and editing the data - Part 1 (3:51)
20. Search and editing the data - Part 2 (3:12)
20. Search and editing the data - Part 3 (2:08)
20. Search and editing the data - Part 4 (2:56)
Data Visualization - Basic Illustrations
21. Data visualization - basic illustrations (4:26)
Building Basic Charts
22. Building basic charts (3:43)
Manipulate with Chart Elements
23. Manipulate with chart elements - Part 1 (3:16)
23. Manipulate with chart elements - Part 2 (5:37)
23. Manipulate with chart elements - Part 3 (0:22)
Building Sparklines
24. Building sparklines (4:52)
Page Layout Options
25. Page layout options - Part 1 (4:25)
25. Page layout options - Part 2 (1:10)
25. Page layout options - Part 3 (1:43)
25. Page layout options - Part 4 (3:00)
25. Page layout options - Part 5 (3:27)
Conclusion
26. Conclusion (1:34)
Teach online with
6. Navigating your way around Excel - Part 1
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock