how to anylise milk table for excel

i made a table for milk analyst person.

you have columns below. 

  • milk
  • semi skimmed
  • whole milk
  • other
  • like
  • dislike
  • rating 1 to 5
  • rating 1 to 10
  • amount per day
  • health notes
there are lots of ideas for a milk analyse table. you just got to think out of the box. 

Comments

Post a Comment

Popular posts from this blog

the power of inner joins working with power query

Power Query Joining: How to Combine Data from Multiple Sources in Exce Power Query is a powerful tool for data cleaning and transformation in Excel. One of its key features is the ability to join data from multiple sources into a single table. In this article, we’ll show you how to use Power Query to join data from different sources in just a few simple steps. Step 1: Load your data sources into Power Query Before you can join data from multiple sources, you’ll need to load each source into Power Query. To do this, click on the "From Other Sources" dropdown in the "Get & Transform" group on the "Data" tab in the ribbon. Select the data source you want to load, such as an Excel spreadsheet or a CSV file, and follow the prompts to connect to the data source and load the data into Power Query. Step 2: Create a join relationship Once you’ve loaded your data sources into Power Query, you can create a join relationship between them. To do this, click on the ...
Read more

the sum function working with numerical data mastery

 The SUM function is one of the most commonly used functions in Microsoft Excel, and it allows users to quickly add up a range of numbers. Here are three key points about the SUM function: Syntax: The syntax of the SUM function is very simple. To use the SUM function, you simply need to specify the range of cells that you want to add up, like this: =SUM(A1:A10). This tells Excel to add up the values in cells A1 through A10. Range Selection: The SUM function can be used to add up any range of cells in a spreadsheet, including non-contiguous ranges. To select a non-contiguous range of cells, simply hold down the Ctrl key while clicking on each cell that you want to include in the range. AutoSum: Excel provides a quick and easy way to use the SUM function with the AutoSum feature. To use AutoSum, simply select the cell where you want to display the total, and then click the AutoSum button on the Home tab of the ribbon. Excel will automatically select what it thinks is the range of cel...
Read more