Tomasz Decker – Excel Tutorials

How to Transpose Data in Excel

Sometimes you have to switch columns with rows inside your table. This process is called transposing, and you can do it in Excel…

If you create a table from data, Excel will automatically apply a default formatting to it. Let’s see how it works in practice….

You can move, copy or link cells between worksheets to organize your data the way you want. You can copy sheets in the…

Usually, when you work with Excel, we want to copy a range of cells or a single cell. But, sometimes we want to…

Find and Replace The easiest way to find multiple values in Excel is to use the Find feature. First, select cells you want…

Rearranging data from rows to columns or columns to rows is called transposing. It’s useful when you want to change the structure of…

When you work with multiple columns of data, which is usually the case, sometimes it may be smart to simplify data. For example,…

Excel provides special filters that you can use to filter dates in Pivot Tables: Checkboxes for individual dates, Specific cell ranges, Dynamic cell…

Percent means per cent, and the cent is 1/100 of a dollar. A percent is 1/100 of a whole. Percentages are used in…

Excel offers a robust tool for filtering Pivot Tables with the VBA code. In this article, I’m going to show you different ways…