Find the Equation of a Trendline in Excel
You should use a trendline formula only with XY Scatter chart, because this chart plots on both X and Y axis as values,…
Tag: file
VBA Delete a Row if the Cell Contains
I’ve already written about removing rows in Excel, that contain specific text. In this lesson, I’ll show you have to achieve this with…
Unshare Excel File
After you worked with the members of your team, at some point you may want to restrict access to selected files that other…
Merge Cells With the Same Values
If you have a worksheet with the same data in adjacent cells, you may want to merge them for visual reasons. In this…
Change Legend in Excel Chart
You can modify the individual entries of a chart legend by changing the data inside the worksheet. Besides that, Excel offers options to…
Create Pivot Table from Multiple Worksheets
If you are using Excel 365 you can create PivotTable from data that are coming from several different worksheets. All the tools you…
Compare Two Columns in Excel
There are a few ways to compare columns in Excel. In this tutorial, I’ll present different ways you can achieve this. Row by…
Decimal Places in Excel
If you want to add a decimal place in Excel, just follow these steps. This is the simplest way to increase or decrease…
INDEX-MATCH or VLOOKUP to Return Multiple Values in Excel
When you want to look up a value in a table based on another cell, you can use the VLOOKUP function. But there…
Show Percentages in Excel Pie Chart
In this lesson, I’ll show you how you can get table values and display them as percentages inside a pie chart. We are…