How to remove numbers in Excel from the left

Microsoft Excel is a powerful spreadsheet application that is widely used for organizing, analyzing, and presenting data. One common task that users often need to perform in Excel is removing numbers from a cell’s contents. This can be useful when dealing with large datasets that have extraneous information at the beginning of each cell. Here … Read more

How to remove highlighted cells in Excel

Excel is a powerful tool for organizing and analyzing data, but sometimes we need to Remove Formatting from certain cells, such as highlighting. Highlighting cells is a useful way to draw attention to specific data, but it can also be distracting and cluttered. In this blog post, we’ll walk you through the steps to Remove … Read more

How to remove the first two characters in Excel

Microsoft Excel is a powerful spreadsheet application that is widely used for organizing, analyzing, and presenting data. One common task that users often need to perform in Excel is removing the first two characters from a cell’s contents. This can be useful when dealing with large datasets that have extraneous information at the beginning of … Read more

How to remove the first five characters in Excel

Microsoft Excel is a powerful spreadsheet application that is widely used for organizing, analyzing, and presenting data. One common task that users often need to perform in Excel is removing the first five characters from a cell’s contents. This can be useful when dealing with large datasets that have extraneous information at the beginning of … Read more

How to delete rows in Excel based on cell value

Deleting rows in Excel based on cell value means removing rows that contain a specific value in a particular cell.  This can be useful for filtering out unwanted data or cleaning up a spreadsheet with a large amount of data. The method involves using the filtering function in Excel to select only the rows with … Read more

How to delete multiple rows in Google Sheets

Deleting multiple rows in Google Sheets means removing one or more rows of data from your sheet. This action permanently removes the selected rows, along with any data they contain, from your sheet. Once you delete the rows, you cannot undo the deletion, so it’s important to make sure you have a backup of your … Read more

How to delete alternate rows in Excel

Deleting alternate rows in Excel means removing every other row from a selected range of cells deleting alternate rows in Excel can be a useful technique for data management and presentation. It can help to make your data more organized, easier to work with, and more visually appealing. In this tutorial, we will learn how … Read more

How to delete all rows below in Google Sheets

Delete all rows below in Google Sheets means removing all rows that are located below a certain row or range of rows. This action permanently deletes the selected rows and their content. In large datasets, it becomes difficult to delete each row one by one so deleting them once helps in saving and working efficiently. … Read more

How to lock cells in Google Sheets

Locking cells in Google Sheets refers to the process of preventing the content of a cell from being edited, moved, or deleted. This is particularly useful when working with sensitive or critical data, such as financial information or complex formulas. By locking specific cells or ranges of cells, you can ensure that they remain unchanged … Read more

How to keep a Running Balance in Excel

A running balance is the current total balance of an account, which takes into account all previous transactions as well as any subsequent deposits or withdrawals. A running balance is a useful tool for tracking spending and managing finances, as it provides a real-time snapshot of the account balance. It is commonly used in bank … Read more

How to increment numbers in Microsoft Excel

In Microsoft Excel an increment in numbers refers to adding a fixed value to a cell or a range of cells. This action is frequently employed to generate a sequence of numbers or other values that adhere to a particular pattern. This feature is especially advantageous when creating extensive lists or large-scale sequences of numbers. … Read more

How to categorize data in Microsoft Excel

Categorizing data in Excel is an essential process that helps to organize, sort, and analyze large datasets efficiently. It allows users to group data by various categories such as date, product, location, or any other relevant factor to facilitate better analysis and reporting. The main uses of categorizing data in Excel include easy organization, efficient … Read more

How to turn off Compatibility mode in Microsoft Excel

Compatibility mode in Microsoft Excel is an important feature that allows users to work with files created in earlier software versions. When you open an older file in a newer version of Excel, compatibility mode enables you to edit and save the file without changing its original format or features. In this tutorial, we will … Read more

How to paste in Excel with formatting

Microsoft Excel is a powerful tool that is widely used in businesses, academic institutions, and personal finance. One of the most common tasks in Excel is to copy and paste data from other sources. However, when you paste content into Excel, the formatting may not always carry over, resulting in a disorganized and difficult-to-read spreadsheet. … Read more

How to lock formulas in Excel without protecting Sheet

When you want to protect the contents of an Excel file, the most common approach is to protect the worksheet(s) with a password. However, this can be problematic if you want to share the file with others but only want to protect certain cells or ranges of cells. Fortunately, there are a few methods you … Read more

How to add Delta symbol in Excel

Delta symbol (∆) is a mathematical symbol that represents the change or difference between two values. It is commonly used in fields such as mathematics, science, finance, and engineering to represent the change in a quantity or variable. Adding the delta symbol (∆) in Excel is a straightforward process that can be done in a … Read more

How to find the slope on Excel

Slope is a graphical representation of data. Slope is used to represent  change of a quantity with respect to other quantity , mostly time. The slope explains the relationship between the independent and dependent variables.Sometimes databases where dependent and independent quantities exist become very large and it becomes difficult to understand the trend of changing … Read more

How to add numbered list in Microsoft Excel

Numbered lists are a commonly used feature in many forms of written communication, including in email, presentations, reports, and other documents. These lists help to organize information and make it easier for the reader to follow the writer’s thoughts.Numbered lists are especially important in expository writing, where the writer needs to present a series of … Read more

How to copy and paste formulas in Excel from one workbook to another

Copy and paste formulas in Excel from one workbook to another refers to the process of copying a formula from one Excel workbook to another Excel workbook. This can be done by selecting the cell containing the formula in the source workbook, copying the formula, and then pasting it into the destination workbook. Rather than … Read more

How to solve Excel error This Action Won’t Work on Multiple Selections

This error is typically shown in excel when you try to copy data. There can be multiple reasons for this error to show up. In this tutorial we will discuss causes and then give the solution for this error. Here we have a dataset which contains some data about the store, we will be checking … Read more

How to fix ByRef Argument Type Mismatch error in Excel VBA

In VBA, “ByRef” is a keyword used to declare a parameter of a subroutine or function as a “By Reference” argument. When a parameter is declared as “ByRef”, any changes made to the parameter within the subroutine or function will be reflected in the original variable that was passed in as an argument. This means … Read more

How to auto populate data in Microsoft Excel

The auto populate feature in Excel is a convenient tool that allows users to quickly and accurately fill a series of cells with data or formulas. With this feature, Excel can automatically recognize patterns in data and fill in missing values in a series.This feature can save a significant amount of time and reduce the … Read more

How to move a row down in Google sheets

Google sheets is a widely used spreadsheet application developed by Google. It allows users to store, organize, and analyze data. Google sheet also provides powerful tools and features for creating charts, graphs, and pivot tables.The data is stored in rows and columns. The graphical user interface of Google sheet allows us many tasks to do, … Read more

How to compare two dates in Excel

Comparing two dates in Excel means evaluating the relationship between the dates using different functions and operators to determine their relative position in time. It means evaluating whether the dates are the same, or if one date is earlier or later than the other. This can be useful for various purposes such as tracking progress, … Read more

How to adjust column width in Microsoft Excel

Adjusting column width in Excel is an essential aspect of formatting and organizing data within a spreadsheet. It involves resizing columns to accommodate the contents of the cells. This allows for easy viewing and editing of data, making it more accessible and user-friendly. By adjusting columns in Excel, users can ensure that their data is … Read more

How to adjust cell size in Microsoft Excel

Cell size adjustment is an essential aspect of working with Excel. When creating a spreadsheet, adjusting the size of cells allows you to fit more information into a single cell, making your spreadsheet more organized and visually appealing. Adjusting cell size can be crucial when printing spreadsheets. If cells are too large or too small, … Read more

How to add same text to multiple cells in Microsoft Excel

Adding the same text to multiple cells in a spreadsheet is a common task that can save time and improve the accuracy of data entry. By applying the same text to multiple cells, users can ensure consistency in data presentation and make it easier to analyze and manipulate data. In this tutorial we will learn … Read more

How to add different text to multiple cells in Microsoft Excel

Adding text to multiple cells in Excel is a useful feature that can save time and effort when working with large amounts of data. Adding a text to multiple cells is a common task in excel such as adding a prefix or suffix to a list of names or values. This feature is particularly useful … Read more

How to add text to a cell in Microsoft Excel

In spreadsheet applications, it is a frequent practice to include new text in cells as a way of updating information without replacing the entire cell content. When dealing with text data in Excel, you may find it necessary to add identical text to multiple cells to enhance clarity. For instance, you might opt to add … Read more

How to add a character in a text string in Microsoft Excel

Adding a character to a text string in Microsoft Excel can be useful for formatting or manipulating data. Adding characters may be used as a delimiter for data that needs to be imported or exported from Excel to another system. By adding a delimiter such as a semicolon or a pipe symbol to a text … Read more

How to change cell colour based on value In Google Sheets

Google Sheets conditional formatting is a feature to automatically change the font properties of a specific cell, row, column, and even the background colour of the cell, based on rules you set. In other words, this tool uses the power of visualisation to make your data stand out. By colouring cells, you highlight specific values, … Read more

How to use Subtotal with Countif Condition in Excel

While we are working with dates in excel, often we have to add or subtract the dates from each other. Sometimes we want to calculate a specific date (past or future) with reference to another date in our data set. You need to do such calculations when you are managing a project with specific timelines, … Read more

How to use Autofill in Microsoft Excel 2013

Autofill is a useful feature in Microsoft Excel that enables users to quickly and easily fill cells with a series of data. This feature is particularly useful for entering recurring values or sequences, such as dates, numbers, or text strings, as it can save users a lot of time and effort. Autofill works by recognizing … Read more

How to unhide all rows in Google Sheets

In Google Sheets, you can hide rows to temporarily remove them from view. This can be useful when working with large data sets, as it allows you to focus on specific sections of the sheet without being distracted by unnecessary information. Hidden rows can also be used to temporarily remove sensitive data from view, such … Read more

How to undo Hyperlink in Microsoft Excel

Hyperlinks in Microsoft Excel are clickable objects that allow you to quickly navigate to another location within your worksheet, to another worksheet within the same workbook, or to an external file, website, or email address. They are a useful tool for creating interactive spreadsheets and making it easier for users to navigate and access relevant … Read more

How to subtract time in Google Sheets

Google Sheets is a cloud-based spreadsheet software developed by Google. It is part of the Google Drive suite of productivity tools and is available for free to anyone with a Google account. Google Sheets allows users to create and edit spreadsheets online, share them with others, and collaborate in real-time with multiple users. Subtracting time … Read more

How to show slope on Google Sheets

Slope is a graphical representation of data. Slope is used to represent  change of a quantity with respect to other quantity , mostly time. The slope explains the relationship between the independent and dependent variables.Sometimes databases where dependent and independent quantities exist become very large and it becomes difficult to understand the trend of changing … Read more

How to stop rounding up in Microsoft Excel

Excel is famous for being a powerful spreadsheet software developed by Microsoft. It is widely used in many different industries and professions for its ability to organize, manipulate, and analyze large sets of data.Some of the key features that make Excel famous include its ability to perform complex mathematical calculations, create charts and graphs to … Read more

How to Select separate columns in Excel

Microsoft Excel is a spreadsheet software developed by Microsoft. It is widely used for data analysis, financial modeling, and project management. The software allows users to create and manipulate tables of data, perform calculations and functions, create charts and graphs, and perform various other tasks related to data organization and analysis. In this tutorial we … Read more

How to select entire row in Microsoft Excel

Microsoft Excel is a spreadsheet software developed by Microsoft. It is widely used for data analysis, financial modeling, and project management. The software allows users to create and manipulate tables of data, perform calculations and functions, create charts and graphs, and perform various other tasks related to data organization and analysis. In this tutorial we … Read more

How to call a sub in Excel VBA

VBA (Visual Basic for Applications) can be a highly effective tool for automating tasks and improving productivity in many industries. Its primary strength is its ability to manipulate and automate tasks within Microsoft Office applications, such as Excel, Word, and Access. VBA can be used to create custom functions, automate repetitive tasks, and even create … Read more

How to select a sheet in Excel VBA

VBA (Visual Basic for Applications) is a highly effective tool for automating tasks and improving productivity in many industries. Its primary strength is its ability to manipulate and automate tasks within Microsoft Office applications, such as Excel, Word, and Access. VBA can be used to create custom functions, automate repetitive tasks, and even create user … Read more

How to Repeat an action in Microsoft Excel

Excel is famous for being a spreadsheet software that allows users to organize and analyze data with various tools and functions, including formulas, charts, and graphs. It is commonly used for business and financial analysis, data management, and budgeting. Excel is also known for its versatility, ease of use, and ability to handle large amounts … Read more

How to fix sub or function not defined error in Excel VBA

‘Sub or Function not defined’ is an error that is found by the compiler while running the code in Excel VBA. It occurs when anything specified by name cannot be found. Before being run, VBA is converted or compiled into machine language. If the compiler finds any errors it stops the execution process.  In this … Read more

How To Remove First 3 Characters In Excel

It is often necessary to extract relevant information from unstructured raw data while you are working with it. It is sometimes necessary to remove the first, second, or third character from your text string in order to retrieve the value. There are some functions in Excel that can be used for such a task. You … Read more

How to fix Excel Cannot Recognize Date Format issue

Excel is a powerful tool for managing data, but it can be frustrating when you import data or type in dates and Excel doesn’t recognize them as dates. In this blog post, we’ll explore the reasons why Excel may not recognize date formats, and offer solutions to help you overcome this common issue. Possible Reasons: … Read more

How to underline text in Google sheets.

Google Sheets is a web-based application that allows users to create, update and modify spreadsheets online. It’s a component of the Google Docs Editors collection. Users of the software can collaborate in real time while creating and editing files online. A user can keep track of edits by viewing the changes in the revision history. … Read more

How to remove Legend in Microsoft Excel

Microsoft Excel is a powerful and widely used spreadsheet software developed by Microsoft. It allows users to create, organize, and analyze data in a tabular format. Excel provides a range of features and tools, including functions, formulas, charts, tables, and pivot tables, to help users perform complex calculations, create visualizations, and gain insights from their … Read more

How to use Ctrl + Enter Shortcut keys in Microsoft Excel

Excel is a spreadsheet software developed by Microsoft that has become an essential tool for businesses, organizations, and individuals alike. It is widely used for data management, analysis, and reporting, making it a versatile and powerful tool for managing and organizing data.Excel allows you to create and manipulate spreadsheets, which are collections of data organized … Read more

How to select every other row in Excel

Excel allows users to perform a wide range of tasks such as organising, analysing and manipulating data, creating charts and graphs, and performing mathematical calculations. It is also a powerful tool for creating and automating complex spreadsheets and performing data analysis. Excel features a simple and intuitive interface that makes it easy for users to … Read more

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 can contain a variety of data types including numbers, text, dates, and formulas. The program also includes a wide range of powerful tools and features, … Read more

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 and is available for Windows and Mac platforms. Excel provides users with a vast array of features that allow them to create, edit, and manage … Read more

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. With Excel, users can create, edit, and format spreadsheets, perform mathematical calculations, and visualize data using charts and graphs. Excel is commonly used for a … Read more

How to compare two columns in Google Sheets

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 other users while creating and editing spreadsheets. Some of its key features and functions include: editing and sharing spreadsheets, sorting and filtering data, formula creation and execution, data visualization, and many … Read more

How to Fix “Excel found a problem with one or more formula references in this worksheet” Error in Microsoft Excel

Microsoft Excel is a powerful tool that enables users to perform a variety of tasks, including data entry, calculation, and analysis. It features an array of functions and formulas that make it easy to perform complex calculations and manipulate data. The program also has a user-friendly interface and supports a wide range of file formats, … Read more

How to resolve Break Link not working Issue in Microsoft Excel

Microsoft Excel is a spreadsheet software program that is widely used for managing and analyzing data. It is part of the Microsoft Office suite and provides a range of tools and functions for organizing, manipulating, and visualizing data.Excel allows users to create and edit spreadsheets, perform complex calculations, and generate charts and graphs to help … Read more

How to Round off a number to the nearest foot in Microsoft Excel

Microsoft Excel is a popular spreadsheet software developed by Microsoft Corporation. It is widely used for data analysis, organization, and management. It allows users to create and manipulate spreadsheets with tables, charts, graphs, and various formulas and functions. With its powerful calculation and graphing capabilities. In this tutorial we will learn how to Round Off … Read more

How to insert and use Square root symbol in Excel

The square root symbol (√) in Microsoft Excel is used to find the square root of a number. It is a mathematical operation that returns a value that, when multiplied by itself, equals the original number. The square root is used in many areas of mathematics and science, including algebra, geometry, trigonometry, and physics. In … Read more

How to Sort Data in Microsoft Excel

Microsoft Excel is a powerful spreadsheet software application that is widely used for data analysis, organization, and visualization. It provides a range of features for working with numbers, dates, and text, and allows you to perform complex calculations using formulas and functions. In this tutorial we will learn how to Sort Data in Microsoft Excel. … Read more

How to sum only visible cells in Microsoft Excel

Microsoft Excel is a powerful spreadsheet software developed by Microsoft Corporation. It allows users to organize, analyze, and manipulate data in a graphical user interface. The software provides various tools and functions for performing mathematical calculations, creating charts and graphs, and designing complex formulas. With its intuitive and user-friendly interface, Excel is widely used by … Read more

How to use the IF function for multiple ranges with multiple conditions

Microsoft Excel is a spreadsheet software program developed by Microsoft Corporation. It is used for organizing, analyzing and manipulating data. With its intuitive interface and powerful calculation tools, Excel is widely used in both personal and professional settings for tasks such as budgeting, financial analysis, and data management. Additionally, it offers a variety of charts, … Read more

How to reference cell in another sheet dynamically in Microsoft excel

Microsoft Excel is a spreadsheet software program developed by Microsoft Corporation. It is widely used for data analysis, data organization, and data presentation. Excel features a grid of cells, which can be filled with data, formulas, and functions to perform calculations and analyze data. It also supports graphs and charts, pivot tables, and macros to … Read more

How to adjust Line Spacing in Microsoft Excel

Microsoft Excel is a spreadsheet software that allows users to organize, format, and calculate data using various tools and functions. It is widely used for tasks such as budgeting, financial analysis, data visualization, and more. The program provides a user-friendly interface and supports multiple file formats, making it accessible for both personal and professional use.  … Read more

How to subtract multiple cells in Microsoft Excel

Microsoft Excel offers incredible features to ease mathematical calculations by using built-in formulas. Along with data analysis features, it also provides us with the tools to sort, highlight and format data values to make them presentable. In this tutorial, we’ll learn  how to subtract multiple cells.The SUBTRACT function in Excel does not exist. In  order … Read more

How to use fill color shortcut for Excel

Fill color in Microsoft Excel refers to the background color of cells. It can be used to highlight cells for better readability, categorize data, or simply for aesthetic purposes. It helps to visually organize and highlight important information in a sheet. You can use fill color to make certain cells stand out or to group … Read more

How to copy a Pivot table in Microsoft Excel

Pivot tables are a tool in Microsoft Excel used for data analysis and summarization. They allow users to organize and analyze large amounts of data in a dynamic and flexible manner. A pivot table takes simple flat data and aggregates it to make it more meaningful by organizing it around categories and calculating subtotals and … Read more

How to convert seconds to minutes in excel

Microsoft Excel is a powerful spreadsheet software program developed by Microsoft Corporation. Excel allows users to organize and analyze large amounts of data in a variety of formats, including tables, charts, and graphs. It also provides tools for data manipulation like converting units to other units. In today’s tutorial, we’re going to learn 2 methods … Read more

How to convert minutes to hours in excel

Converting units helps ensure accuracy and comparability in measurements and calculations, especially when working with different systems of measurement or in multi-disciplinary fields. Excel allows users to organize and analyze large amounts of data in a variety of formats, including tables, charts, and graphs. It also provides tools for data manipulation like converting units to … Read more

How to use the Autofill in Google Sheets

Google Sheets offer incredible features to ease mathematical calculations by using built-in formulas. Along with data analysis features, it also provides us with the tools to sort, highlight and format data values to make them presentable. One of those features is Autofill. In this tutorial, we’ll learn how to use autofill in google sheets. Autofill  … Read more

How to add new sheet in workbook by using shortcut

Microsoft Excel is a very useful and powerful data analyzing software developed by a famous company named Microsoft Corporation. It can perform various tasks from basic simple arithmetic operations to complex mathematical problem solving. An Excel workbook consists of several worksheets in which you can plot information and data in the form of tables, text … Read more

How to insert rows in Excel automatically

You can watch a video tutorial here. Excel provides several shortcuts and tools for actions that are performed frequently. Inserting rows is an action that you will need to do often when working with Excel. Apart from the menu options, Excel provides a variety of keyboard shortcuts that you can use to insert rows quickly.  … Read more

How to import a CSV to the online Excel

You can watch a video tutorial here. Excel is the most popular spreadsheet application and has powerful capabilities when it comes to performing calculations. To use Excel for free, you can use the online version of Excel. Files created using Excel for the web are saved to OneDrive. Excel is commonly used to open CSV … Read more

How to highlight two different columns in Excel

You can watch a video tutorial here. Excel provides several options for formatting cells. You may want to draw the reader’s attention to particular pieces of information on a sheet by highlighting a column. To do this, you can change the background color of the cell so that it stands out. When you need to … Read more

How to remove the first 3 characters in Excel

You can watch a video tutorial here. Although Excel is well suited for calculations, it has several functions to manipulate and format text. These functions are useful especially when cleaning data. There may be a case where you want to remove the first 3 characters from some text.  The following functions can be used to … Read more

How to make a schedule in Excel

You can watch a video tutorial here. The spreadsheet format of Excel lends itself to creating different types of lists and trackers. One tracker that is used both professionally and personally is a schedule. Microsoft Office provides templates that you can use or you can custom-build your schedule.  Option 1 – Create your schedule Step … Read more

How to remove gridlines in Excel for specific cells

You can watch a video tutorial here. As a spreadsheet application, the workspace in Excel displays a grid of cells in the form of rows and columns. By default, the gridlines are visible but they can be removed from the display. The setting not to display the gridlines applies to the entire sheet and cannot … Read more

How can I compare two Excel spreadsheets for differences

You can watch a video tutorial here. Comparing two Excel sheets for differences is an operation you will frequently need to do when working with datasets. This happens especially when you are consolidating data from multiple sources. You could compare the sheets by arranging them side-by-side and then manually identifying the differences but this method … Read more

How do I compare two Excel spreadsheets

You can watch a video tutorial here. Comparing two Excel sheets is an operation you will frequently need to do when working with datasets. This happens especially when you are consolidating data from multiple sources. You could compare the sheets by arranging them side-by-side but this method is highly prone to error. Excel provides ways … Read more

How to get the sum of a column in Google Sheets

You can watch a video tutorial here. Google Sheets is widely used for calculations due to the several arithmetic operators and functions that it has. You will frequently need to find the totals of columns of numbers. This can be easily done using the SUM function of Google Sheets. There are multiple ways in which … Read more

How to get stock prices in Google Sheets

You can watch a video tutorial here. Google Sheets has many uses in the financial industry, the stock market in particular. Financial analysts can use Google Sheets to track the prices of stocks in real-time or to extract historical prices. This is done by linking it to Google Finance which is an application that provides … Read more

How to get rid of extra columns in Excel

You can watch a video tutorial here. When you have a large worksheet with many columns, you may want to get rid of the columns that you do not need to make the worksheet more manageable.  Also, when you are using data imported from another application, sometimes distant columns have junk values. These can affect … Read more

How many IF statements can you nest in Excel

IF function is one of the most popular functions in Excel. With its logical function, it helps you decide what will be displayed to those who view your Excel file. It can annotate your data and can also hide those pesky #N/A in your sheet. Nesting means joining multiple functions together in one formula. A … Read more

How to calculate age in Excel in DD/MM/YYYY

Demography is the science of populations. Researchers use demographic information to describe the sample of the target population. One of the most important demographic information a researcher needs is age. If you’re a researcher, then you’ll need to know how to calculate age in Excel using birthdays. There are many ways you can calculate the … Read more

How to calculate 90 days of employment in Excel

Most of the companies use Employee Referral Program for finding talents. It is a program for the existing employees to recommend candidates within their existing networks. It is compensated through a Referral Bonus. But it’s not always when your recommended colleague gets hired you’ll be entitled to it. Recruitment teams often set rules on when … Read more

How to delete a calculated field in a pivot table in Excel

You can watch a video tutorial here. Pivot tables are one of the most useful tools in Excel for summarizing and analyzing data. Pivot tables are built on datasets and maintain a link to the dataset. Apart from using the columns in the underlying dataset, you may create a calculated column that is built on … Read more

How to convert minutes to seconds in Excel

You can watch a video tutorial here. Excel treats date and time formats differently from numbers and text. Because of the different scales i.e. 24 hours, 60 minutes, and 60 seconds, when adding minutes and seconds they cannot be treated like regular numbers. When converting minutes to seconds, simple multiplication can be used. The number … Read more

How to consolidate rows in Excel

You can watch a video tutorial here. Excel is a spreadsheet application that lends itself easily to creating lists, tables, and databases. When combining data from multiple sources, you will frequently encounter rows that have duplicate values. To analyze the data or to prepare a summary, you will need to consolidate the rows. When consolidating … Read more

How to compare two columns in different Excel sheets using Vlookup

You can watch a video tutorial here. Comparing columns in two different Excel sheets is an operation you will frequently need to do when working with datasets. This happens especially when you are consolidating data from multiple sources. Using the VLOOKUP() function in Excel provides a way in which this comparison can be automated. VLOOKUP() … Read more

How to combine columns in Excel with a space

You can watch a video tutorial here. Excel is popular as a spreadsheet application but is also frequently used as a database and to create lists. When working with tables, you may need to combine text from multiple columns into a single column. Excel has several functions that can be used to manipulate text. When … Read more

How to change the numbers on the x-axis in Excel

You can watch a video tutorial here. Charts are a great way to visualize data and Excel provides several options for creating charts and formatting them. The type of chart you create depends on the type of data that you have. When you create a chart in Excel, by default the x-axis labels are taken … Read more

How to change positive numbers to negative in Excel

You can watch a video tutorial here. Excel is widely used for calculations because of its convenient format and ease of performing arithmetic operations. You may need to convert a single number or a column of numbers from positive to negative. While you can go to each number and insert the minus sign in front … Read more

How to calculate the correlation coefficient in Excel

You can watch a video tutorial here. The correlation coefficient is a metric that measures the relationship between 2 datasets. In Excel, this can be done using the data analysis tool or by using the CORREL() function. Option 1 – Use the Data Analysis tool Note: If the Data Analysis button is on the Data … Read more

How to change negative numbers to positive in Excel

Microsoft Excel is the world’s most powerful tool for data computation and calculation. Microsoft Excel provides us with built-in functions and tools by which we can solve our Complex problems within seconds and these problems can be solved by one click. Most of the time we face a problem of negative numbers which impacts our … Read more

How to fix pivot table data source reference not valid

Pivot tables are a powerful tool in Excel that allows you to summarize and analyze large sets of data quickly and easily. With a pivot table, you can rearrange and reorganize your data to show different summaries and insights. Sometimes, while working with pivot tables, we get the “Pivot Table Source Reference Is Not Valid” … Read more

How to calculate mean median and mode in Excel

You can watch a video tutorial here. In statistical analysis, you will frequently need to summarize the data that you are studying. This includes finding out metrics such as the mean, median, and mode that gives you an idea of the nature of the data.  In Excel, you can find the mean, median, and mode … Read more

How to calculate annualized returns from monthly returns in Excel

You can watch a video tutorial here. Calculating the annualized return of an investment is a way of understanding how well the investment is doing. This can be done using the monthly returns of the investment. Excel does not have a function for this calculation but you can create the formula in Excel.  The formula … Read more

How to select multiple columns in Google Sheets

You can watch a video tutorial here. Google Sheets is a popular spreadsheet application in which the workspace is arranged in rows and columns. You may need to select multiple columns either to format them or to move them to another location.  There are different ways to select columns that are adjacent to each other … Read more

How to make reference to another spreadsheet in Google Sheet

Google sheet gained popularity due to certain reasons. Users have the unique capability of working on data remotely. They can use almost all the functionality of Microsoft Excel in Google Sheets as well.  In this tutorial we learn how to make reference to another spreadsheet in Google sheet. Sometimes during working we have to reference … Read more

How to use a cell value in Sentence in Excel

Microsoft Excel is one of the most efficient and responsive software to perform mathematical calculations on numeric datasets. In addition to this, it also provides many features to handle the text data. There are many functions available to join, split and change the case of text data in Excel. In this tutorial we’ll learn how … Read more

How to extract the numeric portion of a street address in Excel

Microsoft Excel provides many features to handle the text data along with numeric data. There are many functions available to join, split and merge data in Excel. The data could be text only, numeric only or it could be alphanumeric as well. Sometimes, while working with city addresses, we need to split up the addresses … Read more

How to remove duplicates but keep the first entry in Excel

Removing duplicates from data in Excel is important for a few reasons. Firstly, duplicate data can lead to inaccurate results and misrepresentation of the data. This is because when data is duplicated, the results of any calculations or analyses performed on the data will be skewed due to the duplicated values being counted multiple times. … Read more

How to find the length of an array in VBA in Excel

Visual Basic for Applications (VBA) is a programming language used in Excel and other Office applications to automate tasks and create more sophisticated models and tools. VBA allows users to develop custom functions and algorithms that can be used within Excel, which can be particularly useful for complex or repetitive tasks. It also allows users … Read more

How to put data from multiple columns into one column in Excel

You can watch a video tutorial here. Excel is popular as a spreadsheet application but is also frequently used as a database and to create lists. When working with tables, you may need to combine text from multiple columns into a single column. Excel has several functions that can be used to manipulate text.  To … Read more

How to merge duplicates in Excel

You can watch a video tutorial here. Excel is a spreadsheet application which lends itself easily to creating lists, tables, and databases. When combining data from multiple sources, you will frequently encounter rows that have duplicate values. To analyze the data or to prepare a summary, you will need to merge the duplicates. When merging … Read more

How to keep 0 in Excel

You can watch a video tutorial here. When you type a number on a worksheet that starts with a zero, Excel ignores the leading zeroes and displays only the digits following the zero. There may be a case where the leading zeroes are important and need to be retained. A good example is an ID … Read more