Performing logical and conditional calculations 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. Enhance your data analysis skills with our in-depth course on advanced formula techniques for Excel 365. In this course, discover how to build powerful nested formulas with logical and conditional functions, helping you to tackle complex problems with ease. First, learn to optimize your workflow by combining different logical functions and using the IFS and SWITCH functions for effective decision-making processes. Understand how to sum up data based on specific conditions and use conditional average functions to get useful insights from your datasets. Next, discover important techniques for counting data with conditions, using the MAXIFS and MINIFS functions to find maximum and minimum values within given criteria. Moreover, you'll learn the LET function make your calculations simpler and faster. 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.