A cell reference in spreadsheet programs such as Excel and Google Sheets identifies a cell’s position in the spreadsheet. A cell is one of the box-like structures that fills a worksheet, and you can recognize it by its references like A1, F26, or W345. A cell reference is the column letter and row number that …
Excel cell references – relative, absolute and mixed Read More »
Boxplots are a useful way to show the distribution of data in Microsoft Excel. However, Excel does not have a boxplot template. This does not mean that it is impossible or even difficult to create one. Read on to learn how to create a boxplot in Excel using a stacked column chart and a few …
You can quickly add today’s date in Excel by using keyboard shortcuts. When the date is added using this method, not only is it fast, but it also doesn’t change every time the spreadsheet is opened like some Excel date functions do. The information in this article applies to Excel 2019, 2016, 2013, 2010, 2007, …
Add current date/time in Excel using keyboard shortcuts Read More »
Charts in Excel give you a variety of ways to visualize your data. Charts that use an X and Y axis layout give you the ability to display a range of data, which allows you to compare two different things, but those things usually have the same unit of measurement. In this article, we will …
One of the nice features of Microsoft Excel is that there are usually multiple ways to perform many popular functions. This is especially true for date formats. Whether you’ve imported data from another spreadsheet or database, or you’re just entering due dates for your monthly bills, Excel can easily format most date styles. Read on …
Flash Fill lets you enter data into Microsoft Excel much faster. It monitors trends in the data you enter and makes suggestions to complete your input by populating entire columns with relevant values. Read on to learn how to use Flash Fill in Excel to increase data entry speed and accuracy. The instructions in this …
The ROUNDDOWN function is used to decrease a value by a specified number of decimal places or digits. It keeps the rounded number, changes the value of the data in the cell, and rounds to zero. The information in this article applies to Excel for Microsoft 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010, …
Round numbers in Excel using the ROUND DOWN function Read More »
The SUMPRODUCT function in Excel is a very versatile function that returns different results depending on how the function arguments are entered. As the name suggests, SUMPRODUCT typically multiplies the elements of one or more arrays to get their product, and then adds or sums the products. However, by customizing the function’s syntax, it can …
Sum cells that meet multiple criteria with Excel SUMPRODUCT Read More »
Before printing an Excel spreadsheet, you must set the printable area to fit standard paper sizes. This is more difficult than printing from Word, which already has printable areas. If you frequently need to print one or more specific table selections, you can define one or more print areas. Then, when you print the table, …
A t-test is a way of using a student’s t-distribution to decide whether there are statistically significant differences between data sets. The t-test in Excel is a two-sample t-test that compares the means of two samples. This article explains what statistical significance means and shows how to perform a t-test in Excel. The instructions in …
