## How to only show the year in Excel

Excel has different ways on how you can be able to show the year alone without having to go through so much hassle. All you have to do is to format the date in excel or use a formula. With that, you will be able to display the year, which is the most important part …

## How to Freeze Excel Top Row and First Column

Microsoft Excel is the leading spreadsheet program for Microsoft windows. It is efficient for many users who mainly intend to analyze and record data. Its advantage is that it auto-fills data when making calculations, making it fast for users. On some occasions, one may intend to freeze the top row and the first column. Freezing …

## How do I get the undo button back in Excel

While using Excel in one way or another other, you will come across the need to return back to the last or more actions that you made. This is where the undo button becomes of much usefulness. The undo button has the ability to return back more than 100 actions depending on the Microsoft version …

## How to calculate per capita in Excel

Per capita is basically the amount of money each person earns in a specific nation or geographical region. This amount is used as a barometer in determining the average income that a person earns. It is able to evaluate a group of individuals’ standard of living in a geographic region, whether it is a country, …

## How to calculate cost per unit in Excel

In any business, cost per unit calculation is a value calculation. This calculation is defined as a total cost, which includes all costs associated with production, marketing, delivery, warehousing, sales, management, etc., for only a unit of the product. The article will take you through how to do this in excel. Here is the formula …

## How to paste opposite in Excel- 3 easy ways

Copying and pasting is a normal occurrence in Excel. Most times, we are used to copying data and pasting it as it is. But what if you need to copy and paste a list of column or row data in reverse order? There is no direct in-built function in Excel that reverses a list of …

## How to vlookup in Excel from another cell

VLOOKUP is one of Excel’s most useful functions. It is also the most misunderstood function, as people find it hard to apply. This function looks up a value in the first column of a given range and returns a value in the same row of another column. In short, this function will search through your …

## How to count per category in excel

While doing data analysis, you will one way need the skill to count data per category. This skill is important when you want to tally data by category. Excel provides you with multiple ways that you can use to count cells in rows or columns of data by category. The article will provide you with …

## How to sum in per month, week, or day in Excel

When you have a big chunk of data, it may become tedious to sum up, every monthly, weekly, or even yearly total one by one. Excel has several ways to do this without so much hassle. Here are some of the ways you can sum in per month, week, or day in excel easily. Sum …

## How to insert, edit or remove outside border in Excel

While using excel, you need to learn how to present data in your spreadsheets. One of these important skills is inserting, editing, and removing borders in excel. The borders are important so you can separate information like headers and total rows from the rest of the table. Therefore, it is important that you know how …