Skip to main content
Business LibreTexts

8.21: Putting It Together- Microsoft Excel Advanced Skills

  • Page ID
    46558
  • \( \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}}\)\(\newcommand{\AA}{\unicode[.8,0]{x212B}}\)

    Now that you’ve learned more about Microsoft Excel, let’s revisit a few of the hypotheticals we talked about in the beginning of this module:

    • You may find yourself completing the same tasks over and over again. This can often be automated, either with a function or with a macro.
    • You may find yourself re-creating tables, because they weren’t organized the way you need them to be. The PivotTable tool may be a good solution for this.

    As with Word, there’s more that Microsoft Excel can do. If you find yourself curious, Microsoft’s website is a good place to check, or you can run a web search for how to use a particular feature.


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

    • Was this article helpful?