101 Excel 2013 Tips, Tricks and Timesavers

Unlock new levels of Excel functionality

Nobody knows Excel like John Walkenbach. This hand-picked collection of tips and tricks helps you squeeze more functionality from this complex program and take your Excel skills to the next level. Learn to use a workbook in your browser, fine-tune formatting, send personalized e-mail from Excel, hide and lock your formulas, use pivot table slicers and timelines, and so much more.

If you're already using Excel on a regular basis but know it has capabilities you haven't tapped, open this book and let Mr. Spreadsheet open the door to a new range of Excel 2013 possibilities.

Let Mr. Spreadsheet show you how to:

• Generate a list of filenames or sheet names
• Avoid font substitution for small point sizes
• Edit formulas in dialog boxes
• Use Flash Fill to extract or combine data
• Save shapes, charts, and ranges as images