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.  

MS-Excel Introduction And Features  A software program created by microsoft that uses spreadsheets to organize numbers and data with formulas and function. Excel analysis is ubiquitous around the world and used by businesses of all sizes to perform financial analysis. MS Microsoft Excel is a spreadsheet program used to record and analyze numerical and statistical data.Microsoft excel provides multiple features to perform various operations like calculations, pivot tables, graph tools, macro programming etc.It is compatible with multiple OS like windows, macos, android etc.It is compatible with multiple and ios. CTRL+N=Create a new workbook CTRL+S=Saves the current workbook Definition MS Excel is a powerful program that useful for create and manage many reports like daily income and expand , students lists, employee list, inventory list customer or vendor list etc.In this program we can design form of reports as we want with many formulas for calculate any time of  numbers and ...

 Brand Awareness Loyality Brand awareness is key  to driving consumer's purchasing decisions . ... Even with all that, consumers still feel more comfortable purchasing from a brand they have heard of. In fact they are 60% more likely. And that's why driving brand awareness is so firmly linked to brand loyalty and revenue .  

  Marketing Marketing is the creation, communication, and delivery of value, as well as the management of customer relationships for a lifetime.  

  Customer   A customer is an individual or business that purchases another company's goods or services. Customers are important because they drive revenues; without them, businesses cannot continue to exist. All businesses compete with other companies to attract customers, either by aggressively advertising their products, by lowering prices to expand their  customer bases , or by developing unique products and experiences that customers love. Think Apple, Tesla, Google, or TikTok.

  Commerical Message commercial message -  a commercially sponsored ad on radio or television .  commercial . ad, advert, advertisement, advertising, advertizement, advertizing - a public promotion of some product or service. infomercial, informercial - a television commercial presented in the form of a short documentary.    

  Social Optimaziation Social Media Optimization (SMO) is a new term that was recently coined by Rohit Bhargava and has since been taking on life of its own. SMO tactics can drive huge amounts of people to a website and can also determine whether a startup, website or idea will make it or not.  

  Social Networking Social Networking refers to grouping of individiuals and organization together via some medium , in order to share thoughts , interests and acitivities.There are several web based social network services are available such as facebook , twitter , linkedin , google+ etc.  

 Social Media Social Media Marketing is a process that empowers individuals to promote their websites , products , or services through online social channels and to communicate with and tap into a much larger community that may not have been available via traditional advertising channels.  

 Definition Of  Advanced  Office     The role of the office management professionals and administrators in today’s organisation is changing rapidly. What is the way forward? The true art of office management & administration lies not in the art of winning, rather it demands the art of winning consent. In order to remain competent in the workplace administrators, office managers and secretaries need to be equipped with the relevant knowledge and skills. This Advanced Office Management & Effective Administration Skills training course identifies and examines the key components of the role and within each element builds up a range of approaches and techniques for operating an efficient office or support team. These elements include: office management, communication, organisational, interpersonal & administrative competencies. 1) MS EXCEL 2) MS WORD 3) MS POWER POINT  4) NOTEPAD 5) OUTLOOK

 Digital Marketing Trends For Your Presentation  Search engine marketing technology trends look up results on info.com.Search digital marketing technology trends.Find result on info.com.Great tech resources search info today explore tech information find more information. Interactive Content Interactive content is content that requites active engagement from its consumers. Audience are more demanding that ever as they expect all content to be engaging, relevant and accessible on any device at any time. Visual Content Visual content is online content that primarily image based common forms of visual content include pictures, diagrams, charts, infographics, online videos, screenshots, memes and slidedecks. Expiring Content  Expired content relates to content on a site which has an expiration date where it is no longer useful for visitors. This may be past events or products which are no longer stocked.Expired content can impact a sites SEO while also affecting search engine...

 Different/Types Part Of A Digital Marketing Presentation    Digital  marketing can be broadly broken into 7 main categories including: a) Search Engine Optimization , b) Pay Per Click  , c) Social Media Marketing , e) Content Marketing , f) E-Mail Marketing , g) Mobile Marketing , h) Marketing  Analytics. 1) Search Engine Search engine marketing (SEM) is a  digital marketing strategy used to increase the visibility of a website in search engine results pages (SERPs) . ... Search engine marketing is also alternately referred to as paid search or pay per click (PPC).   2) Pay Per Click Pay-per-click (PPC) is  an internet advertising model used to drive traffic to websites , in which an advertiser pays a publisher (typically a search engine, website owner, or a network of websites) when the ad is clicked.   3) Social  Media  Marketing Social media marketing  uses  social media  and  social networks  to ma...