17. Optimizing the data (Autofilter) - Part 1 | Six Sigma Training

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

17. Optimizing the data (Autofilter) - Part 1

Complete and Continue