Microsoft Excel quick and easy

 

New Excel tutorial every week

How to Insert Symbol in Excel

How to Insert a Symbol in Excel

This tutorial will guide you through a few easy steps to see how to insert a symbol in Excel. Beside numbers and text, you’ll learn how to use a variety of symbols, thanks to which you’ll be able to design some impressive data tables.

How to Add a Trendline in Excel

How to Add a Trendline in Excel

In this tutorial, we’re going to cover how to add a trendline in Excel. This element is invaluable when you need to make a clear and neat visual representation of the data trend.

Try out Data Bars in Excel to See Your Data Visually

Try out Data Bars in Excel for clear graphical data representation

If you’re looking for a clear and easy-to-understand way to display data in a table you created, you’re in the right place! This tutorial offers a step-by-step guide on how to add data bars in Excel. Graphical features like data bars highlight important values in the table and point out how these are related. You’ll also see how easy it is to edit data bars or place them separately, in an individual column.

How to Use Color Scales in Excel (Conditional Formatting)

How to Use Color Scales in Excel (Conditional Formatting)

In today’s tutorial, we’re gonna talk about how to use colour scales in Excel. Thanks to colour scales, you’ll be able to design a data table with a clear overview of the maximum, the minimum as well as the middle values.

How to Insert Image in Excel Cell

How to Insert Image in Excel Cell (Correctly)

In this tutorial, you’ll learn how to insert an image in an Excel cell, in the right way. Each image inserted in the Excel sheet will be placed nice and neat within its target cell.

How to Calculate Difference Between Two Dates in Excel

How to Calculate Difference Between Two Dates in Excel

This tutorial shows how to calculate the difference between two dates in Excel. At the end, you’ll be able to conveniently use Excel formulas to figure out the exact number of years, months and days passed between two dates.

How to Combine First and Last Name in Excel

How to Combine First and Last Name in Excel

In this tutorial, we’ll have a look at how to combine the contents of two cells – in this case a first name and a family (or last) name – thanks to which we’ll have a full name merged in one cell.

How to Highlight Blank Cells in Excel (Conditional Formatting)

How to Highlight Blank Cells in Excel (Conditional Formatting)

In this tutorial, you’ll see how to highlight blank cells in Excel. Thanks to this function, you’ll be able to mark clearly all cells containing no data in a table of any size.

How to Sort Alphabetically in Excel

How to Sort Alphabetically in Excel

If you’re wondering how to sort data alphabetically in Excel, you’re in the right place! We’ll be talking about a function which you can use to sort a list of employees’ names, products, or any other list you need.

How to Remove Blank Rows in Excel - ADVANCE

How to Remove Blank Rows in Excel – ADVANCED

As promised, this tutorial will go through how to remove blank rows in Excel and make sure no data is lost whatsoever. And even though it’s advanced, it won’t give you much headache.