What are Table Style in Excel?
Before we study how we can use Table Style, lets understand how to change the color of the text, background of the cell or customize it. To Change the color…
0 Comments
August 5, 2023
What are Statistical & Math Functions in Excel?
Math Functions Sumif() The SUMIF function calculates the total of only those cells that meet a given condition or criteria. The syntax for the SUMIF function is : =SUMIF(Range,Criteria,Sum Range)…
August 3, 2023
How to do Paste Special?
Types of Paste Special in Excel You may not always want to copy everything from the source range to the destination range. For example, you may want to copy only…
August 3, 2023
What are Database Functions in Excel?
DATABASE FUNCTIONS There are six type of Database Functions. Following are the types of Database functions DMIN DMAX DAVERAGE DCOUNT DCOUNTA DGET DMIN DMIN function is useful to find out…
August 1, 2023
What is Solver in Excel?
Solver in Excel The Excel Goal Seek feature is a useful tool, but it clearly has limitations. It can solve for only one adjustable cell, and it returns only a…
August 1, 2023
What is Goal Seek?
Goal Seek It determines the value that you need to enter in a single input cell to produce the result that you want in a dependent (formula) cell. The following…
August 1, 2023
How to do Auditing in Excel?
What is Auditing? When you are preparing a worksheet you can make errors, i.e., a Data Entry Error: typing the wrong number, misspelling a word or name, or forgetting to…
March 25, 2023
What is Scenario Manager in Excel?
Scenario Manager Scenario Manager allows you to set up several different scenarios. You can use scenarios to predict the outcome of different situations in your spreadsheet. Suppose a company trying…
March 18, 2023
Financial Functions, MROUND()
Financial Functions Microsoft Excel provides a series of functions to perform various types of financial operations. These functions use some common arguments to solve a particular financial calculation. Basically, these…
March 18, 2023
Engineering, Lookup & Text Functions
Engineering Function CONVERT() Converts a number from one measurement system to another. CONVERT can translate a table of distances in miles to a table of distances in kilometers. The Syntax…
March 16, 2023