Excel 2016 Intermediate
Excel 2016 Intermediate 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/2HDoEpM
Manuals: https://bit.ly/30xZb59
Username: manuals
Password: password
Flash Fill 0:03
List Design & Single Level Sorting 2:28
Multi-Level Sorting 4:52
Custom Sorting 8:20
Filtering 11:33
Multi-Level 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
Multi-Level 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
Multiple-Field 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 2016 Intermediate канала Learnit Training
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/2HDoEpM
Manuals: https://bit.ly/30xZb59
Username: manuals
Password: password
Flash Fill 0:03
List Design & Single Level Sorting 2:28
Multi-Level Sorting 4:52
Custom Sorting 8:20
Filtering 11:33
Multi-Level 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
Multi-Level 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
Multiple-Field 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 2016 Intermediate канала Learnit Training
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Excel 2016 AdvancedTop 25 Excel 2016 Tips and TricksExcel VBA Part 2Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)How to Pass Intermediate Excel Employment Test: Questions and AnswersProject Beginner TutorialExcel VBA Beginner Tutorial50 Ultimate Excel Tips and Tricks for 2020Outlook 2016 Advanced TutorialMicrosoft Excel 2016 - Learn Excel 2016 Beginners Tutorial VideoMicrosoft Excel Tutorial for Beginners - Full CourseAccess Beginner TutorialTop 10 Most Important Excel Formulas - Made Easy!How to build Interactive Excel DashboardsExcel VBA Advanced TutorialExcel Basics 1: Introduction To Excel 1: Formatting, Formulas, Cell References, Page SetupHow to Pass Excel Assessment Test For Job Applications - Step by Step Tutorial with XLSX work filesVLOOKUP Tutorial for Excel - Everything You Need To KnowTop 15 Advanced Excel 2016 Tips and Tricks