Excel Tutorials

How to Make a Histogram in Excel

In this tutorial we’re going to have a look at how to make a histogram in Excel, which is one of the ways to create a clear visual representation of data.

How to Hide Formulas in Excel (Quick and Easy)

This tutorial offers a quick and easy way how to hide formulas in Excel. Thanks to these set of steps no one will be able to see the formulas you used in a data table.

How to Number Rows in Excel (The Simplest Way)

This video tutorial offers the simplest way how to number rows in Excel.Would you like to know more? Keep watching!

How to Capitalize First Letters in Excel (PROPER Function)

In today’s tutorial we’re going to have a look at how to capitalize first letters in Excel even if the source cells vary in the number of words and contain a mix of capital and lower-case letters.

How to Change Lowercase to Uppercase in Excel

Today we’ll going through how to change lowercase to uppercase in Excel and we’ll even deal with cells containing mixed upper- and lower-case letters.

How to Change Date Format in Excel (the Simplest Way)

This tutorial offers the simplest way how to change any date format in Excel to the format you need. Let’s have a look then!

How to Change Capital Letters to Lowercase in Excel

Today we’ll be talking about how to change capital letters to lowercase in Excel and we’ll even deal with cells containing mixed upper- and lower-case letters.

How to Fix: Arrow Keys Not Working in Excel

In this tutorial we’re going to have a look at how to fix the arrow keys when they’re not working correctly in Excel.

How to Sort by Date in Excel (in a Quick and Convenient Way)

Today we’ll be talking about how to sort by date in Excel. We’ll go through a quick and convenient way how to sort dates in a table.

How to Clear Formatting in Excel (The Simplest Way)

Here we are with the simplest way how to clear formatting in Excel. It is super handy, if you want to get rid of all formatting at once.