Digital Marketing

  Count IF/ Count IF Else                                                                COUNT IF Count if is an excel function to count cells in a range that meet a single condition.Count if can be used to count cells that contain dates, numbers and text.The criteria used in count if supports logical operators(>,<,<>,=) and wild cards(  *,?) for partial matching.                                                         COUNT IF ELSE  1) How do 1 count an if statement in excel . Ans= a) SELECT a cell b) TYPE=Count if c) Double click the count if command d) Select a range. e) TYPE f)  Select a cell (the criteria the value that you want to count) h) Hit ente...

 Sum IF / Sum IF Else Sum IF : The sum if function is used to sum up the values of some specific cells of a column , the cells which meet certain criteria. Sum if is a conditional function used to sum the value of any particular cell in a column. Sum if function is one of the eight functions of a function group in excel. The sum function is a worksheet function that adds all numbers in a range of cells based on one criteria (for example is equal to 2000). The sum if function is a built in function in excel that is categorized as a math/ trig function to add numbers in a range based on multiple criteria try the sum if function. Sum IF Else:   You use sum ifs in excel to find a conditional sum of values based on multiple criteria. The sum ifs function was introduced in excel 2007. So you can use it in all modern versions of excel 2019, 2016, 2013, 2010, and 2007. If  you want you can apply the criteria to one range and sum the corresponding values in a different range and...

  Pivot Table These are tables which summarize and allow you to count , sum , and average among other calculations according to the data you require.When you know how to do this it becomes even easier to crush data and create reports that your business needs. A Pivot Table is a table of grouped values that aggregates the individual items of a more extensive table within one or more discrete categories.This summary might include sum, averages or other statistics which the pivot table groups together using a chosen aggregation function applied to the grouped values. 1) What is a pivot table used for. Ans- A pivot table is an interactive way to quickly summarize large amounts of data. You can use a pivot table to analyze numerical data in detail and answer unanticipated questions about your data. A pivot table is especially designed for: querying large amounts of data in many user friendly ways. 2) What is pivot table and its advantages.   Ans- Pivot table are worksheet tables t...

 Data Sorting EXCEL allows you to sort the data in your spread sheets ino order. For example alphabetical order or reverse alphabetical order. This is a tricky technique to master because in some situations you can accidentally sort one row or column and not another which will mess up a spreadsheet. These tricky man oeuvres are the reason why it's necessary to take a proper well organised excel course. 1) What is sorting of data in excel . Ans Sorting in excel is arranging data auording to our requirements.It can be done alphabetically or numerically basic sorting works when sorting is to do on only one column.Advanced sorting is used in multi level sorting viz sorting required in one or more than 2 columns. 2) How many types of sorting in ms excel . Ans In excel you can sort your table by one or more columns by ascending or descending order or do a custom sort. 3) What is a data sorting . Ans Sorting is the process of arranging data into meaningful order so that you can analyze it...

 Data Filters This may seem to be a very basic excel skills to some but if you don't know how to work with data filters, you'll need to develop this skill to stand out from the crowd.when you know how to use data filters you can sort, hide and search for crucial bits of information in a spreadsheet anytime you need to.The following steps for data filters in the way: 1) CLICK any where in your chart. 2) CLICK the chart filters button. 3) ON the values tab , check or uncheck the series of categories you want to show or hide. 4) CLICK apply. 5) IF you want to edit or rearrange the data in your series , click select data and then follow steps 2-4 in the next section. 1) What are the three types of filters in excel . Ans In excel you can create three kinds of filters: by values, by a format , or by criteria.But of these filters types is mutually exclusive for example you can filter by cell color or by a list of numbers , but not by both you can filter by icon or by a custom filter b...

 Advantage Of  MS-Excel    Easy Data Entry and operations one of the main advantages of  ms excel is that it facilitates smooth and easy data entry compared to any other data entry and analyzing tools .Ms Excel offers features like ribbon interface a set of commands used to perform certain operations. Disadvantage Of  MS- Excel       1) Difficult to manage advanced pricing rules. 2) Lack of control and security. 3) Excel is vulnerable to Fraud/Corruption. 4) Excel is susceptible to human error. 5) Excel is difficult to trouble shoot or test. 6) Excel is obstructive to regulatory compliance.