• Skip to main content
  • Skip to secondary menu
Productivity Portfolio logo

Productivity Portfolio

Valuing your time & technology

  • HOME
  • Tutorials
    • Excel
    • Google
    • Word
    • Outlook
    • Terms
  • Quick Tips
    • Email
    • Security
    • Web
    • Windows
    • Internet of Things
    • Cell
  • Reviews
    • Health
    • Services
    • Software
    • Hardware
  • About
    • About Me
    • Contact Page
    • Privacy Policy
  • Newsletter
  • Resources
    • Practical Gift Ideas
    • Books
    • Favorite Podcasts
    • Online Courses
    • Online Services
  • SEARCH

Excel Tutorials

Below is a list of the Microsoft Excel tutorials that we've written. Many include step by step instructions. In some cases, there may be sample spreadsheets or video screencasts.

I've also been updating these articles to reflect the latest Excel version. Presently, I'm using Microsoft Office 365. However, you may see some tutorials that reflect older versions. All the screen snaps have been done on a Windows computer and reflect those commands.

If you don't have Microsoft Excel, there are three options:

  1. Get an Office 365 (Subscription service)
  2. Buy Microsoft Office 2019 (One time purchase)
  3. Use the free version in your browser

The free version does require you to have a Microsoft account. As you might expect of a free product, there are limitations. For example, you can open a workbook that has macros, but you won't be able to edit them.

You can read more about the different options on the Microsoft site.

Microsoft also has an Excel Glossary that you can use.

Excel macro dialog box.

The Basics of the Excel Macro Editor

This Excel tutorial is the follow up to the previous article we did on using Excel's built-in macro recorder. It will introduce you to the macro editor and layout so you can create or edit your own macros. It's also a great way to learn how the macros work.
Read More
Record macro dialog box

Easy Way to Learn the Excel Macro Recorder

If you've ever wanted to dabble with Excel macros, this tutorial and video on the macro recorder will get you started. Includes a sample workbook link so you can follow along.
Read More
Selecting custom filter from menu.

How to Use Excel to Find Invalid Email Addresses

This week was one where multiple requests converged. I had two friends that needed to send emails to their customers. One had their information in an Excel spreadsheet and the other exported their internal databases to Excel. Both thought there were problems with many email addresses and wanted to know if there was an easy way to find invalid email addresses before sending out the emails.
Read More
  • ‹
  • 1
  • 2
  • 3
  • 4
Loading...

© 2021 · Productivity Portfolio | PO BOX 117361 Burlingame, CA 94011

I use cookies to ensure that I give you the best experience on our website. If you continue to use this site I'll figure that you are happy with that. You can find more details in the privacy policy.OKNoPrivacy policy