Microsoft Excel Resources

A clearly written, no-nonsense guide that is just what I needed.

– From a review of Excel for Beginners by Opossum on Amazon.com dated December 1, 2017.

Note: All prices below are in U.S. Dollars, but if you go to your country-specific store you can see the price in your local currency. If you shop on Amazon, this is the link to my author page there. See below for books, Excel templates, and blog posts.

Books:

If you want to take your Excel knowledge from absolute beginner to advanced intermediate in one fell swoop, then your best bet is Excel Essentials. It’s available in paperback on Amazon or Barnes & Noble for $39.95. If you want an ebook version, it’s available for direct sale on my payhip store as well as Barnes & Noble, Apple, and Kobo for $19.95.

Excel Essentials 20190222

Excel Essentials includes the following four titles which are available on a standalone basis for $12.95 paperback and $5.99 ebook through Amazon, Barnes & Noble, Apple, Kobo, Google, as well as some libraries and subscription services. Click on each image to access store-specific links or you can buy the ebooks direct through Paypal using Payhip by clicking here and choosing the Excel Essentials option.

Excel for Beginners open sans boldv2Intermediate Excel Open Sans

50 Excel Functions open sans

50 More Excel Functions open sans

 

 

 

 

Now through June 29, 2019 use promotional code BNPEE15 at Barnes & Noble and receive an additional 15% off the ebook version of any of the Excel Essentials titles.

If you just need information on one specific topic, like Pivot Tables, then the Easy Excel Essentials series contains excerpts from the Excel Essentials titles. These are available for $5.99 paperback and $2.99 ebook. Keep in mind these are short, focused titles so if you’re not sure what you need the larger books are probably the best choice. Again, click on the book image for links to your chosen store. These are available on all stores except Google.

Pivot Tables open sansConditional Formatting open sansCharts open sansIf Functions open sansFormatting open sansPrinting open sans

 

 

 

 

You can also test your knowledge of the material covered in the first three Excel Essentials books using the following quiz books, which are each available for $3.99 ebook or $9.99 paperback.

Excel for Beginners Quiz Book 20181202     Intermediate Excel Quiz Book 20181202    50 Functions Quiz Book 20181202

 

 

I do also have some specialty Excel titles available as well as a handful of non-Excel titles that you may find of interest. Most are $5.99 in ebook, but Mail Merge for Beginners is only $2.99 in ebook.

Excel for Writers open sans   Excel for SP open sansExcel for Budgeting open sansBudgeting for Beginners open sans

 

 

 

Word for Beginners open sansIntermediate Word open sansPowerpoint for Beginners open sans bold

Mail Merge

Excel Templates:

To go along with those specialty books I offer a few Excel templates available for 99 cents or $2.99. These are only available on the Payhip Store)

Excel for Budgeting excel template     Excel for SP Excel Template     Excel for Writers excel template

Blog Posts:

I’ve also written a few blog posts that may be of interest to you:

A Quick Excel Copy and Paste Trick

How to Count TRUE or FALSE Entries in a Range

A Little Reminder on Backwards Compatibility

Using Excel for an Optimization Problem

How to Split a Cell Diagonally in Excel

The Excel PRODUCT Function

Excel for Budgeting is Live

Excel Essentials Quiz Books Now Available

A New Release: 50 More Excel Functions

 

There are also video courses available for Excel for Beginners, Intermediate Excel, and Excel for Self-Publishers. You can get discount codes here.