ExcelTips Annual Archives

Thousands of people currently benefit from receiving a free issue of ExcelTips on a weekly basis. Past issues of ExcelTips are available in our convenient ExcelTips annual archives. Imagine having your own enhanced archive of ExcelTips to use at any time! Imagine how much you will learn with all that information at your fingertips!

Contents

Each volume of the ExcelTips archives includes the individual tips, organized by subject, in an electronic book. In addition, each archive includes the original issues of the ExcelTips newsletters, in plain-text format. The electronic book version of ExcelTips is especially helpful. The books are provided in Adobe Acrobat (PDF) format and Microsoft Word format. In these formats you enjoy the following features:

• Updated content not originally in the electronic newsletters.
• Screen shots that illustrate what you see in Excel as you follow the step-by-step instructions.
• The ability to view, search, and print the book.
• The ability to select and copy sections of text, such as macro code.
• A clear indicator that shows to which version of Excel the tips applies.
• Hyperlinks to internal content (in the book itself) and referenced resources on the Web.

The Word-formatted and PDF versions are suitable for printing and maintaining your own book of ExcelTips.

Volumes Available

ExcelTips archives are published annually, so each volume covers a specific calendar year. To get an idea of what each volume contains, click on the volume name in the table below. You will see a complete table of contents for each volume, organized by topic.

Prices

ExcelTips archives are available for the low price of only $24.99 each. If you prefer, you can order your archives on CD-ROM for only $32.99. Compare that to regular computer books which can easily cost more for less information. Plus, the ExcelTips archives give you the power and convenience of having electronic files.

Special Bonus

Longtime ExcelTips subscribers know that keeping track of what is in the archives can be a challenge. Each individual volume is designed to be "stand alone," so that you can have easy access to a full year's worth of ExcelTips. What about if you have more than a year's worth, however?

Beginning with the ExcelTips 2020 archive, I'm including an exhaustive index to the five years preceding the archive. So, for instance, the ExcelTips 2020 archive contains an index for the years 2016 through 2020, while the ExcelTips 2023 archive contains an index for the years 2019 through 2023. This is provided at absolutely no charge. (I used to charge extra for this index, but now you receive it as a free bonus!.) This index consists of two files:

• Comprehensive List of ExcelTips. An alphabetic listing of all ExcelTips published during the five-year span. This book is provided in both Word and PDF formats.
• Comprehensive List of ExcelTips, by Version. An alphabetic listing of all ExcelTips published during the five-year span, organized by the version of Excel to which each tip is applicable. This book is provided in both Word and PDF formats.

This bonus tool is designed to help you find tips more easily. If you own two or more archive volumes, you will find this add-on to be very valuable as you refer to it again and again.

Remember—this bonus tool is available only beginning with the ExcelTips 2020 archive, not with archives from earlier years.

Order Your ExcelTips Archives Today!

Each download item shown below includes the size of the download file. (When you're dealing with hundreds and hundreds of pages per archive volume, files can get large.) If you have a slow connection to the Internet, you can save precious time by ordering your archives on CD-ROM, instead of as a download.

The ExcelTips archives include PDF documents. To read these documents, you need to have either Adobe Acrobat or Adobe Reader on your system. Adobe Reader is free to download; click the link to get the latest version.

Archive Year	Dates Covered	Tips	CD	Download
ExcelTips Ribbon 2019 (for Excel 2007, 2010, 2013, 2016, 2019, and Office 365 users)	5 Jan 19 — 28 Dec 19	312 tips	(444 pages) $32.99 $23.09	(7.2 MB) $24.99 $17.49
ExcelTips Ribbon 2020 (for Excel 2007, 2010, 2013, 2016, 2019, and Office 365 users)	4 Jan 20 — 26 Dec 20	312 tips	(403 pages) $32.99 $23.09	(7.5 MB) $24.99 $17.49
ExcelTips Ribbon 2021 (for Excel 2007, 2010, 2013, 2016, 2019, and Microsoft 365 users)	2 Jan 21 — 25 Dec 21	312 tips	(376 pages) $32.99 $23.09	(6.6 MB) $24.99 $17.49
ExcelTips Ribbon 2022 (for Excel 2007, 2010, 2013, 2016, 2019, 2021, and Microsoft 365 users)	1 Jan 22 — 31 Dec 22	208 tips	(403 page) $32.99 $23.09	(6.5 MB) $24.99 $17.49
ExcelTips Ribbon 2023 (for Excel 2007, 2010, 2013, 2016, 2019, 2021, and Microsoft 365 users)	7 Jan 23 — 30 Dec 23	314 tips	(423 pages) $32.99 $23.09	(8.2 MB) $24.99 $17.49