Category: examples

In Power Query, you can merge multiple columns into a single one. This is what we are going to do in this lesson….

Excel contains over one million rows – 1,048,576 to be exact. If your file is larger than that and you will try to…

A millisecond is a one-thousandth of a second. Normally when you work with Excel, you need Dates and Time with hours and minutes,…

You should use a trendline formula only with XY Scatter chart, because this chart plots on both X and Y axis as values,…

After you worked with the members of your team, at some point you may want to restrict access to selected files that other…

In order to select a column in Excel, you click a column letter. You can also select the entire column by using Ctrl…

You can modify the individual entries of a chart legend by changing the data inside the worksheet. Besides that, Excel offers options to…

If you are using Excel 2013 or a newer version you can create PivotTable from data that are coming from several different worksheets….

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 workbooks side by side The simplest way to compare two Excel worksheets is just by looking at them. If you use standard…