{"id":232,"date":"2022-12-01T20:31:46","date_gmt":"2022-12-01T20:31:46","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/chapter\/putting-it-together-microsoft-excel-intermediate-skills\/"},"modified":"2022-12-01T20:31:46","modified_gmt":"2022-12-01T20:31:46","slug":"putting-it-together-microsoft-excel-intermediate-skills","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/chapter\/putting-it-together-microsoft-excel-intermediate-skills\/","title":{"raw":"Putting It Together: Microsoft Excel Intermediate Skills","rendered":"Putting It Together: Microsoft Excel Intermediate Skills"},"content":{"raw":"\nNow that you know some of the more advanced tools available in Excel, let us take a look at our opening list of possible questions and match those with an Excel function we just covered.\n
    \n \t
  1. You want to see which month had your highest sales volume. You could see this by sorting your data Z to A (largest to smallest number).<\/em><\/li>\n \t
  2. You have a total clothing inventory but you want to know how many pants you have in stock. You could see this using the COUNTIF function.<\/em><\/li>\n \t
  3. You want to know how many months from last year you were under budget. You could see this with the IF function, just like in our learning example.<\/em><\/li>\n<\/ol>\n

    Contribute!<\/h2>
    Did you have an idea for improving this content? We\u2019d love your input.<\/div>Improve this page<\/a>Learn More<\/a>\n","rendered":"

    Now that you know some of the more advanced tools available in Excel, let us take a look at our opening list of possible questions and match those with an Excel function we just covered.<\/p>\n

      \n
    1. You want to see which month had your highest sales volume. You could see this by sorting your data Z to A (largest to smallest number).<\/em><\/li>\n
    2. You have a total clothing inventory but you want to know how many pants you have in stock. You could see this using the COUNTIF function.<\/em><\/li>\n
    3. You want to know how many months from last year you were under budget. You could see this with the IF function, just like in our learning example.<\/em><\/li>\n<\/ol>\n

      Contribute!<\/h2>\n
      Did you have an idea for improving this content? We\u2019d love your input.<\/div>\n

      Improve this page<\/a>Learn More<\/a><\/p>\n\n\t\t\t

      \n\t\t\t

      Candela Citations<\/h3>\n\t\t\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t\t\t\t
      CC licensed content, Original<\/div>