Excel 2016 Intermediate Tutorial
For ad free training and certificates please join Learnit Anytime:
https://www.learnitanytime.com
For Private Group Trainings please visit:
https://www.learnit.com/privategroup...
Join our online community! https://www.offsitebylearnit.com
Exercise Files: https://bit.ly/2HDoEpM
Manuals: https://bit.ly/30xZb59
Username: manuals
Password: password
Start 0:00
Flash Fill 0:03
List Design & Single Level Sorting 2:28
MultiLevel Sorting 4:52
Custom Sorting 8:20
Filtering 11:33
MultiLevel Filtering 15:40
Search Filtering 17:34
Format as Table 21:47
Table Style Options 25:13
Remove Duplicates 29:12
Convert to Range 34:07
Subtotal 34:51
MultiLevel Subtotaling 40:32
Remove Subtotals 42:59
Quick Analysis Charts 43:29
Inserting Data Charts 46:53
Formatting Data Charts 51:46
Chart Templates 57:21
Sparklines 1:01:28
Printing Charts 1:06:18
Importing From Web 1:08:18
MS Query 1:14:33
Exporting Overview 1:21:12
Pivot Tables 1:22:50
MultipleField Pivot Tables 1:31:03
Drill Down Reports 1:36:10
Pivot Charts & Grouping Fields 1:38:52
Slicer Tool 1:47:18
Data Validation 1:54:28
Additional Data Validation 2:03:12
Cell & Sheet Protection 2:09:30
File Encryption 2:14:58
Conditional Formatting 2:17:28
Linking Data 2:25:34
Inserting Comments 2:32:25
#Excel