Counting occurrences of a character in a spreadsheet
In this Excel tutorial you will teach yourself how to count occurences of a character in a spreadsheet.
Best Excel Tutorial
The Largest Excel Knowledge Base ✅ The Best Place to Learn Excel Online ❤️
Return the last value in a column
In this Excel tutorial, you will learn how to create a formula which returns the last value in a column.
How to generate random text from the list?
In this Excel tutorial, you learn how to generate random text from a list.
Count of quarters between dates
In this Excel tutorial lesson, you will learn how to calculate the count of quarters between two dates using the Excel application.
How to display a single quote in a cell?
In this Excel lesson, you will teach yourself how to deal with single quote issues.
How to Show Year over Year Growth
In this Excel charting tutorial lesson, you will create a year-over-year report using a pivot table. You may need that for reports in Excel. Analysts will be especially happy because of that lesson.
Counting unique values in pivot table
In this lesson, you will teach yourself how to do counting only distinct values in pivot table. Do you think it is difficult? You will be suprised.
Adding average to the pivot table
In this Excel tutorial, you will learn how to add average column to the pivot table in Excel. This is a very useful and simple trick.
Display Data as Percentage of Total in Pivot Table
In this lesson, you will learn how to display pivot table data as percentage of total. To display data as a percentage of the total in a pivot table, you can use the “Show Values As” feature in Microsoft Excel. It is really easy and it might be helpful for you.