Microsoft Excel quick and easy

 

New Excel tutorial every week

How to Remove Formula in Excel

How to Remove a Formula in Excel (The Easiest Way)

Today we’re going to go through the easiest way how to remove a formula in Excel. First, we’re going to have a look at how to remove a formula in a selected area, for example in a specific column.

How to Highlight Duplicates in Excel

How to Highlight Duplicates in Excel (Super Easy)

In this tutorial we’re going to have a look at how to highlight duplicates in Excel in a column, multiple columns or, if needed, throughout a data table of any size.

How To Remove Table Formatting In Excel

How to Remove Table Formatting in Excel (On Three Different Levels)

Today’s tutorial talks about how to remove table formatting in Excel on three different levels. Ready to start?

How to Make a Table in Excel

How to Make a Table in Excel (Format as Table)

In this tutorial, we’re going to have a look at how to make a table in Excel. Thanks to the function ‘Format as Table.

How many Rows and Columns in Excel

How Many Rows and Columns There Are in Excel (And How to Jump to the Last Row or Column)

Today we’re going to talk about how to find out the number of rows and columns in a spreadsheet. And not only that.

How to Enable Dark Mode in Excel

How to Enable Dark Mode in Excel (The Ultimate Guide)

This tutorial is about how to enable dark mode in Excel. You’ll see how to switch to dark mode and use the ribbon, all the bars and headers or even the whole worksheet in dark colours.

How to Freeze Multiple Rows in Excel

How to Freeze Multiple Rows in Excel (Quick and Easy)

Today we’ll have a look at how to freeze multiple rows in Excel, specifically, how to freeze and unfreeze the first two rows.

How to Freeze Columns in Excel

How to Freeze Columns in Excel (A Single or Multiple Columns)

In this tutorial we’re going to talk about how to freeze single or multiple columns in Excel.

How to Use Flash Fill in Excel

How to Use Flash Fill in Excel (And Save a Lot of Time)

Today we’ll be talking about how to use Flash Fill in Excel. This little miracle among functions can recognise a pattern and based on this, fill in missing data automatically, so you won’t have to enter them manually nor use complicated formulas. Flash Fill will do it for you making it a real time-saver. Let’s see how it...

How to Concatenate in Excel

How to Concatenate in Excel (Quick and Easy)

In this tutorial we’re going to talk about how to concatenate in Excel. Thanks to this function, you’ll be able to link the contents of several different cells.