How to Find Slope in Excel (Formula)
The slope is commonly used in statistics, where it tells us how two variables are related in a dataset. While I remember using a pen and a paper and some …
Steve Scott
How to Switch Axis in Excel (Switch X and Y Axis)
Sometimes, when you create a chart in Excel, you may want to switch the axis in the chart (i.e., interchange the X and the Y-axis) It’s really easy, and in …
How to Autofill Dates in Excel (Autofill Months/Years)
When you have to enter a sequence of dates in a column in Excel, you don’t need to do it manually. Excel has some amazing features using which you can …
How to Create Barcodes in Excel
Barcode allows you to show data in a visual format that can easily be read by machines. I am sure you have seen barcodes hundreds of times on products, including …
How to Select Rows with Specific Text in Excel
When you are working with large amounts of data in spreadsheets, you need all the tips and tricks you can get to quickly access your required data. Oftentimes you might …
How to Calculate NPV in Excel (Net Present Value)
When working with data related to investments and project assessments, you may sometime have to calculate the NPV (Net Present Values) of projects/investments. In this tutorial, I will show you …
How to Change Uppercase to Lowercase in Excel
Often when working with text data such as names or address, you will get the data in uppercase, and you may need to convert it into lowercase or propercase. With …
How to Calculate IRR with Excel
IRR is a frequently visited topic when talking about investments and returns. Trying to calculate the IRR (which stands for the Internal Rate of Return), given a series of cash …
How to Insert an Excel file into MS Word?
Word documents are for word processing while Excel files are for data processing. But what if you need to combine the two? What if you need to display a part …
How to Copy Formatting In Excel?
When working with data in Excel, you will often format data (such as color the cells or make them bold or give a border), to make these stand out. And …
How to Find Outliers in Excel?
When analyzing data, we usually assume that the data values fall somewhere near the mean or median, or at least closeby. However, there might be some values that are way …
How to Extract Number from Text in Excel (Beginning, End, or Middle)
Extracting numbers from a list of cells with mixed text is a common data cleaning task. Unfortunately, there is no direct menu or function created in Excel to help us …