I want to update Excell knowledge

Shanna Strevel 0 Reputation points
2026-11-17T20:32:17.56+00:00

I am trying to find courses to brush up on Excell. I'd like to learn formulas and tabulations. I know in Dataverse you can use open AI however I am wanting to learn Excell and how it has changed since I used it last. I want to update myself on Excell. Is it under spreadsheets? I cannot find it on here at all.

Community Center | Not monitored
0 comments No comments

1 answer

Sort by: Oldest
  1. AI answer

    2026-11-17T20:33:07.98+00:00

    Excel training is primarily available through the Excel help & learning hub rather than under a “Spreadsheets” category in Microsoft Learn.^1^

    1. Refresh the Excel basics
      • Open Excel help & learning.
      • Start with Get started, then continue to Format data and Formulas & functions.
      • The same hub includes sections for importing and analyzing data, PivotTables, XLOOKUP, IF, and other current features.^1^
    2. Learn formulas
      • Work through Overview of formulas in Excel. It covers:
        • Formulas beginning with =
        • Cell and range references
        • Relative references such as A1
        • Absolute references such as $A$1
        • Built-in functions
        • Newer functions such as XLOOKUP
      • It also provides a downloadable tutorial workbook for practicing common formulas.^2^
      Start by practicing:
         =SUM(B2:B20)
         =AVERAGE(B2:B20)
         =COUNT(B2:B20)
         =IF(B2>=100,"Target met","Below target")
         =XLOOKUP(E2,A2:A20,B2:B20,"Not found")
      
      The formula examples library also groups exercises by conditional, lookup, date/time, financial, and statistical formulas.^3^
    3. Learn tables and tabulation For summarizing or “tabulating” a list, the relevant Excel feature is usually a PivotTable. A PivotTable calculates, summarizes, and analyzes data to reveal comparisons, patterns, and trends.^4^ In Excel for Windows:
      1. Arrange the source data in columns with one header row.
      2. Select the data.
      3. Choose Insert > PivotTable.
      4. Select New Worksheet.
      5. Select OK.
      6. In PivotTable Fields, place descriptive fields in Rows and numeric fields in Values.
    4. Explore newer Excel capabilities After refreshing formulas and PivotTables, continue with dynamic array formulas. These allow one formula to return several results that “spill” into adjacent cells.^5^ For example:
         =F10:F19*G10:G19
      
      For broader modern analytics, Microsoft Learn has an intermediate Excel and Power BI module covering XLOOKUP(), FILTER(), LET(), PivotTables, and Excel reports connected to Power BI datasets. It assumes prior Excel and PivotTable knowledge, so it is best used after the refresh above.^6^

    The general Microsoft 365 training catalog is also available, but it covers the full Microsoft 365 ecosystem rather than providing a dedicated beginner Excel curriculum.^7^


    References

    1. Excel help & learning
    2. Overview of formulas in Excel
    3. Examples of commonly used formulas | Microsoft Support
    4. Create a PivotTable to analyze worksheet data | Microsoft Support
    5. [Microsoft 365](https://support.microsoft.com/excel/guidelines-and-examples-of-array-formulas)
    6. Transcend data analysis together with Power BI and Excel - Training
    7. Browse all training
    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.