Open Large CSV in Excel
Excel contains over one million rows – 1,048,576 to be exact. If your file is larger than that and you will try to…
Category: examples
Milliseconds in Excel
A millisecond is a one-thousandth of a second. Normally when you work with Excel, you need Dates and Time with hours and minutes,…
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,…
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…
Select Multiple Columns in Excel
In order to select a column in Excel, you click a column letter. You can also select the entire column by using Ctrl…
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…
Compare Excel Files
The simplest way to compare two Excel worksheets is just by looking at them. If you use a standard widescreen monitor there is…
Convert Text or Number to Date in Excel
In this lesson, I’ll show you how to convert text to dates in Excel in a formula and non-formula way. When you import…