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 ...

Automate repetitive data entry and fix broken sorting hierarchies using Excel's powerful, hidden Custom Lists tool.

What is a Custom Template? When you work with Excel, you often find yourself performing the same tasks repeatedly. This is where creating custom templates can be a catalyst. By learning how to create ...

Microsoft recently made some significant enhancements to its Visio add-in for Excel, enabling users to create Visio diagrams from within Excel. Here's how it works. Even though Visio is easily one of ...

Is your chart boring? Try Excel’s people chart to liven things up. Susan Harkins shows you how. A people chart is an infographic, which leads me to a second definition. An infographic tells a story, ...

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 ...

Discover 87 Excel tips and tricks that will take you from a beginner to a pro. Improve your efficiency, productivity and skills with these helpful Excel techniques. Microsoft Excel was first released ...