Microsoft Excel quick and easy

 

New Excel tutorial every week

How to Highlight Every Other Row in Excel

How to Highlight Every Other Row in Excel (Quick and Easy)

Today we’re gonna have a look at how to highlight every other row in Excel, quick and easy, no matter the size of the data table.

How to Make Borders in Excel

How to Make Borders in Excel

Today’s tutorial is not only about how to make borders in Excel, but also how to erase or remove the borders completely.

How to Rename Legend in Excel Graph

How to Rename a Legend in an Excel Chart (Two Different Ways)

This tutorial describes two different ways how we can rename a legend in an Excel chart. So, let’s start with the first one, the easiest way.

How to Calculate Weighted Average in Excel

How to Calculate the Weighted Average in Excel (using the function SUMPRODUCT)

This tutorial offers a quick and easy way how to calculate a weighted average in Excel. Are you curious to learn more?

How to Insert Bullet Points in Excel

How to Insert Bullet Points in Excel (Quick and Practical Solution)

In this tutorial, we’ll be having a look at a quick and practical solution to how to insert bullet points in Excel.

How to Count Words in Excel

How to Count Words in Excel (Quick and Easy)

This tutorial takes you through how to count words in Excel. So, you’ll be able to find out the exact word count in an Excel spreadsheet.

How to Create Hyperlink in Excel

How to Create a Hyperlink in Excel (3 Most Common Types of Hyperlinks)

In this tutorial, we’ll have a look at how to create a hyperlink in Excel. We’ll show you three most commonly used types of hyperlink.

How to Link Cells in Different Excel Spreadsheets

How to Link Cells in Different Excel Spreadsheets (In One or More Excel files)

Learn how to link cells from a different spreadsheet located in the same workbook and also from completely different Excel file.

How to Add a Target Line in Excel Graph

How to Add a Target Line in an Excel Graph

If you need to show a target value in a graph we’ll teach you how to add a target line in an Excel graph in a quick and easy way.

How to Use SUMIF Function in Excel

How to Use SUMIF Function in Excel (Step by Step)

This tutorial offers a step-by-step guide on how to use the SUMIF function in Excel. Let’s have a look at a couple of examples together!