Скачать или смотреть Excel Calls Text Data - Or How To Return a Column Title If Value is 1

   • Excel Calls Text Data - Or How To Return a...   Excel Calls Text Data - Or How To Return a Column Title If Value is 1

This is the first SQA (Student Questions Answered) lecture from Level 2.

John has an Excel file with various values in columns A, B and C, which are either charges for Calls, Text or Data.

We will look at logical tests ( IF ), and then how to nest logical nests.

Starting simply, we will test is a value is less than 0, then return the column heading, for each of the three columns individually...

...then we will combine all three in a concatenation (joining), to return a column of data that shows for each line, which services were charged!



This is a sample lecture from my course, Microsoft Excel Essentials: Level 2 - Intermediate/Advanced.

Get this course now!

Level 1: Microsoft Excel Essentials: Level 1 Basics - Excel Made Easy
The complete 4 hour course is yours for a low cost monthly subscription (first 2 months free!):
https://www.alangjarvis.com/excel-ess...

Level 2: Microsoft Excel Essentials: Level 2 - Intermediate/Advanced
The complete 9 hour course is yours for a low cost monthly subscription (first 2 months free!):
https://www.alangjarvis.com/excel-ess...

Level 3: Microsoft Excel Essentials: Level 3 - VBA Programming + Macros
The complete 13.5 hour course is yours for a low cost monthly subscription (first 2 months free!): https://www.alangjarvis.com/excel-ess...

Alternatively, you can purchase the complete set in...
Excel Essentials: The Complete Excel Series - Level 1, 2 & 3

The WHOLE 27.5 Hour Excel Mastery Series In One! From Excel Novice To VBA Programmer...
Available to buy with lifetime access for just $16.99 (normally $200) here:
https://www.alangjarvis.com/excel-ess...

This course is for suitable Excel 2007, Excel 2010, Excel 2013, 2016, 2019 & 365

Videos in the Level 1 series:
   • Opening Excel, And Creating A Desktop Shor...  
   • The Anatomy Of An Excel Workbook  
   • What's Where In Excel In 5 Minutes  
   • Always Do This First In Excel...Save Your ...  
   • Entering Data In Excel  
   • Editing Data In Excel  
   • What To Do If You Make A Mistake In Excel  
   • Reverse Engineering A Sample Spreadsheet T...  
   • Casing And Text Functions In Excel  

Videos in the Level 2 series:
   • Excel: Proof Of Concept (excel view 2 shee...  
   • Excel: Planning Ahead  
   • Creating A Data Entry Screen In Excel  
   • Custom Formatting Dates And Times In Excel  
   • Simple Calculations With Time In Excel  
   • More (Useful) Calculations With Time In Excel  
   • It's About Time (And Dates) In Excel  
   • Excel Calls Text Data - Or How To Return a...  
   • Excel Calls Text Data 2 - This Time Using ...  
   • Excel Extracting Phone Numbers From A Cell  
   • Excel What Is The CHOOSE  Function Really ...  
   • Excel Dynamic Charting From A Drop Down  
   • Excel Extracting a Unique List, And Summin...  
   • Excel SUMIF With Dynamic Sum Range  
   • Excel VLOOKUPs With Pictures!  

Videos in the Level 3 series:
   • Excel VBA Why Should I Learn How To Code  
   • Excel VBA The 15 Golden Rules Of Coding  
   • Excel VBA Introducing The Visual Basic Edi...  
   • Excel VBA Saving Macro-enabled Workbooks, ...  
   • Excel VBA Moving VBA Code Around  
   • Excel VBA Stepping Out. Well, In Actually ...  
   • Excel VBA Introduction To The Coding VBA S...  
   • Excel VBA Introduction To Programmers Toolbox  
   • Excel VBA Introduction To Automating All Y...  
   • Excel VBA Introduction To Web Query Section  
   • Excel VBA Introduction To The VBA Workbook...  
   • Excel VBA Introduction To The VBA Windows ...  
   • Excel VBA Introduction To Automating Outlo...  
   • Excel VBA Introduction To Automating Word ...  
   • Excel VBA Introduction To Automating Power...  
   • Excel VBA Calling A Sub Stored In A Differ...  
   • Excel VBA Introduction To The Mass Data Ge...  
   • Excel VBA Get Rid Of Rows In An Array With...  
   • Excel VBA Emailing Routine Adding a Specif...  
   • Excel VBA Adding A Date Stamp, And Going T...  
   • Excel VBA Saving An Individual Sheet To A ...  
   • Excel VBA Saving Multiple Sheets To A Sing...  
   • Excel VBA Animated Charts...With A Little ...  
   • Excel VBA Extracting Specific Data From A ...  
   • Excel VBA Finding A Search String in Anoth...