31 guides filed under this subject.
Sorting data in Excel is a fundamental skill that can help you better analyse and understand your data. Whether you are working with a small or large dataset, sorting can help you quickly identify patterns, trends, and outliers. Excel provides several options for sorting data, depending on your specific needs. You can sort data by one or more columns, in ascending or descending order, and even customise the sort order…
Read guideWhat is a cell in Excel? Once you dive into learning Excel it doesn’t take long before you discover a whole new world with its own language! And cells are a frequent term used, so what is it? Simply put, cells are the individual unit of an Excel grid spreadsheet. Each cell can contain a piece of data, such as a number, text, or formula, and can be formatted in…
Read guideA visual Excel-specific guide to locking cells with $A$1, mixed references and the F4 shortcut when copying formulas.
Read guideWhat’s the difference between the HLOOKUP and VLOOKUP formulas in Excel? While both functions are used to look up and retrieve data from a table, they operate in slightly different ways. HLOOKUP stands for “Horizontal Lookup,” while VLOOKUP stands for “Vertical Lookup.” The main difference between the two is the direction in which they search for data. HLOOKUP searches horizontally (from left to right) across the first row in the…
Read guideHow do you use the HLOOKUP function in Excel properly and effectively? As someone who frequently uses Excel, I understand how important it is to master various functions and features to enhance productivity and effectiveness. One such function that can be incredibly useful when working with large data sets is the HLOOKUP function. In this article, I’ll share a few examples to demonstrate how this function can improve your data…
Read guideAre you struggling with your VLOOKUP formula staying as a formula instead of returning the desired value? If so, you are not alone, and the solution is relatively simple. One common reason VLOOKUP stays as a formula is due to the formatting of the cells. If the cells are formatted as text , Excel will treat the VLOOKUP formula as text and not perform the lookup. To fix this issue,…
Read guideDo you have multiple sheets in Excel and need to find and extract data quickly? VLOOKUP is a powerful function in Excel that allows you to search for and retrieve data from a specific column in a table. However, when you have multiple sheets, using VLOOKUP can be a bit tricky. In this article, we will show you how to use VLOOKUP across multiple sheets in Excel with examples. When…
Read guideIf you are an Excel user, you are likely familiar with the SUMIF function. However, did you know that you can use SUMIF to add up values based on whether a cell starts with a specific letter? This can be a useful tool for quickly calculating totals for a specific category or group. The SUMIF function in Excel allows you to add values in a range of cells that meet…
Read guideIf you’re working with a large dataset in Excel, you might need to sum only the positive numbers. This can be a tricky task, especially if you have a lot of data to work with. Fortunately, Excel has a built-in function that makes it easy to sum only positive numbers. The SUMIF function in Excel allows you to sum only the cells that meet certain criteria. In this case, you…
Read guideWhat do you do when you use the SUM function and it doesn’t add up the values correctly? If you are a regular user of Microsoft Excel, you may have encountered an issue where the sum function does not add up correctly. This can be a frustrating issue, especially when you are dealing with large amounts of data and need to ensure accuracy. The sum function is one of the…
Read guideIf you’re working with Excel, you’ll likely find yourself needing to change formulas from time to time. Whether you’re fixing an error or updating a calculation, it’s important to know how to make changes without disrupting your spreadsheet. Changing an Excel formula is a simple process that can be done in just a few steps. First, you’ll need to select the cell containing the formula you want to change. From…
Read guideOne of the most useful features of Excel is its ability to calculate durations in years and months. This can be particularly helpful when you need to work with data that involves time, such as project timelines or financial data. Calculating durations in years and months is a relatively simple process in Excel. By using the DATEDIF function, you can easily calculate the number of years, months, and days between…
Read guideIf you work with data, you’ll likely need to use Excel’s formulas. Formulas are equations that perform calculations on values in your worksheet. They can help you automatically calculate values, manipulate data, and make your work more efficient. In this article, we’ll explore how to build formulas in Excel. Excel has hundreds of built-in functions that you can use to create formulas. These functions are organised into categories such as…
Read guideMicrosoft Excel is a powerful tool that is widely used for organising, analysing, and presenting data. One of the most useful features of Excel is the ability to create formulas that automate calculations based on the data in your spreadsheet. One of the most commonly used formulas in Excel is the IF formula, which allows you to perform different calculations based on whether a certain condition is met or not.…
Read guideMicrosoft Excel is a powerful tool that is used by millions of people worldwide. It is a spreadsheet program that allows users to organise, manipulate, and analyse data. One of the most important features of Excel is its ability to perform calculations using formulas. Excel formulas are a set of instructions that tell Excel what to do with the data in a particular cell or range of cells. There are…
Read guideIf you work with large amounts of data in Excel, you know how important it is to be able to quickly and easily find specific information. Luckily, Excel has a built-in Find feature that makes it easy to do just that. Whether you need to find a specific word or number or you need to locate a certain cell or range of cells, the Find feature can help. To use…
Read guideWhat happens when your favourite software, Microsoft Excel, crashes? Sometimes Excel may quit unexpectedly, which can be frustrating for users who rely on the program for their work. This issue can occur for various reasons, including software conflicts, corrupted files, or outdated versions of Excel. If Excel quits unexpectedly, it can result in loss of unsaved data, disruption of work, and wasted time. This issue can occur at any time,…
Read guideMicrosoft Excel is a powerful tool that can be used for a variety of tasks, from simple calculations to complex data analysis. However, many people struggle to use Excel effectively, often because they lack the necessary skills and knowledge. Fortunately, there are several ways to improve your Excel skills and become more proficient in using this valuable tool. One of the most important things you can do to improve your…
Read guideWhen it comes to using Excel, there are many different functions and formulas that can be used to make calculations and organise data. One of the most commonly used symbols in Excel is the dollar sign ( $ ), which is used to indicate absolute references . Absolute references are a way of locking a cell reference in place so that it doesn’t change when you copy or fill a…
Read guideIf you’ve ever worked with Microsoft Excel, you may have noticed the “ ” character appearing in a cell. This can be frustrating, especially if you’re not sure what it means or how to fix it. Fortunately, understanding why this happens can help you avoid this issue in the future and work more efficiently with your data. The “ ” character typically appears in a cell when the data in…
Read guideExcel is a powerful spreadsheet software that has been around for decades. It has become an essential tool for businesses, students, and individuals alike. One of the reasons for its popularity is the vast range of features it offers. However, some users may wonder why Excel has certain features that they may not use or understand. One reason for the various features in Excel is to make it a versatile…
Read guideIn Excel and Google Sheets, $A$1 is an absolute cell reference: both column A and row 1 remain fixed when a formula is copied.
Read guideUnderstand what $A$1, $A1 and A$1 mean and how absolute and mixed references behave when formulas are copied in Excel and Google Sheets.
Read guideHow do you make an email address in an Excel spreadsheet clickable? To make an email address clickable in a spreadsheet check the format of the cell is not set to text, if not when entering an email address Excel should automatically detect that it is an email address and add the mailto: hyperlink automatically. If after checking the cell is not set to Text and even after entering a…
Read guideHow do you get the value from a column that is to the left of a VLOOKUP range? The VLOOKUP function is a powerful function that enables you to capture the value from a range, provided the value is to the right of the lookup range. For example, suppose you have the following data in your spreadsheet that contains the employee ID in column A, the name of the employee…
Read guideWhat is the formula to add in Excel? There are two popular ways to add numbers together in Excel: using the plus sign + or using the SUM formula. Use the + sign where values being added are manually entered, and use SUM when referencing specific cell values. Here are some examples demonstrating the use of each type: When To Use + (Plus) Sign In a spreadsheet the plus sign…
Read guideIf a cell contains words it can be easy to split these into individual cells using the Text to columns feature in Excel. Simply select the cells you want to split into multiple columns, navigate to the Data menu then click on the Text to Columns button. From this Text Wizard window select Delimited width (click Next ), then set the delimiter type to Space (click Next ) then click…
Read guideWhen you start entering text into a cell and the first character of that cell is a plus symbol ( + ) you will get an error NAME? and you would have noticed the cell changed to =+A . So how can you just display a cell with a plus sign? A --- --- 1 \ NAME? =+A {.spreadsheet} Result after starting cell with + To display a cell that…
Read guideWhen using large numbers in Excel or any other spreadsheet application, such as Google Sheets, some cells may display a number in scientific notation like 9.991E+35 . How do you get rid of that E+n bit, where n is some number, in the cell? A --- --- 1 9.997E+11 =9999^3 {.spreadsheet} Large number in cell The easiest way to change a number being displayed as E+n (where n is a…
Read guideThe VLOOKUP formula is a popular function for getting the value from a tabular data set and has 3 required parameters and an optional fourth, and looks something like this: The first parameter reference value is the value you are searching for in the first column of your data set (the second parameter). The third parameter returning column value is the column from your data set that you wish to…
Read guideIf you are testing the return value of a function in the immediate window in VBA and get the following error: Wrong number of arguments or invalid property assignment (Error 450) What you are doing is something like this: Then in the immediate window typing: The code appears to work fine, but the error is a mystery. The reason for the error is that the immediate window call expects a…
Read guide