'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Where to Learn About New Excel Formulas and Functions
Question details
Users are looking for reliable and up-to-date resources to discover, learn, and master new formulas and functions in Excel.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Improving spreadsheet skills and staying updated on the latest calculation capabilities.
- Observed behavior
- The user wants to find official announcements, tutorials, and comprehensive lists of available spreadsheet functions.
Determine whether you are using a Microsoft 365 subscription or a standalone version (like Excel 2019), as many new functions are released exclusively to subscription users first.
Utilize Official Microsoft Excel Resources
The most accurate and up-to-date place to learn about new functions is directly through Microsoft's official blogs and support pages.
Microsoft provides a comprehensive suite of learning materials ranging from introductory articles to detailed function catalogs. Staying connected to these official channels ensures you learn the correct syntax and discover newly added features as soon as they roll out.
Check the official Excel Blog on the Microsoft Tech Community regularly. This is where Microsoft announces new features, provides tips, and shares deep-dive tutorials on newly released formulas.
Navigate to the Microsoft Support website and search for 'Excel functions (by category)'. This page lists all available functions grouped by purpose (e.g., Financial, Logical, Text) and identifies newer functions exclusive to Microsoft 365.
Search for the 'Overview of formulas in Excel' article on the Microsoft Support site. It serves as an excellent starting point for understanding how to structure and troubleshoot your calculations.
Explore Functions Directly Inside Excel
You can discover and learn about functions without leaving your spreadsheet by using the built-in Insert Function dialog.
Master Formulas with WPS Office Spreadsheet
Looking to practice your spreadsheet skills without the high cost of a Microsoft 365 subscription? WPS Office offers a powerful, free Spreadsheet tool that supports a vast array of standard and advanced formulas. It provides a familiar interface, ensuring you can apply your newly learned functions effortlessly.
- 1. Download and Install: Visit the official WPS website to download and install the free WPS Office suite on your device.
- 2. Open a Spreadsheet: Launch WPS Office and click on 'Spreadsheet' to create a new blank workbook or open an existing Excel file.
- 3. Use Formula Suggestions: Type '=' in any cell followed by a letter to instantly see a dropdown list of available formulas with syntax hints.
Frequently Asked Questions
Are new Excel functions available in older versions of Excel?
No, many new functions (such as XLOOKUP, FILTER, or UNIQUE) are exclusive to Microsoft 365 subscriptions or newer standalone versions like Excel 2021. Older versions like Excel 2016 or 2019 will not support these newer dynamic array functions.
Does WPS Office support Excel formulas?
Yes, WPS Spreadsheet is highly compatible with Microsoft Excel and supports the vast majority of standard functions, allowing you to use your existing formulas without modification and learn new ones in a familiar environment.
How can I quickly find what a specific formula does?
You can use the 'Insert Function' (fx) button next to the formula bar in your spreadsheet software. Selecting a function from the list will display a brief description and its required arguments right on the screen.
Are there built-in tutorials in Excel for formulas?
Yes, Excel offers built-in interactive templates. You can go to File > New and search for 'Formula Tutorial' to download a guided template designed to teach basic and advanced functions step-by-step.
