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.

Books:

See the Buy Direct page for bulk order print options for those in the U.S.

Note: If you shop on Amazon, this link will take you to the M.L. Humphrey author page where you can find all of the books listed below. Otherwise you can click on a book image to be taken to a page to choose your store for your country for that book or you can choose the store-specific page on the right-hand side of this website and click on the book you want to be taken to in that store.

If you just want to learn the basics you need to know to use Excel on a daily basis, then start with Excel for Beginners or Excel 2019 Beginner. You can also start with Microsoft Office for Beginners which includes Excel for Beginners but also covers Word and PowerPoint.

If you already know the basics and want to learn about more advanced topics such as pivot tables, charts, conditional formatting, and more then try Intermediate Excel or Excel 2019 Intermediate.

If you want to learn about how to use formulas and functions in Excel, then try 50 Useful Excel Functions and 50 More Excel Functions or Excel 2019 Formulas & Functions.

For Excel 2019, if you learn better with a question and answer format or want to test your knowledge, then try the Excel 2019 Formulas and Functions Study Guide.

In addition to the above titles, the Easy Excel Essentials series covers specific topics such as PivotTables and Conditional Formatting that are included in the main titles above and the Excel Essentials Quiz Books provide questions and answers to test your knowledge of the Excel Essentials material. (List of titles and links available for each store on the store page on the sidebar.)

For Excel 2019, use the Easy Excel Essentials 2019 series instead which has books on PivotTables, Charts, Conditional Formatting, and the IF Functions.

Videos:

Excel for Beginners, Intermediate Excel, and the Easy Excel Essentials content are also available as video courses through my Teachable store. Use the code MLH50 to get 50% off of the price of Excel for Beginners or Intermediate Excel.

Blog Posts:

This site also contains the following 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

An Interesting Excel Question

How to Split a Cell Diagonally in Excel

The Excel PRODUCT Function