Home > Sean's Technology and Writing Blog

Download a free sampler PDF from 100 Top Tips: Microsoft Excel

29 January 2021

I'd like to invite you to download a free sample of 100 Top Tips: Microsoft Excel to see the first ten pages of tips. The book is celebrating its first anniversary this week.

In this free sample, you'll learn:

How to speed up data entry with Auto Fill in Excel
How to fill a range to match the size of neighbouring columns
How to use Flash Fill to get Excel to complete a pattern of data entry for you. Teach it, for example, how to split first names and surnames, and it can do the rest automatically. This is magic!
How to adjust column widths and row heights
How to insert multiple rows or columns
Three tips for managing large spreadsheets, including freezing the title rows and columns, and using multiple windows to view different parts of the spreadsheet at the same time
How to improve your spreadsheet quality by forcing valid data entry, including using custom validation options
How to add a drop-down menu in an Excel cell
How to remove duplicate entries in your spreadsheet, for example to clean up a mailing list

This pocket-sized and budget-priced book is packed with tips that will make you more effective and more productive with Excel. Whether you're using spreadsheets to manage your small business finances, your mailing lists, or your record collection, this book will make life easier for you.

The book has a recommended retail price of £5.99. I remember someone once said that if you buy the Writers & Artists' Yearbook and actually use it, you're sure to make your money back. I feel the same about my Microsoft Excel book. I spend a lot of time using Excel, and a handful of the tips in this book would have saved enough time to cover the price of the book many times over.

The book is structured so you can dip in at any point, and includes cross-references where appropriate. That makes it a useful reference guide, and also a good book to read in small chunks, ideal for a time when many people have lots of competing pressures on their time.

Read the full table of contents and discover some more quick tips here, and find links to buy the book here. Most book shops can order books in for you and either post them to you or make them available for collection. They would particularly appreciate your support after a challenging year on the high street.

Permanent link for this post | Blog Home | Website Home | Email feedback

Dip into the blog archive

Credits

Visit www.sean.co.uk for free chapters from Sean's coding books (including Mission Python, Scratch Programming in Easy Steps and Coder Academy) and more!

Discover my latest books

100 Top Tips: Microsoft Excel

Power up your Microsoft Excel skills with this powerful pocket-sized book of tips that will save you time and help you learn more from your spreadsheets.

Scratch Programming IES

This book, now fully updated for Scratch 3, will take you from the basics of the Scratch language into the depths of its more advanced features. A great way to start programming.

Mission Python

Code a space adventure game in this Python programming book published by No Starch Press.

Cool Scratch Projects in Easy Steps

Discover how to make 3D games, create mazes, build a drum machine, make a game with cartoon animals and more!

Raspberry Pi For Dummies

Set up your Raspberry Pi, then learn how to use the Linux command line, Scratch, Python, Sonic Pi, Minecraft and electronics projects with it.

Earworm

In this entertaining techno-thriller, Sean McManus takes a slice through the music industry: from the boardroom to the stage; from the studio to the record fair.