How to create Table of Contents for Excel - 2023

[@DerekBush-tu2qt]

Thank you so much! I thought I was following along really well until you opened up navigator 🤣. Thank-you, my document is much more efficient now because of you. 🏆

[@efficiency365]

Thanks @DerekBush-tu2qt
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - th-cam.com/video/rtDlORLmjlE/w-d-xo.html
Excel Green Marks - Error Checking - Best Practices - th-cam.com/video/XeLtlzd9lRY/w-d-xo.html
Excel Best Practices - Part 1 of 3 - Data Management - th-cam.com/video/rr_1ha6g6lc/w-d-xo.html
Excel Best Practices - Part 2 of 3 - Formulas - th-cam.com/video/kz_zAvMINAk/w-d-xo.html
Excel Best Practices - Part 3 of 3 - Analytics - th-cam.com/video/JNR5yx_Pg4A/w-d-xo.html
10 Excel Settings You Must CHANGE! - th-cam.com/video/vXrrXdKyJFk/w-d-xo.html
Automatic data clean up with Excel Flash Fill - th-cam.com/video/N3p_x_lXT_c/w-d-xo.html
Instant Excel Audit, Comparison and Analysis - Inquire - th-cam.com/video/cDdvUZxOUis/w-d-xo.html
Six powerful Excel Navigation Shortcuts - th-cam.com/video/bR-yMbGPq50/w-d-xo.html
Handle millions of rows in Excel - Slow to fast - th-cam.com/video/93h7rRsLF7Y/w-d-xo.html
Convert crosstab to tabular - Unpivot - Excel Power Query - th-cam.com/video/mTtOtZH-nNM/w-d-xo.html
Cheers.
Doc

[@almafigueroa8294]

Thank you! Tutorial was very good.

[@efficiency365]

Thanks @almafigueroa8294
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - th-cam.com/video/rtDlORLmjlE/w-d-xo.html
Excel Green Marks - Error Checking - Best Practices - th-cam.com/video/XeLtlzd9lRY/w-d-xo.html
Excel Best Practices - Part 1 of 3 - Data Management - th-cam.com/video/rr_1ha6g6lc/w-d-xo.html
Excel Best Practices - Part 2 of 3 - Formulas - th-cam.com/video/kz_zAvMINAk/w-d-xo.html
Excel Best Practices - Part 3 of 3 - Analytics - th-cam.com/video/JNR5yx_Pg4A/w-d-xo.html
10 Excel Settings You Must CHANGE! - th-cam.com/video/vXrrXdKyJFk/w-d-xo.html
Automatic data clean up with Excel Flash Fill - th-cam.com/video/N3p_x_lXT_c/w-d-xo.html
Instant Excel Audit, Comparison and Analysis - Inquire - th-cam.com/video/cDdvUZxOUis/w-d-xo.html
Six powerful Excel Navigation Shortcuts - th-cam.com/video/bR-yMbGPq50/w-d-xo.html
Handle millions of rows in Excel - Slow to fast - th-cam.com/video/93h7rRsLF7Y/w-d-xo.html
Convert crosstab to tabular - Unpivot - Excel Power Query - th-cam.com/video/mTtOtZH-nNM/w-d-xo.html
Cheers.
Doc

[@vijayarjunwadkar]

Great Tutorial, learnt lot more than creating hyperlinks! Thank you!

[@efficiency365]

Yes. I also learnt - while creating the video 😎

[@Mweya-87]

A Best presentation for this topic

[@efficiency365]

Thanks @Mweya-87
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - th-cam.com/video/rtDlORLmjlE/w-d-xo.html
Excel Green Marks - Error Checking - Best Practices - th-cam.com/video/XeLtlzd9lRY/w-d-xo.html
Excel Best Practices - Part 1 of 3 - Data Management - th-cam.com/video/rr_1ha6g6lc/w-d-xo.html
Excel Best Practices - Part 2 of 3 - Formulas - th-cam.com/video/kz_zAvMINAk/w-d-xo.html
Excel Best Practices - Part 3 of 3 - Analytics - th-cam.com/video/JNR5yx_Pg4A/w-d-xo.html
10 Excel Settings You Must CHANGE! - th-cam.com/video/vXrrXdKyJFk/w-d-xo.html
Automatic data clean up with Excel Flash Fill - th-cam.com/video/N3p_x_lXT_c/w-d-xo.html
Instant Excel Audit, Comparison and Analysis - Inquire - th-cam.com/video/cDdvUZxOUis/w-d-xo.html
Six powerful Excel Navigation Shortcuts - th-cam.com/video/bR-yMbGPq50/w-d-xo.html
Handle millions of rows in Excel - Slow to fast - th-cam.com/video/93h7rRsLF7Y/w-d-xo.html
Convert crosstab to tabular - Unpivot - Excel Power Query - th-cam.com/video/mTtOtZH-nNM/w-d-xo.html
Cheers.
Doc

[@pookyevildoer]

Great tips. Great content. Glad I found you! I'm now subscribed. 😊

[@efficiency365]

Thanks pookyevildoer for the feedback and sub.
Watch the related videos:
Excel Navigation Shortcuts - th-cam.com/video/bR-yMbGPq50/w-d-xo.html
Excel Go To Special - secrets and best practices - th-cam.com/video/uuUXl54vFYU/w-d-xo.html
Explore more Excel, Power BI and Analytics videos on this channel th-cam.com/play/PL-UPeBWRvha2O2TF6vfVw4lfS4honS407.html
Check out my online courses
Excel to Power BI s.efficiency365.com/upbi
Pivot Tables s.efficiency365.com/mtyt
Learn 130 essential efficiency best practices - read my latest book - s.efficiency365.com/bk
Let me know if you want me to cover any specific topics as well.
Cheers. Dr Nitin (doc) Paranjape.

[@sinthiyat3052]

No words to say.... Great job sir from tamilnadu

[@efficiency365]

Thanks @sinthiyat3052 for the feedback.
You may also like these Word related videos:
Word top 10 settings - th-cam.com/video/_8r7vNrqh34/w-d-xo.html
Word Tables - 8 ways to create: th-cam.com/video/X-G8bZVCGBk/w-d-xo.html
Word Tables - 13 problems solved: th-cam.com/video/y5IblpvN_Jg/w-d-xo.html
Word Styles - th-cam.com/video/7f_aOgsvKA0/w-d-xo.html
Word Sections - th-cam.com/play/PL-UPeBWRvha036g2sTc69H85sUd0pb4RY.html
Handing long, complex word documents - th-cam.com/video/9jrYJHQ7YmQ/w-d-xo.html
Thanks.
Dr. Nitin.

[@chandrakantha648]

Excellent Excel boss :)

[@efficiency365]

Thank you... check out the Go To Special video as well : th-cam.com/video/uuUXl54vFYU/w-d-xo.html

[@canirmalchoudhary8173]

I use an old excel button Paste as Hyperlinks, ctrl c and click on that button (Alt shortcut)

[@efficiency365]

Sure. Whatever works to simplify navigation.

[@canirmalchoudhary8173]

Using Alt key is new for me

[@efficiency365]

Yes. In general, Alt key releases the boundary of drag operation.
For example, in PowerPoint, when you use the color picker, it gets stuck within the slide boundary. If you want to go outside the boundary, keep pressing ALT and then color picker can pick color from anywhere on the screen. This is a similar situation.