Welcome to Five Minute Lessons

Get free online courses where you can learn more about Google Analytics, Microsoft Excel, and Microsoft Word, and be more productive in just five minutes.

Search the site for help on a problem you have right now or browse the lessons below to improve your skills. We're adding new lessons all the time, so check back often.

Calculating the current date and time in an Excel spreadsheet

There are many scenarios where you may need to use the current date and time in your spreadsheets. You may simply need to display the current date in a spreadsheet report. Or, you may need to perform a calculation that uses the current date or time. This lesson shows you how to enter a formula into a cell in Excel that outputs the current date and/or time, and updates automatically as time passes.

Learn More about Calculating the current date and time in an Excel spreadsheet

Select all the blank cells within a range of cells

If you have a range of cells, of which some contain values and some are blank, and you want to select just the blank cells, there is a quick way to select those blank cells that doesn’t involve manually clicking on every one.

Learn More about Select all the blank cells within a range of cells

Calculate a running total of a column of cells in Excel

If you have a column of numbers and you want to calculate a running total of the numbers alongside, you can use the SUM() formula combined with a clever use of absolute and relative references.

Learn More about Calculate a running total of a column of cells in Excel

Dummy lesson

Additional Info

Search Suggestions

      Join our mailing list

      Mailing List
      presentation-icon

      Sample Graphic for other Call To Action Purposes

      Sample Graphic for other Call To Action Purposes

      Scroll to Top