If you need a complete list of Microsoft Excel sheet names, Microsoft Excel Power Query is fast and generates a dynamic list.

Use one or both of these simple Microsoft Excel macros to list all the sheets in an Excel workbook.

When working with Excel files that have different sheet names or layouts, Power Query can dynamically detect and extract the necessary data.

Microsoft Excel has more dataviz capabilities than you may realize. Find out how to make your data stand out with charts, PivotTables, sparklines, slicers and more.

Excel allows you quite a lot of freedom to customize your user experience via the use of macros. This tutorial will show you how to create and name worksheets using an existing list via a macro.

Let us say that we want to create a report of tax rates for different states. Launch Excel and open a blank sheet. Name the table as shown in the image and enter the values corresponding to the names.

Excel macros are like mini-programs that perform repetitive tasks, saving you a lot of time and typing. Here's everything you need to know to start programming macros yourself.