Tutor profile: Baylee H.
Subject: Microsoft Suite
How can I count the total number of each item in my inventory using only excel?
That is actually done with just a table and a few simple formulas: 1. Create a table with the following headers: Product and Count 2. List out each product that you have, be sure to spell it exactly the same way it is spelled in your inventory sheet. For example: Red Apple, Green Apple, Grapes, Bananas. 3. in the "Count" column of your table, enter a countif formula. This formula will look through a specific column on your inventory worksheet for whatever phrase you tell it to and count only those cells. This will give you an accurate count of how many times that phrase appears in the inventory list. Structure of a countif forumla: =countif(row you want to look in, term you want to look for). For example: On your inventory worksheet, you are working in 3 columns: Column A: Inventory List by Product Name Column B: Table - Product Name Column C: Product Count You want to look for how many of each specific product are found in Column A, by using a formula in Column C. In your table, your product names are in the following cells: Red Apple: B2 Green Apple: B3 Grapes: B4 Bananas: B5 The formulas for each respective product would be: Red Apple: =countif(A:A,B2) Green Apple: =countif(A:A,B3) Grapes: =countif(A:A,B4) Bananas: =countif(A:A,B5) The total count of each product (i.e. the number of times it appears) in Column A will appear in Column C.
I am having trouble structuring my argumentative essay in a way that gets my point across. I've had points taken off before for papers being confusing and difficult to follow.
That is actually a very common problem to have, especially when you have a larger research paper that requires you to keep a lot of facts straight in your mind. The best method I've found is to actually build out a skeleton, like the one below, before you start writing and use your research to fill it out. Intro Paragraph: - 1 to 2 sentences giving context to you paper and stating what you will be arguing for (or against). - Thesis Statement - The 3 to 4 points you will be making to prove your argument. (Quick Tip: It helps to write these points out in list form in the beginning and use them to shape the body of your paper, each point in your thesis will be the theme of a full body paragraph). Body Paragraph 1: 3 to 5 sentences explaining why the first point in your thesis proves your argument. Be sure to end the paragraph by clearly drawing the line between your argument and your first point. Body Paragraph 2: 3 to 5 sentences explaining why the second point in your thesis proves your argument. Again, be sure to end the paragraph by clearly drawing the line between your argument and your second point. Body Paragraph 3: 3 to 5 sentences explaining why the third point in your thesis proves your argument. Again, be sure to end the paragraph by clearly drawing the line between your argument and your third point. Conclusion Paragraph: This should directly mirror your introduction paragraph. Start by restating your thesis to bring the paper to a close. Then restate what your point was and your final conclusion. This should only be about 3 sentences. By following this structure, you should be able to help direct your thoughts in one organized direction. This will make it easier for the reader to understand you, as well as making it easier for your to prove your argument.
What exactly is a brand tribe and why is it important?
A brand tribe is a group of consumers who believe strongly enough in a brand that they become advocates and promoters of the brand itself. They help a brand to take on a life of it's own in an organic way, helping with brand visibility and affinity. One of the best examples of a brand tribe is Jeep drivers. Not only are they loyal to the brand, but they make sure everyone knows they drive one. They wear the shirts, carry the bags, and make sure to tell everyone they know about their jeeps. Jeep drivers even have their own special wave they do to acknowledge each other! That level of affinity for the brand has helped to grow its visibility and popularity with a minimal amount of advertising resources be expended.
needs and Baylee will reply soon.