Exploring essential functions in Excel 365 (2023)

Skillsoft issued completion badges are earned based on viewing the percentage required or receiving a passing score when assessment is required. Excel functions cover a wide array of uses, from formatting text to performing calculations. This course delves into several of the most common functions in Excel 365. The course begins by exploring fundamental functions for working with data. You will see how to perform operations based on specific conditions using the IF() function. Learn how to use functions to count cells, round numbers, and generate numeric data. You will also discover the OFFSET() function, which lets you extract specific values from a dataset. The second part of the course covers some helpful functions for working with text. See how to clean up your text by removing spaces and changing letter case. Find out how to count characters and character positions using LEN(), SEARCH(), and FIND(). Finally, you will see how to use functions to extract text, combine multiple text strings, and replace one string with another. This course aligns with the objectives of Exam MO-210: Microsoft Excel (Microsoft 365 Apps). In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane.