Formula to Copy Cell Value to Another Cell in Excel
To copy one cell to another is very easy, you just have to make a reference to the cell you want to copy….
Tag: medium
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…
Switch X and Y Axis in Excel
Sometimes when you want to create a line chart, it doesn’t look the way you want. You want one set of values to…
Remove (blank) in Pivot Table
Let’s take a look at the following table. There are four columns, first and last name, address, and zip code. In the two…
Change Date Format to dd/mm/yyyy in Excel
Depending on the country you are in, you can use a few different date formats. In this lesson, I’ll show you how to…
11+ Ways to Reduce Excel File Size
For most people who deal with small files, the reduction in file size is not that important. But for those who deal with…
Year Over Year Growth in Excel
When you try to calculate the growth of your company, comparing data to the previous month is not always the best idea because…
Delete Rows With Specific Text
For this lesson, we are going to use the following example. The data don’t have to be highlighted. I did it so we…
Chart Ignore Blank Cells in Excel
When you create a chart, sometimes you will find blank cells in rows. If you insert a line chart there your data won’t…
Count Rows in Excel VBA
There are a few methods to count rows and each of them uses VBA. In this example, I’ll show two of them. Range.End…