Tomasz Decker – Page 3 – Excel Tutorial

How to Calculate Percentages in Excel

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…

Drop-down lists are useful when it comes to selecting one item from multiple choices. They are very popular in online forms, especially for…

When you download files from the Internet, the file may be opened in the Protected View. It’s a read-only mode. Unless you need…

In this article, I’ll present how you can extract or remove the text before and after a character. In the later part, there…

To convert a standard date to a month and year, you can use the TEXT function. This function converts a value to text…

With the COUNTIF function, you can count the number of cells that meet a single condition. Example The following example contains a list…

You can perform similar operations on dates and numbers because dates in Excel are nothing more than numbers in a date format. You…

When you work with Excel, you can switch between sheets by just clicking them. But when you have many of them, that you…

When you are working with data inside an Excel worksheet, sometimes you need to delete a particular type of data. If you have…