You can use a menu command to create a hyperlink to a named range or you can use a simple drag-and-drop trick. Adding a hyperlink to an Excel sheet is a simple enough task, but like so many Office ...

Create a report using charts: Select Insert > Recommended Charts, then choose the one you want to add to the report sheet. Create a report with pivot tables: Select Insert > PivotTable. Select the ...