Sheet Names in Excel | Cell Function | Power Query
In this video, we will talk about how to extract Sheet Names in Excel using cell function as well as power query.
How to get a list of all the sheet names in the current workbook without using VBA.
This is useful if you have a large workbook with hundreds of sheets and you want to create a table of contents. This method uses Excel 4 macro functions.
These functions aren’t like Excel’s other functions such as SUM, VLOOKUP, INDEX, etc. These functions won’t work in a regular sheet, they only work in named functions and macro sheets. For this trick, we’re going to use one of these in a named function.
Functions/Features covered in this exercise include Cell, Find, Name Ranges, Index, Replace and Power Query etc
00:00 Intro
00:15 Sheet Name using from a cell
02:23 All Sheet Names in the current workbook
04:52 Sheet and File Names from a Folder
Also, check these videos if you want to learn more
1 Min Excel: If you enjoy short videos check this section
• Shorts : Random
Excel: Check this playlist for Excel-related things
• Excel
Keyboard Shortcuts: Check this section to save some time in everyday excel work
• Excel Keyboard Shortcuts
Pivot Tables: Check this playlist for Pivot Table, Slicers, and Auto refreshing reports
• Pivot Tables
Power Query: Check the Power Query playlist for Data Preparation & its Automation
• Power Query
Power BI: Check the PowerBI related videos for Business Intelligence, Dashboard & Visualisations
• Power BI
Please subscribe to our channel and Follow us on other social media platforms for regular updates :
Tiktok https://vm.tiktok.com/ZSH28XEt/
Facebook / datacense
Twitter / datacense
LinkedIn / datacense
Instagram / datacense32
Watch video Sheet Names in Excel | Cell Function | Power Query online without registration, duration hours minute second in high quality. This video was added by user DataCense 11 November 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,753 once and liked it 32 people.