In this Video Tutorial we are going to take a look at Top 20 Excel 2016 Tips and Tricks for both Beginners and Advanced Excel users. These tips will show you some of the most effective ways on how to use Microsoft Excel 2016.
Download the Excel Workbook here: http://bit.ly/2wj4vj8
Table of Contents
———————————-
1. SORTING COLUMNS WITH BLANK CELLS 0:56
2. MAKING THE ROWS COLUMNS AND THE COLUMNS ROWS 3:20
3. HIDE A WORKSHEET – VERY HIDDEN PROPERTY 4:20
4. BLOCKING A USER TO INTERACT OUTSIDE A SPECIFIC RANGE 6:00
5. HOW TO FREEZE TITLES AND SPLIT SCREENS 6:56
6. HOW TO ADD TEXT TO A NUMBER 9:00
7. CREATE A CONDITIONAL FORMAT BASED ON A VALUE 10:00
8. FORMULA ERROR CHECKING – TRACE ERROR 11:45
9. LOCKING AND HIDING FORMULA CELLS 13:04
10. GET RID OF UNWANTED SPACES 15:01
11. USE AUTOCORRECT TO ENTER DATA FAST 16:30
12. THE PASTE SPECIAL FEATURE 17:50
13. USE FILL HANDLE TO ENTER SEQUENCES OF VALUES 19:21
14. HOW TO GET RID OF DUPLICATE RECORDS 20:56
15. HIGHLIGHT FORMULA CELLS USING CONDITIONAL FORMATTING 22:20
16. ADD COMMENTS INSIDE FORMULAS 24:15
17. HOW TO USE FLASHFILL TO FILL VALUES IN A RANGE RAPIDLY 25:10
18. CHANGING VALUES WITHOUT FORMULAS 26:26
19. HIDING SCROLLBARS IN A WORKSHEET 27:46
20. HOW TO PROTECT WORKBOOKS, WORKSHEETS & CELLS 28:55
Subscribe to my Channel ► http://bit.ly/1KWfq14
───────────────────────────────────
Check Out My Online Courses ►►►►►►►►►►►►►►►
Excel Dashboards & Charts Masterclass ► http://bit.ly/35lO8OK
Create Excel Dashboards, Interactive Excel Graphs and Pivot Charts with Microsoft Excel 2013 + Free Excel Templates
Excel Macros & VBA for Non-Programmers ► http://bit.ly/2D3Ipkw
Become a proficient Excel Macro Programmer in a very short time + Excel VBA for beginners. Excel Templates included.
Excel Power Pivot & DAX Masterclass ► http://bit.ly/2qwa2jB
Learn Excel Power Pivot – Power Map and Excel Power BI Tools. Build Excel Data Analyst Models with Microsoft Excel 2013
Top 100 Excel Hacks with Excel 2016 ► http://bit.ly/2pEMlW8
The Best 100 Excel Tips & Hacks with Microsoft Excel 2016 – Excel Templates Included
Excel Advanced Charts Masterclass ► http://bit.ly/2qyosQr
Learn from scratch professional Advanced Excel Charts with Microsoft Excel 2013 – Excel Templates included
Python Programming for Beginners ► http://bit.ly/2s1nUTy
A Python Practical Programming Course for Absolute Beginners – Learn how to Code in Python and Improve your Productivity
The Complete Gmail Course ► http://bit.ly/2QCaUxQ
Boost your Productivity with 25+ Gmail Techniques like Gmail Filters , Security , IFTTT . Master Email Communication
────────────────────────────────────────────────────
Facebook ► https://www.facebook.com/mellontraining
My Blog ► http://www.mellontraining.com
My Online Excel Courses ► https://www.udemy.com/u/andrewex
Twitter ► https://twitter.com/mellontraining
Linkedin ► gr.linkedin.com/in/andreasexadaktylos
Youtube channel ► http://www.youtube.com/mellontraining
