How to use ROUNDDOWN function in Microsoft Excel

In this tutorial we will learn how to use the ROUNDDOWN function in Microsoft Excel. The ROUNDDOWN function differs from the standard ROUND function in that it rounds a number […]

How to remove total from a Pivot Table in Google Sheets

In this tutorial we will learn how to remove total from a pivot table in Google Sheets. In a pivot table, the total row provides a summary of the data […]

How to Format Phone Numbers in Google Sheets

You can watch a video tutorial here. In this tutorial we will learn how to format phone numbers in Google Sheets. Formatting phone numbers in Google Sheets can help make the […]

How to delete only Filtered Rows in Microsoft Excel

In this tutorial we will learn how to delete only filtered rows in Microsoft Excel. Deleting only filtered rows in Microsoft Excel can be a useful way to quickly remove […]

How to create an Array in Microsoft Excel

In this tutorial we will learn how to create an Array in Microsoft Excel. Arrays in Microsoft Excel are sets of values organized into columns and rows. They are used […]

How to create a border in Microsoft Excel

In this tutorial we will learn how to create borders in Microsoft Excel. Borders in Microsoft Excel are lines or markings that surround cells or ranges of cells to distinguish […]

How to Compare two cells in Microsoft Excel

Microsoft Excel is a powerful tool used by millions of individuals and organizations around the world to manage, analyze, and visualize data.Excel allows users to create and manipulate spreadsheets, which […]

How to add a Drop-Down List in Google Sheets

In this tutorial we will learn how to add a Drop-Down list in Microsoft Excel. A dropdown list in Google Sheets is a type of data validation tool that allows […]

How to calculate R-squared value in Microsoft Excel

In this tutorial we will learn how to calculate R-squared value in Microsoft Excel. R-squared, also known as the coefficient of determination, is a statistical measure used in regression analysis […]

How to use F4 key in Microsoft Excel

Microsoft Excel is a powerful spreadsheet software program that is widely used for data analysis, organization, and calculation purposes. It is part of the Microsoft Office suite of productivity tools […]

How to Sort Data by Last Names in Microsoft Excel

In this tutorial we will learn how to sort data by last names in Microsoft Excel. Sorting by last name in Microsoft Excel is a way to arrange names of […]

How to use Shortcut Methods to switch tabs in Microsoft Excel

Microsoft Excel is a powerful spreadsheet software developed by Microsoft Corporation. It was first released in 1985 and has since become the most widely used spreadsheet software in the world. […]

How to use Set Range in Excel VBA

In this Tutorial we will learn how to Set Range using VBA (Visual Basic for Applications), we can perform many operations using Set Range but for this example will add […]

How to compare two columns in Google Sheets

You can watch a video tutorial here. Google Sheets is a cloud-based spreadsheet application developed by Google. Users can create and edit spreadsheets online, and can also collaborate in real-time with […]

How To Colour Cell Based On Value In Excel

When we work with a huge amount of data in Excel and need to highlight or colour certain cells based on their values then it becomes very difficult to perform […]
1 … 27 28 29 30 31 … 91