Excel is a powerful tool that allows you to manipulate data in various ways. One common task you may need to perform is removing some numbers from a cell. For example, you may have a cell that contains a combination of text and numbers, and you want to remove the numbers to extract only the … Read more
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
Excel is a powerful tool that can help you manage and analyze data efficiently. One of the basic tasks in Excel is to remove a letter or character from a cell. This can be useful when you have a large dataset and need to remove a specific letter or character from a column. In this … Read more
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
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
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
Fill colour is a popular formatting feature in Excel that allows you to highlight cells with a specific colour. However, there may be times when you want to remove fill colour from cells. This could be because you want to change the colour or remove formatting altogether etc. In this tutorial, we will learn how … Read more
Cumulative sum in Excel is a mathematical operation that calculates the total sum of a series of values over time such as a sequence of months or years. It represents the sum of all the previous numbers in the series, including the current value. You can use the cumulative sum in Excel to analyse data … Read more
While working in MS Excel sometimes inserting single or multiple rows is necessary. A few of the reasons are listed below: Adding new data: When working with Excel, it is common to have new data that needs to be added to an existing worksheet. By inserting rows, users can make space for new data without … Read more
The top row freeze feature in Google Sheets allows you to keep the top row visible as you scroll down through your spreadsheet. This can be particularly helpful if you have a large dataset and need to keep the header row visible at all times, as it allows you to quickly reference the column headers … Read more
When you have a large Excel spreadsheet with many rows of data that you no longer need, you may want to delete them to reduce the file size and make it easier to work with. If you have thousands of rows to delete, you can use Excel’s built-in functionality to quickly remove them. This involves … Read more
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
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
Deleting excess columns in Excel means removing columns that are not needed or are unused in a spreadsheet. Excel spreadsheets usually have a large number of columns, and it’s common for some of them to be empty or contain data that is no longer needed. Deleting these excess columns helps to clean up the spreadsheet … Read more
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
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
In Excel, notes are a type of comment that can be added to a cell. They are used to provide additional information about the content of a cell, such as an explanation or a reminder. Notes are not visible in the main body of the worksheet but are indicated by a small red triangle in … Read more
In this tutorial, we’ll learn how to zoom in google sheets. The following dataset above shows the items that are required of the people. Today we are going to use this dataset to learn how to zoom in google sheets. Method 1 – Zooming in google sheets through the Menu bar: In this method, we … Read more
In Microsoft Excel, making one cell into two generally refers to the process of splitting the contents of a cell into two separate cells. This can be useful if you have data in a cell that needs to be separated into two distinct pieces of information. In this tutorial, we will learn how to make … Read more
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
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
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
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
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
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
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
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
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
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
In Excel, “Copy Down” refers to a technique where you can quickly copy the contents of a cell or a group of cells downwards into adjacent cells. This is commonly used when you want to copy formulas or data from one cell or group of cells to multiple cells below. Copy Down can save significant … Read more
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
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
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
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
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
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
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
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
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
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
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
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
In Microsoft Excel, wrap text is a feature that allows text within a cell to be displayed on multiple lines, rather than being restricted to a single line that is cut off at the cell boundary. This feature can be particularly useful when dealing with long cell contents. If you have a long text string … Read more
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
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
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
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
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
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
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
Copying formulas in Google Sheets is a common practice for users who need to apply the same calculation to multiple cells or ranges of cells in a spreadsheet. Rather than manually entering the same formula in each cell, users can copy the formula to other cells to save time and improve accuracy. In this tutorial … Read more
Excel is a powerful tool for organizing and analyzing data, and one common task you might need to perform is subtracting a certain number of days from a date. You might need to do this when you are planning an event. For example, if your event is on June 30th and you need to order … Read more
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
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
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
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
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
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
‘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
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
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
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
Excel is a widely used spreadsheet software that allows users to manage, organize, and analyze data in a tabular format. Developed by Microsoft, 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 data. In this … Read more
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
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
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
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
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
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
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
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 this task by changing the colour of each cell one by one. Colouring the cells based on their values in Excel helps in understanding the … Read more
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
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
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
Microsoft Excel is designed to calculate and manipulate numbers. However, you may often find yourself in situations when, in addition to numbers, large amounts of text need to be stored in spreadsheets. In such cases, longer text does not fit completely in a cell, you can of course proceed with the most obvious way and … Read more
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
In Microsoft Excel, vertical text refers to text that is written from top to bottom instead of from left to right. It can be used to display text in a way that saves space or makes it easier to read, especially when dealing with long or narrow columns of data. By rotating the text 90 … Read more
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
In this tutorial we will learn how to truncate text in Microsoft Excel. Truncating text in Microsoft Excel refers to the process of limiting the number of characters displayed from a longer text string. This is useful when you want to display only a portion of the text, or when you have limited space to … Read more
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
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
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
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
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
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
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
Excel features a wide range of tools and functions for working with data, including the ability to sort, filter, and calculate data using formulas and functions. It allows users to create charts and graphs to visualize data. It also provides the facility to export the excel file to various formats, for example a CSV (comma … Read more
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
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
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
Excel is a powerful tool for data analysis and manipulation. Excel is a powerful software program from Microsoft used to store, organize, and analyze data. It is composed of rows and columns, referred to as cells, where data can be entered or formulas can be used to calculate values. Excel is a great tool for … Read more
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
A pivot table is a tool in Excel that allows you to summarize and organize large amounts of data. It allows you to rotate rows and columns to see different summaries of the data, and to create a summary table that can be easily sorted, filtered, and analyzed. Pivot tables can be used to quickly … Read more
You can watch a video tutorial here. Excel is a popular spreadsheet application in which the workspace is arranged as rows and columns in the form of a grid. Each intersection of a row and column is called a cell. When working with Excel, you may need to move some rows, without disturbing the data. … Read more
You can watch a video tutorial here. Excel is a popular spreadsheet application in which the workspace is arranged as rows and columns in the form of a grid. Each intersection of a row and column is called a cell. When working with Excel, you may need to move all the data down one row, … Read more
You can watch a video tutorial here. When working in Excel, you may need to move an entire row to change the order of the data or to make the sheet easier for the readers to understand. Here we describe 2 ways of doing this. Option 1 – Drag and drop the row Step 1 … Read more
You can watch a video tutorial here. The workspace in Google Sheets is organized as columns and rows. Each intersection of the row and column is called a cell. When working with a spreadsheet, you may need to move a cell to a different location in the sheet. This could be to copy the cell … Read more
You can watch a video tutorial here. Graphs are great ways to visualize data and Excel has several tools for creating and formatting charts. The type of chart that you create depends on the dataset that you have. Using the charting tools in Excel, you can explore various types of charts and decide on the … Read more
You can watch a video tutorial here. Excel is popular as a spreadsheet application but also has several functions that can be used to manipulate text. When working with data you may need to merge the data in two cells into one. When merging data in two cells, it is usually a good idea to … Read more
You can watch a video tutorial here. Bullet points are an effective tool to communicate information concisely. When you have a list of instructions, it is better to make them into a series of bullet points so that each step is clear and the scope for misunderstanding on the part of the user is reduced. … Read more
You can watch a video tutorial here. Excel is widely used for calculations because of its convenient spreadsheet format and ease of performing arithmetic operations. You may need to convert a column of numbers from positive to negative. While you can go to each number and insert the minus sign in front of it, this … Read more
You can watch a video tutorial here. Excel provides many options for formatting worksheets and cells. One of the options is to make a border for cells or a table. Borders help define the outline of a table and are a good option when formatting your sheet to make it look neater. Option 1 – … Read more
You can watch a video tutorial here. Excel is frequently used for calculations and has many functions to help with basic mathematical operations. The way a number is displayed in a cell is different from the way that it is stored. Sometimes a number is stored with decimal places, but when it is displayed, it … Read more
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
You can watch a video tutorial here. In Google Sheets, the checkmark or tick mark symbol is not readily available on the toolbar of the menu. You may be responding to a questionnaire where you are required to tick one of the options. While you can copy and paste the image of a checkmark, this … Read more
You can watch a video tutorial here. Cells in Google sheets are, by default, a uniform size. When formatting a spreadsheet, you may need to increase the height of a row so that the text is properly displayed. Option 1 – Use the row header Step 1 – Increase the row height Option 2 – … Read more
You can watch a video tutorial here. Cells in Excel are, by default, a uniform size. When formatting a spreadsheet, you may need to increase the size of a cell or cells so that the text is properly displayed. Option 1 – Use the column and row headers Step 1 – Select the column and … Read more
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
You can watch a video tutorial here. In Excel, you can create a link to an external resource such as a website, a document, or an email. This is useful when you need to provide a reference to the text on your sheet. For example, when providing information about a company, you can create a … Read more
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
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 the cells. To do this, you can change the background color of the cell so that it stands out. Option 1 – Use … Read more
You can watch a video tutorial here. Excel has many features and tools to help with formatting and manipulating text and numbers in cells. When cleaning up data or performing data analysis, you may need to separate the numeric characters from the cells. This happens many times when analyzing or cleaning textual data such as … Read more
You can watch a video tutorial here. Excel has several operators and functions that can be used to perform basic mathematical operations. One such operation is finding the inverse log of a number. The inverse of a logarithmic function is an exponential function. To reverse log base 10, we need to raise 10 to the … Read more
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
You can watch a video tutorial here. Although Excel is well suited for calculation, 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 truncate the text in a cell as all the text is not required. The following … Read more
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
You can watch a video tutorial here. The format of a spreadsheet in Excel is in the form of columns and rows. It is easy to select a single column by clicking on the column header. When you need to highlight multiple adjacent columns, you can select the columns and then highlight them by changing … Read more
You can watch a video tutorial here. When you have a large amount of data that runs into many rows and columns, you can group either the columns or rows so that the data becomes more manageable. This is also useful when you have subtotals within the sheet and would like to collapse the cells … Read more
You can watch a video tutorial here. Excel has a setting that checks for errors when data is entered into a worksheet. A small green triangle appears in the upper left corner of the cell and when the cell is selected a warning icon is displayed. While this is a useful feature, there may be … Read more
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
You can watch a video tutorial here. Excel has several functions and tools that can be used to manipulate text and numbers. Some of these functions can be used to modify the contents of a cell. When you are cleaning data, you may need to remove the last digit from a number as it may … Read more
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
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
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
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
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
You can watch a video tutorial here. Excel is frequently used for calculations and has many ways in which to format numbers. Sometimes numbers will be formatted to be displayed with dollar signs. This may not always be relevant and so the dollar signs have to be removed. Removing the dollar signs only changes the … Read more
You can watch a video tutorial here. Excel is widely used for mathematical operations due to the variety of functions and tools it provides. When working with Excel, you may need to find the slope of a set of coordinates. There are 3 ways of doing this: Option 1 – Use the equation Step 1 … Read more
You can watch a video tutorial here. Excel is a great tool for calculations and provides many functions and operators to support all basic mathematical operations. When performing calculations, you may need to find the square root of a number. You can do this using the following functions: Option 1 – Use the SQRT() function … Read more
You can watch a video tutorial here. In Excel, names can be given to a cell or a range of cells. This makes it very easy to use the range in formulas where you can use the name instead of a cell reference. When you have created names for multiple ranges in a worksheet, you … Read more
You can watch a video tutorial here. Cells in Google Sheets are, by default, a uniform size. When formatting a spreadsheet, you may need to change the size of a cell or cells so that the text is properly displayed. Option 1 – Use the column and row headers Step 1 – Increase the width … Read more
You can watch a video tutorial here. When you have a large amount of data that runs into many rows and columns, you can group either the columns or rows so that the data becomes more manageable. The groups can be made by collapsing rows so that you can then drill down to the more … Read more
You can watch a video tutorial here. Google Sheets is a great tool for calculations and provides many functions and operators for basic mathematical operations. When you need to find the exponent of a number in Google Sheets, there are 2 ways in which this can be done: Option 1 – Use the caret (^) … Read more
Have you ever had a list with a hundred items and you’ll need to add a specific text to each and every one of them? It sounds troubling if you do it one by one. But worry not, this tutorial got you covered. We will learn how to add a specific text to the range … Read more
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
You’re in business to earn a profit. You have to know how to calculate margin because it tells you how much profit you’re earning. Margin is a percentage that is used to measure the profitability of your business. It is derived after the costs have been deducted from sales. Sales is also a good check … Read more
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
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
In investing, it is important to know the beta of a stock. It helps the investor to measure the volatility of the stock’s risk. It indicates how much a stock’s price fluctuates up and down in relation to other equities in the stock market. Luckily, Excel can let you calculate this in two easy ways: … Read more
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
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
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
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. The operation of combining text is known as concatenation. Excel has 3 … Read more
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
You can watch a video tutorial here. Excel is popular as a spreadsheet application but also has several functions that can be used to manipulate text. When working with data you may need to combine two cells into one. When combining two cells, it is usually a good idea to include a delimiter such as … Read more
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
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 3 columns into a single column. Excel has several functions that can be used to manipulate text. To … Read more
You can watch a video tutorial here. Excel is a popular spreadsheet application that has many options for formatting cells. When working with Excel, you may want to modify the sheet by deleting or clearing a cell without affecting the formatting. Option 1 – Use the Delete button Step 1 – Select the cell Step … Read more
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
You can watch a video tutorial here. Cells in Excel are, by default, a uniform size. When formatting a spreadsheet, you may need to change the size of a cell or cells so that the text is properly displayed. Option 1 – Use the column and row headers Step 1 – Select the column and … Read more
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
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
In Google Sheets, the IF statement allows you to specify a condition to test and one or more actions to take based on the result of that test. If the condition is true, the IF statement will execute one set of actions; if the condition is false, it will execute another set of actions. Here … Read more
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
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
Google sheets 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 while sitting in remote areas. It has made our life easier and more convenient. Google sheet allows us to format the cells in different styles by different … Read more
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
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
You can watch a video tutorial here. Excel provides several ways in which cells can be formatted. Preset formats are available for commonly used formats such as numbers, date, time, and currency. Suppose you have a list of heights and weights and you would like the units to be displayed with the numbers for better … Read more
You can watch a video tutorial here. When working with a Google worksheet, you may need to enlarge the sheet to get a more detailed view of the sheet. There are 2 ways of doing this using the Zoom options in Google Sheets. Option 1 – Use the Zoom button Step 1 – Expand the … Read more
You can watch a video tutorial here. Excel provides a simple way to sort a table based on single or multiple columns. The order can be either ascending or descending based on alphabets or numbers. Having sorted the data you may want to reverse the action or you would like to mix up the data … Read more
You can watch a video tutorial here. Timestamps are useful pieces of information to have in a document as they tell you how recent a document is or when it was last updated. In Excel, you can create either a static timestamp or a dynamic one. A static timestamp will not change after it is … Read more
You can watch a video tutorial here. Excel is frequently used as a database and can store data in any format that you choose. There may be a case where you have a list of names in which the first name is followed by the last name. You may need to reverse this order to … Read more
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 can also add a checkbox in a Google Sheet that can be used to tick off an item. The value of the cell containing the checkbox evaluates to 1 … Read more
You can watch a video tutorial here. When formatting tables in Excel, you may need to merge cells to properly label the data and to make it look neater. When cells are merged in Excel, only the data in the top left cell is retained and the data in the other cells are lost. Having … Read more
You can watch a video tutorial here. Arranging values in order or sorting is an operation that you will frequently need to do when working with Excel. Excel provides multiple ways in which a column can be sorted in alphabetical order. Option 1 – Use the button on the ribbon Step 1 – Choose the … Read more
You can watch a video tutorial here. Excel is a popular spreadsheet application in which the workspace is arranged as rows and columns in the form of a grid. Each intersection of a row and column is called a cell. When working with Excel, you may need to shift cells, without disturbing the data. Option … Read more
You can watch a video tutorial here. Google Sheets is a popular spreadsheet application in which the workspace is arranged as rows and columns in the form of a grid. Each intersection of a row and column is called a cell. When working with Google Sheets, you may need to shift some cells down, without … Read more
You can watch a video tutorial here. To properly format an Excel sheet for printing or for saving in another format such as PDF, it is important to set the margins. Margins are the blank spaces that surround the data on a page. Margins can be adjusted to increase or decrease the blank spaces, depending … Read more
You can watch a video tutorial here. Excel is a popular spreadsheet application in which the workspace is arranged in rows and columns. Each intersection of a row and column is a cell. You may need to select two cells to format them or to move them to another location. The cells could be contiguous … Read more
You can watch a video tutorial here. In Excel, a range is a contiguous set of cells. When working with Excel you may need to select non-adjacent ranges to format them or copy them or move them to a new location. There are 3 ways in which this can be done: Option 1 – Use … Read more
You can watch a video tutorial here. In Excel, a range is a contiguous set of cells. When working with Excel you may need to select multiple ranges to format them or copy them or move them to a new location. There are 3 ways in which this can be done: Option 1 – Use … Read more
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
You can watch a video tutorial here. The format of a spreadsheet in Excel is in the form of columns and rows. You may need to select an entire row to format it or copy it to another location. You can either select the entire row on the sheet or the entire row that contains … Read more
You can watch a video tutorial here. Google Sheets is a popular spreadsheet application in which the workspace is arranged in rows and columns. Each intersection of a row and column is a cell. You may need to select cells to format them or to move them to another location. Option 1 – Use the … Read more
You can watch a video tutorial here. Excel is a popular spreadsheet application in which the workspace is arranged in rows and columns. You may need to select all columns either to format them or to move them to another location. You can select all columns on the sheet or select all columns that have … Read more
You can watch a video tutorial here. When formatting a table in Excel, you may need to rotate the contents of a cell to accommodate more columns in the display or to make the table look more appealing. Option 1 – Use the button on the ribbon Step 1 – Select the cells Step 2 … Read more
You can watch a video tutorial here. Excel is frequently used as a database and can store data in any format that you choose. There may be a case where you have a list of names in which the first name is followed by the last name. You may need to reverse this order to … Read more
You can watch a video tutorial here. When a chart is created in Excel, it is created as an object. This means that it is not tied to a particular cell and is an independent entity that can be moved or resized according to the requirement. You may need to resize a chart to make … Read more
You can watch a video tutorial here. Excel usually applies the ‘General’ format to values entered in cells, both for letters and for numbers. If a number appears to be a date, Excel formats it as a date. This is usually quite useful but you may want to remove the date format. Internally, the date … Read more
You can watch a video tutorial here. Excel is frequently used for calculations and has many ways in which to format numbers. When working with numbers and performing calculations, many times you will have cells that contain only zeroes. There may be cases where you either want to remove the zeroes completely or change the … Read more
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
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
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
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
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
You can watch a video tutorial here. Excel provides many options for formatting worksheets. One of the options is to create or remove a border for cells or a table. When copying and pasting data within the sheet, by default the formatting also gets pasted. If the source cell has a border, the destination cell … Read more
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. Very often, when you are looking at a set of data, you would be interested in knowing the rank or position of each row with respect to a particular … Read more
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
You can watch a video tutorial here. To validate the data that is entered in Google Sheets, it is possible to define the list of values that are allowed by creating a drop-down list. This is especially useful when creating data entry forms and you need to restrict the values that are entered. By restricting … Read more
You can watch a video tutorial here. In Excel, you will frequently get to work with dates. Most transactional data such as lists of orders and lists of sales will include the date of the transaction. While it is fine to keep the date in the date format for most reports, you may need to … Read more
You can watch a video tutorial here. When working with Excel, you can use the features of Excel to generate data. One such feature is the ability to populate dates based on a start date. The fill handle increments by a single day but you can use the menu option to generate sequences based on … Read more
You can watch a video tutorial here. Copy and paste is an operation that you will perform frequently when working with Excel. You may want to copy some data from one sheet to another. There are 3 ways in which this can be done: Option 1 – Use the keyboard shortcuts Step 1 – Copy … Read more
You can watch a video tutorial here. Google Sheets has many tools and shortcuts that can be used to automate repetitive tasks or tasks that span a large number of rows and columns. One such task is numbering rows. Not only is this a time-consuming task if done by typing the number in each row, … Read more
You can watch a video tutorial here. Google Sheets has many tools and shortcuts that can be used to automate repetitive tasks or tasks that span a large number of rows and columns. One such task is numbering cells in a column or row. Not only is this a time-consuming task if done by typing … Read more
You can watch a video tutorial here. Excel is a popular spreadsheet application in which the workspace is arranged as rows and columns in the form of a grid. Each intersection of a row and column is called a cell. When working with Excel, you may need to move some rows down, without disturbing the … Read more
You can watch a video tutorial here. Graphs are great ways to visualize data and Excel has several tools for creating and formatting charts. The type of chart that you create depends on the dataset that you have. Using the charting tools in Excel, you can explore various types of charts and decide on the … Read more
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 series takes the name … Read more
Copy and paste is a very basic function of Excel used to duplicate content or move content from one location to another. This can be useful for a variety of reasons, such as copying a formula to multiple cells to perform the same calculation in each cell, or copying a set of data from another … Read more
You can watch a video tutorial here. Excel is a versatile application and can be used for many types of documents, not just for its spreadsheet capabilities. To create a family tree in Excel, you can explore using a template from Microsoft Office or you can create your own using the SmartArt suite of tools. … Read more
You can watch a video tutorial here. Merging rows in Excel is most often used when formatting tables, to make the table more readable. When a value is repeated multiple times across two rows, within the same column, it is better to combine the rows so that the value is displayed only once. If the … Read more
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
You can watch a video tutorial here. In Excel, it is possible to group rows to arrange the data into categories. Once rows are grouped, sub-totals can be added to calculate the sum of a particular column within each category. When that has been done, you may want to sum up all the sub-totals to … Read more
You can watch a video tutorial here. Graphs are great ways to visualize data and Excel has several tools for creating and formatting charts. The type of chart that you create depends on the dataset that you have. Using the charting tools in Excel, you can explore various types of charts and decide on the … Read more
You can watch a video tutorial here. Excel is a spreadsheet application in which the sheet is arranged in the form of rows and columns. Since the page breaks are not always evident, it is important to check what the printout will look like when preparing the sheet for printing. You may find that you … Read more
You can watch a video tutorial here. Excel provides many options for formatting worksheets. One of the options is to create or remove borders for cells or a table. Borders help define the outline of a table and are a good option when formatting your sheet to make it look neater. Option 1 – Use … Read more
You can watch a video tutorial here. Excel is a popular spreadsheet application that has many options for formatting cells. When working with Excel, you may want to modify the sheet by deleting or clearing the contents from the cells without affecting the formatting. Option 1 – Use the Delete button Step 1 – Select … Read more
You can watch a video tutorial here. Excel is a popular spreadsheet application in which the workspace is arranged in rows and columns. You may need to select 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 and those … Read more
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