Once you start learning Excel, it’s a challenge to retain all the knowledge. If you need an Excel practice test, check out this list!
Author Archive | Harshita Srivastava
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!
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!
8 Excel Macro Examples to Help You Master Macros
When you create a macro in Excel, you are recording your mouse clicks and keystrokes that will be followed in an automated manner, such that the workload of a particular redundant task is reduced. Click to know some Excel macro examples to help you master macros!
How to Use the Countif Greater Than Function in Excel
We will discuss the different methods of counting cells on the basis of conditional statements, and further would jump to the main topic of discussion: Using Countif Greater than function in Excel. Click to know more!
How to Count Cells with Specific Text in Excel
Microsoft Excel offers a wide array of features that use a grid of cells arranged in letter named columns and numbered rows to organise, formulate, manipulate and format data. In this article, we will discuss the different methods of counting cells on the basis of conditional statements. Click to know more!