Logical Tests - Excel Formulas, Conditional Formatting, PivotTables, Power Query, and More

Logical Tests - Excel Formulas, Conditional Formatting, PivotTables, Power Query, and More

Dive into an extensive video tutorial on logical tests in Excel, covering a wide range of topics from basic concepts to advanced techniques. Learn how to use Excel formulas, conditional formatting, PivotTables, and Power Query to perform various logical operations. Explore single condition, AND, OR, and complex logical tests, as well as their applications in functions like COUNTIFS, SUMIFS, and FILTER. Discover how to implement logical tests in cross-tabulated reports, quality control processes, and financial analyses. Practice with real-world examples, including creating monthly sales reports, assessing credit worthiness, and extracting data from CSV files. Gain hands-on experience with downloadable Excel files and supplementary materials, and conclude with challenging homework problems to reinforce your newly acquired skills.