VBA find last row

Here, I’m going to show you a few ways to get the last row using the VBA code. Find the last row in…

Posted On

Pie Chart percentages

In this lesson, I’ll show you how you can get table values and display them as percentages inside a pie chart. We are…

Posted On

Concatenate vs & in Excel

When working with Excel, you probably noticed that there are two methods of joining strings. One of them is by using the ampersand…

Posted On

Refresh PivotTable data

If you created a PivotTable, you probably noticed that changing values inside a table won’t change it inside the PivotTable. But instead of…

Posted On

Group data in PivotTable

In a PivotTable, you can group different types of values. I’ve written an article about grouping dates in PivotTables, so this one will…

Posted On