Microsoft Excel quick and easy

 

New Excel tutorial every week

How to Hide Gridlines in Excel

How to Hide Gridlines in Excel (the Easy Way)

In this short tutorial you’ll see the easiest way how to hide gridlines in Excel, either in the whole spreadsheet or in a selected area.

How to Show or Hide Ribbon in Excel

How to Show or Hide the Ribbon in Excel (Quick and Easy)

Today we’ll have a look at how to show or hide the ribbon in Excel. And you’ll see – it’s no rocket science. Let’s get started!

How to Show or Hide Formula Bar in Excel

How to Show or Hide the Formula Bar in Excel (Quick and Easy)

If you’re curious how to hide or show the formula bar in Excel you’re on the right place. Learn how to quickly show or hide the formula bar in Excel!

How to Use IF Function in Excel

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

In this tutorial, you’ll see how the function IF helps evaluate whether the sales for a particular month met the goal that had been set.

How to Use VLOOKUP Function in Excel

How to Use the VLOOKUP Function in Excel (Step by Step)

This tutorial offers a detailed description of how to use VLOOKUP in Excel. The VLOOKUP function in Excel performs a case-insensitive lookup.

How to Calculate the Range in Excel

How to Calculate the Range in Excel (in 3 easy steps)

Learn three easy steps to calculate the range of a set of data in Excel, no matter how many values there are in the data table you’re working with.

How to Calculate Age From Date of Birth in Excel

How to Calculate Age Using a Date of Birth in Excel (The Easy Way)

Learn how to calculate age using a date of birth in Excel. You’ll be able to find out the exact number of years that passed from a date of birth until now.

How to Search in Excel Sheet

How to Search in Excel Sheet (From Basic to Advanced)

Sometimes the function Search in Excel comes handy. Let’s have a look together at how to search in an Excel sheet in a simple and easy way.

How to Generate Random Numbers in Excel

How to Generate Random Numbers in Excel (3 Different Ways)

This tutorial covers how to generate random numbers within any range you define, whether you need to generate whole numbers or decimals.

How to Convert an Excel File into PDF

How to Convert an Excel File into PDF

This tutorial is about how to convert an Excel file into PDF conveniently, directly in Excel, so that you wouldn’t need to install any new software.