Skip to main content
Business LibreTexts

7.18: Putting It Together- Microsoft Excel Intermediate Skills

  • Page ID
    46535
  • \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \) \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)\(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\) \(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\)

    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.

    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).
    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.
    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.

    Contributors and Attributions

    CC licensed content, Original
    • Putting It Together: Microsoft Excel Intermediate Skills. Authored by: Shelli Carter. Provided by: Lumen Learning. License: CC BY: Attribution

    7.18: Putting It Together- Microsoft Excel Intermediate Skills is shared under a CC BY license and was authored, remixed, and/or curated by LibreTexts.

    • Was this article helpful?