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
Смотрите видео Sheet Names in Excel | Cell Function | Power Query онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь DataCense 11 Ноябрь 2020, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 2,753 раз и оно понравилось 32 людям.