Скачать с ютуб Excel VBA Introduction Part 58.8 - SQL for Excel Files - Conditional Functions в хорошем качестве

Excel VBA Introduction Part 58.8 - SQL for Excel Files - Conditional Functions

Writing SQL for Excel with ADODB playlist    • Excel VBA Writing SQL for Excel using ADODB   VBA Working with Databases playlist    • Excel VBA Working with Databases   Get files here https://www.wiseowl.co.uk/vba-macros/... If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link https://www.wiseowl.co.uk/donate?t=1​ to make a donation. Thanks for watching! Learn how to use IIf and Switch functions to test conditions and produce different results depending on the answer. You'll see how to create calculated columns using the IIf and Switch functions, as well as how to use the functions to control the sort order of your query results. You'll learn how to use nested IIf and Switch functions and how to write more complex logical tests using the AND, OR, IN and BETWEEN operators. Chapters 00:00 Topic List 00:52 The Basic Setup 03:08 Writing a Simple IIf Function 06:40 Comparing One Column to Another 08:21 Comparing Dates 10:05 Comparing Text 12:56 Using IIf to Sort Queries 15:29 Conditional Calculations 18:37 Nested IIf Functions 21:22 Combining Conditions with OR 23:00 Using the IN Operator 24:03 Combining Conditions with AND 26:10 Using the BETWEEN Operator 28:35 Tidying Up the Code 30:08 Basic Switch Functions 31:34 Including More Logical Tests 33:48 Including a Final Condition 35:33 Writing a Sequence of Logical Tests 39:05 Nested Switch Functions 44:22 Concatenating Switch Function Results 46:17 Sorting Using a Switch Function 50:05 What's Next? Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Power BI, DAX, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more