Microsoft Excel quick and easy

 

New Excel tutorial every week

How to Group Rows in Excel

How to Group Rows in Excel (Automated and Manual Way)

This tutorial is about how to group rows in Excel, which is very handy when it comes to data organisation.

How to Convert Text to Number in Excel

How to Convert Text to Number in Excel (Three Quickest Ways)

Here we are again with the three quickest ways how to convert text to number in Excel. You can choose which one seems most convenient for you.

How to Create a Heat Map in Excel

How to Create a Heat Map in Excel (Quick and Easy)

In today’s tutorial we’re going to have a look at how to create a heat map in Excel, which comes quite handy when you’d like to provide a clear overview of data in terms of the highest, lowest, and middle values.

How to Resize Multiple Columns in Excel

How to Resize Multiple Columns in Excel (3 Most Common Ways)

Today we’ll be talking about three most common ways how to resize multiple columns in Excel, so you’ll be able to choose which one works best for you.

How to Show Gridlines in Excel

How to Show Gridlines in Excel (Quick and Simple)

If, for some reason, there appear no gridlines in an Excel spreadsheet and you need them to show, we’re going to talk about that.

How to Insert Degree Symbol in Excel

How to Insert the Degree Symbol in Excel (Two Useful Ways)

Today we’re going to go through two useful ways how to insert the degree symbol in Excel and we’ll have a look at how to use the symbol in texts as well as with numbers.

How to Insert Calendar in Excel

How to Insert a Calendar in Excel (the Simplest Way)

Today we’ll be talking about how to insert a calendar in Excel. Thanks to this function you’ll be able to use a date picker, which allows you to comfortably enter dates in data tables.

How to Insert Check Mark in Excel

How to Insert Check Mark in Excel (the Simplest Way)

In this tutorial we’re going to have a look at how to insert a check mark (a tick) in Excel, which can, in some cases, be an effective way to improve the clarity of a data table.

How to Add Developer Tab in Excel

How to Add Developer Tab in Excel

Today we’ll be talking about how to add the Developer tab in Excel, which is necessary if you want to create VBA applications, design forms, create macros, or import and export XML data.

How to Make a Histogram in Excel

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.