Skip to main content
Business LibreTexts

7.1: Why It Matters- Microsoft Excel Intermediate Skills

  • Page ID
  • \( \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}}\)

    Why learn to complete intermediate skills in Microsoft Excel?

    In the last module, we focused on some basic functionality in Excel. But this program is capable of a lot more, including automatically organizing data (known as Sort), hiding data (Filter), and even more advanced functions that will automatically format cells visually if they meet certain conditions.

    Before we move into the mechanics of each of these tools, let us consider for a moment the types of questions you may have when looking at data in an Excel worksheet.

    1. You want to see which month had your highest sales volume.
    2. You have a total clothing inventory but you want to know how many pants you have in stock.
    3. You want to know how many months from last year you were under budget.
    4. You want to see a graphic that represents your data instead of the actual numbers.

    All of these questions can be answered with the valuable tools available in Excel and most importantly, without manually looking through all of your data!

    Contributors and Attributions

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

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

    • Was this article helpful?