Using advanced functions in Excel 365 (2024)

Skillsoft issued completion badges are earned based on viewing the percentage required or receiving a passing score when assessment is required. Excel 365 offers a variety of advanced functions for data management and formula creation. In this course, discover how to build formulas to find information in tables, work with data arrays, and obtain date-related information. First, enhance your data management and analysis skills with powerful lookup functions such as VLOOKUP, HLOOKUP, and the newly introduced XLOOKUP. These tools are crucial for cross-referencing data across different lists, identifying and filling in missing information, and precisely inserting relevant data. Next, learn techniques to retrieve, manipulate, and analyze information based on dates. Deal effectively with historical records, current data, or future projections by mastering date-related functions such as NOW, TODAY, WEEKDAY, and WORKDAY in Excel 365. Additionally, learn to summarize complex tables containing multiple arrays, equipping you with the analytical skills to extract meaningful insights from extensive datasets. For instance, use the RANDARRAY function to create random arrays for simulation or sampling purposes, enhancing your modeling and analytical capabilities for various scenarios. Finally, refine your ability to organize and clarify your data with advanced sorting and filtering techniques using formulas, ensuring that you can present your findings clearly and impactfully. This course aligns with the objectives of Exam MO-211: Microsoft Excel Expert (Microsoft 365 Apps). In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane.