Скачать с ютуб How to create Table of Contents for Excel - 2023 в хорошем качестве

How to create Table of Contents for Excel - 2023

Create a Table of Contents in Excel using Hyperlinks. Learn four different ways of creating hyperlinks. How to manage and remove them. Also learn how to use the new (2023) Navigation pane in Excel. Contents --------------- 00:00 - Why create Table of Contents? 00:22 - Create TOC sheet 00:37 - Add Hyperlinks 01:48 - Use Defined Names 02:26 - Use Right Drag with Alt key 02:57 - Add a Back link 03:08 - Use HYPERLINK() function 04:28 - Formatting the hyperlinks 05:11 - Add Link icon to hyperlinks 05:52 - Remove hyperlinks 06:29 - Remove all hyperlinks using a macro 06:40 - Create TOC using Navigator 08:53 - Summary Buy Dr Nitin's latest book ----------------------------------------- Efficiency Best Practices for Microsoft 365 130 best practices everyone must know Work Smarter, Grow Faster https://s.efficiency365.com/bk Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario. Dr Nitin's Office Masterclass ---------------------------------------------- https://hi.switchy.io/mms Online Courses by Dr Nitin Paranjape -------------------------------------------------------------- Pivot Table Advanced - https://s.efficiency365.com/ptyt Excel to Power BI - https://swiy.io/uxlpbi Learn more from 1000+ blog articles by Dr Nitin Paranjape Efficiency 365 blog: https://efficiency365.com/blog LinkedIn :   / nitinparanjape   Twitter :   / drnitinp   Production -------------------- Music and Effects: https://elements.envato.com/ Created using Adobe Premiere: https://www.adobe.com/in/creativeclou... AI based captions: https://videoindexer.ai (Microsoft service)