Level Up Your Excel Skills with These Key Techniques!

Learn how to export file lists from File Explorer to Excel with clickable hyperlinks for easy navigation. Protect specific cells in your workbook, lock cells without affecting slicers, and create dynamic stock charts for financial insights. Dive into the latest features with new checkboxes, the PIVOTBY function, and automatically changing titles and tab names.

Get introduced to Copilot in Excel for smarter work and customize your views with Sheet View for tailored experiences. Streamline navigation by creating a Table of Contents with bookmarks and design stunning charts like ‘The Economist’ with sleek bar visuals. These lessons are packed with practical tools to make your work faster, smarter, and more professional in Excel!

Lessons included:
1. Export a List of Files from File Explorer to Excel with Hyperlinks
2. Protect Specific Cells in an Excel Workbook
3. Lock Cells but NOT Slicers in Excel
4. Create a Stock Chart in Excel - Excel Charting Skills
5. New Checkboxes in Excel
6. The PIVOTBY Function in Excel
7. Change Title and Tab Name Automatically in Excel
8. Introduction To Copilot In Excel
9. Customize Views with Sheet View in Excel
10. Creating a TOC with Bookmarks
11. Create a SLICK Bar Chart like 'The Economist'