Show Thousands as K in Excel
When you work with large figures in Excel, for instance, financial numbers, displaying thousands as K can make the data more readable. For example, it is easier to read 334K …
Excel Tips
Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
How to Remove Page Numbers in Excel
You may need to remove page numbers in Excel, so they don’t appear on your printed Excel reports. In this tutorial, I show you three ways to remove page numbers …
Remove Compatibility Mode in Excel
If you open a workbook created in or saved in an Excel version before 2007 (Excel 97-2003) with a newer version of Excel, it opens the file in Compatibility Mode. …
How to Remove Groupings in Excel?
In Excel, you can organize rows and columns in groups to easily hide and show different parts of the worksheet and create summary reports that show only the relevant details. …
How to Extract Part of Text in a Cell in Excel
When you work with text data in Excel, knowing the various techniques for extracting substrings from text strings in a cell is helpful. You may need to extract parts or …
Merge Cells Without Losing Data in Excel
When working in Excel, you may need to merge cells to improve data presentation, such as centering the table title at the top of the table. To merge or combine …
#DIV/0! Error in Excel – How to Fix It?
In Excel, the #DIV/0! (division-by-zero) error occurs when a formula attempts to divide a number by zero or by an empty cell. For instance, the dataset below shows a division-by-zero …
How to Transfer Excel Data to Access
Access is a database management system (DBMS) suitable for capturing, storing, querying, and sharing data, while Excel is a spreadsheet application best for calculations, analysis, and visualization of data. You …
How to Reference a Cell on Another Sheet in Excel
When you reference a cell or range of cells in another Excel sheet, you create a formula that points to a cell or range of cells in another sheet. This …
How to Set Print Area in Excel (Easy Steps)
If you have a worksheet containing a large dataset and only want to print a specific portion(s) of the data, you can set the print area(s). The print area is …
Unprotect Excel Sheet Without Password
It’s a common scenario to protect an Excel sheet with a password, only to find yourself in the frustrating situation of forgetting the password. Depending on your protection options, forgetting …
Calculate Correlation Coefficient in Excel
Calculating correlation coefficients between two data series is a common task in fields such as statistics, finance, and social sciences. In this tutorial, I will show you how to calculate …