This example covers three aspects of sorting and compiling raw data from project results. The first sorting objective is achieved by using the UNIQUE function where we have sorted the unique causes from the given data and listed them to simplify the repetition of causes in the source list. The second objective was achieved by using the COUNTIF function and quantifying the causes leading to problems or non-conformances. The third is a shortcut (Alt F1) to generate charts in Excel to visualize the compiled data and put it into percentages.
You can use this example in a table of different functions in which you are given a list of variables and intend to sort, compile and quantify the data in Excel in a short time. This feature can do wonders in applying precision and intelligence to your spreadsheet, whether in Excel or Metaverse!
Credits:
Thumbnail photo by Justin Morgan on Unsplash
Please check out other Excel tips and tricks from the playlist link below:
https://youtube.com/playlist?listPLCgFWFNCLS4dYhDGypIchHtqLzl2DgPAd
Check out this playlist for Excel formulas and functions:
https://youtube.com/playlist?listPLCgFWFNCLS4f7Uei711ZR6el4HCFTsLDe
Free Excel course available on formatting techniques here:
https://youtube.com/playlist?listPLCgFWFNCLS4dKExc4r2ipAZv_VUEZs8Bn
Subscribe to Office tutorials for free on My Digital Quill:
https://www.youtube.com/channel/UCC6kqs7RQfX-Wa21DwqE60Q
#countiffunction #countiffunctioninexcel #excelcountiffunction #uniquefunction #uniquefunctioninexcel #excelsuniquefunction #Excelformulasandfunctions #Exceltipsandtricks #Excelshorts #quantifydatainexcel #sortdatainexcel #compiledatainexcel #excelchartshortcut
#MyQuillDigital
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
No Comments