# Archive | Basic Excel Functions and Formulas

## How to Use Excel Paste Special and Paste Values

Have you ever noticed those “extra” paste options like Paste Special in Excel and Excel Paste Values? Ever wonder what they do? Click here to find out!

## How to Fit Text on One Page Using Autofit Excel

Your spreadsheet is done and want to print it out, but it won’t fit on one page! Click here to learn how to fix it this with the “autofit excel” function.

## How to Add a Calculated Field to Your Excel Pivot Table

Calculated fields are the types of fields that depend on other basic field data for their own and hence, the user does not control the entry of values in these fields. Click to know how to add a pivot table calculated field!

## How to Use the Forecast and Trend Function in Excel

The forecast is something that assumes for future. A trend is something that represents the current day. Forecast and Trend function in Excel help in predicting the values that are missing in the existing data. Click to know more!

## How to Remove Spaces in Excel Using the Excel Trim Function

It is not that difficult to remove extra spaces in Excel by using the Excel TRIM Function. Click here to find out how easy it is!

## How to Replace Text by Using the Excel Replace Function

The Excel REPLACE function is a shortcut that can save you time and aggravation! Click here to find out how to use this useful and simple function.

## An Overview of Excel Time Functions

The Excel time function is an inbuilt function in Microsoft Excel which allows the user to create time with components of time; hours, minutes and seconds. This function can be embedded within another function, when you need to display accurate time. Click to know more about Excel time functions!

## What Is the Mod Function in Excel?

MOD is an arithmetic function which is used to solve typical arithmetic problems. Click to know more about MOD function in Excel!

## How to Handle Countif with Multiple Criteria in Excel

Counting in Excel is one of the most used functions. Most of the requirements in business are either counting or related to the counting of data. For example, if you are working in a business you may need to know how many people are using a particular brand of shampoo. To count this data, you […]

## What You Should Know about Formula Auditing in Excel

Function auditing is the procedure following which, one can display the relationship between cells and also track the functioning of a particular function. Click to know more about Formula Auditing Excel!