Advanced Excel 2021

Advanced Excel 2021

0
Certificate

Paid

Language

Level

Intermediate

Access

Free

Last updated on June 20, 2025 2:21 pm
Advanced Excel 2021
Category:

Spreadsheets are powerful data science tools so take this MS Excel training course to learn how to use its advanced features to analyze and present information.

Add your review

Are you looking to take your MS Excel skills to the next level? Are you curious about the new features introduced in Excel 2021? This online course on Excel 2021 is here to satisfy your professional and personal needs to upgrade your proficiency. This course has got everything from identifying the new additions of this version of Excel to the essential functions and formulas that can help you sort and analyze data. Enroll now and keep learning!

What You Will Learn In This Free Course

  • Examine the key behaviours known as …
  • Identify the key differences between…
  • Describe the role of the SORT functi…
  • Explain how to use the SORTBY functi…
  • Examine the key behaviours known as ?arrays? and ?spills? and how to properly apply them in MS Excel 2021
  • Identify the key differences between unique and distinct values along with their usage with multiple criteria and columns
  • Describe the role of the SORT function and how to apply it in the proper manner
  • Explain how to use the SORTBY function in Excel, particularly the horizontal Sort aspect
  • Examine the use of the SEQUENCE function and how to unstack records from the source data
  • Describe the use of the FILTER function in Excel 2021 along with various logic aspects
  • Explain the use of RANDARRAY and RANDBETWEEN functions in Excel 2021 and how they can be applied to randomize data
  • Describe the application of two-way LOOKUPS, XLOOKUP and XMATCH functions to perform complex lookups
  • Identify the difference between the CHOOSE and SWITCH functions to sort out source data
  • Examine the use of statistical functions such as means, median and mode in Excel 2021 to perform calculations
  • Explain how to rank and find the largest/smallest values present within the source data through various functions
  • Describe how to apply the rounding off and aggregate functions in Excel 2021

    • User Reviews

    0.0 out of 5
    ★★★★★
    0
    ★★★★★
    0
    ★★★★★
    0
    ★★★★★
    0
    ★★★★★
    0
    Write a review

    There are no reviews yet.

    Be the first to review “Advanced Excel 2021”

    ×

      Your Email (required)

      Report this page
      Advanced Excel 2021
      Advanced Excel 2021

      Go to Class

      Related Products

      Uncategorized

      Business Futures: Understanding Omni-channel Retailing and Supply Chains

      futurelearn.com
      0
      Uncategorized

      An Introduction to Screenwriting

      futurelearn.com
      0
      Uncategorized

      What Is Poetry? An Introduction to Literary Analysis

      futurelearn.com
      0
      LiveTalent.org
      Logo
      LiveTalent.org
      Powered by  GDPR Cookie Compliance
      Privacy Overview

      This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.