Excel 365 – 100 Tips + Tricks – Part 1

Excel has plenty of useful features tucked just beyond the familiar buttons. In Excel 365 – 100 Tips + Tricks – Part 1, Peter Kynast gathers 100 concise, illustrated instructions for finding and using them. Written for Excel 365 on Windows, the book is designed for readers who already know the basics and want practical ways to work more comfortably in spreadsheets.

Small techniques, everyday usefulness

The tips move across common spreadsheet tasks: entering dates, navigating large worksheets, copying formulas, selecting cells, formatting values, and working with rows and columns. Rather than focusing on one long project, the book offers a collection of individual techniques readers can consult as their needs arise.

From tables to charts and calculations

Among the topics listed are smart tables, chart creation and updates, date calculations, pivot tables, conditional formatting, custom number formats, and creating drop-down lists. There are also tips on freezing panes, using the status bar, and recovering unsaved workbooks. Together, these subjects touch both everyday spreadsheet housekeeping and features for organizing or examining data.

Follow each step visually

The instructions are presented step by step and supported by more than 420 images. That visual guidance makes the book approachable for readers who prefer to follow a sequence of on-screen actions rather than decode a dense explanation. The author describes the material as suitable for beginners with basic Excel knowledge, while also offering experienced users additional ideas to try.

A practical reference to keep nearby

With 100 separate tips, Part 1 is well suited to browsing: open to a task that interests you, follow the illustrated directions, and add another useful Excel technique to your routine. It’s a hands-on guide for making more of Microsoft Excel 365, one small improvement at a time.