Excel Basics

Learn the basics of Excel by reviewing easy to follow tutorials, tricks, and tips.

Excel Rounding Functions

Rounding functions in Excel

0
Complete overview of rounding options in Excel.

Autofilter in Excel

0
AutoFilter Excel offers an easy way to search or modify complex data sets using the AutoFilter feature. In order to use...

Display Formula and Value Simultaneously

0
Ever need to display a formula and value simultaneously in the same spreadsheet? This could not be easier to...

How to apply Multiple Filters in Excel

0
We are going to cover how to use Multiple filters in Excel. A Filter is cumulative, this implies that you can apply...

Clear a filter in Excel

0
After filtering has been done, you might want to change or do away with the filtering. Clearing can...

Randomly Sort Data in Excel

0
Learn to randomly sort data in Excel by using this simple trick. The RAND Function can be used to randomly sort a data set by applying a numerical number.

Delete Multiple Rows of data

0
In some cases, there is a need to delete multiple rows of data in Excel. When dealing with large data sets, there...

Linked Checkbox – True / False

0
Before starting this tutorial, please ensure that you are familiar with adding a checkbox into an Excel worksheet. Also, it may help...

Find and Select

0
This tutorial is going to review the Find & Select button in the Home section of the ribbon. Let’s say...

Create a Dynamic Name Range Table in Excel

0
Learn to create a dynamic name range in Excel

Latest Tutorials

Year Function

YEAR Function

Delete Multiple Rows of data