HowToGeek on MSN

How to Clean Up and Import Data Using Power Query in Excel

In 2010, Microsoft added yet another technical term—Power Query—to Excel's long list of jargon, but it's not as complex as it ...
JournalofAccountancy

Microsoft Excel: Create an automated list of worksheet names

Q. I have an Excel workbook with dozens of custom-named worksheets. Is it possible to create a list of those worksheet names in Excel without having to retype them? A. Yes, you can create a list of ...