Skip to content
Training in Business

Training in Business

Training news and resources for Business

  • Home
  • Business Tips
  • Management
    • Time Management
  • Business Courses
  • WordPress Training
  • Experiential Learning
  • Languages
  • Project Management
  • Microsoft
    • microsoft excel training
    • microsoft powerpoint training
    • word training

Assign Categories Based on Keywords in Excel | Check if Cell Contains Text From List

August 24, 2021 Noel Excel

Microsoft Excel Tips and Tricks

In this video I demonstrate how to categorise text values based on a list of keywords.

Credit Chester Tugwell

 

 

Excellearntraining

Post navigation

Previous Post:How to Create Simple Excel Form for Data Entry
Next Post:Excel Lookup and Find the 2nd, 3rd, 4th or Nth Occurrence / Match (Without Using an Array Formula)
  • Receny Posts
  • Popular Posts
  • How to Use Excel’s New TAKE Function to Impress Your Boss and Colleagues How to Use Excel’s New TAKE Function to Impress Your Boss and Colleagues
    May 27, 2023
  • Excel: Populate List Based on Cell Value | Populate Rows Based on Cell Value Excel: Populate List Based on Cell Value | Populate Rows Based on Cell Value
    May 27, 2023
  • Make Pivot Table from Multiple Excel Sheets Make Pivot Table from Multiple Excel Sheets
    May 27, 2023
  • Using the Excel Randarray Function Using the Excel Randarray Function
    May 27, 2023
  • Learn Excel VBA to Automate Anything Learn Excel VBA to Automate Anything
    May 27, 2023
  • How to Use Excel’s New TAKE Function to Impress Your Boss and Colleagues How to Use Excel’s New TAKE Function to Impress Your Boss and Colleagues
    May 27, 2023
  • lynda.com Episode 2: Photoshop CS2 and Flash 8, Final Cut Pro 5
  • lynda.com Episode 3: CS2 Integration, Photorealism, Lynda Weinman
  • lynda.com Episode 4: Premiere Pro 2 and iTunes 6
  • lynda.com Episode 5: Illustrator CS2 and Home & Small Office Networking

Please select the Tab Content in the Widget Settings.

Please select the Tab Content in the Widget Settings.

Our Content

  • 70:20:10 Model (1)
  • application (1)
  • automation (7)
  • behavior (4)
  • behavior change (7)
  • boss (1)
  • Business (2)
  • business courses (9)
  • business development (17)
  • Business Tips (31)
  • business training (38)
  • business training courses (3)
  • certificates (1)
  • change (9)
  • Cisco (3,644)
  • Closing (1)
  • Cloudera (3,641)
  • communication training (9)
  • compliance training (5)
  • conflict management (1)
  • constructive criticism (1)
  • continuous learning (7)
  • critical thinking (6)
  • culture (25)
  • customer education (3)
  • customer relationship management (2)
  • Customer Relationships (21)
  • customer service training (9)
  • Decision making (4)
  • E-learning (23)
  • elearning (3)
  • emotional intelligence (11)
  • empathy (4)
  • energy (2)
  • Engagement (8)
  • EQ (6)
  • Excel (487)
  • excel 2010 training (5)
  • excel training (139)
  • excel training course (11)
  • experiential learning (8)
  • facilitation (9)
  • Featured (3,660)
  • Featured Articles (48)
  • Featured Videos (73)
  • FETAC train the trainer (1)
  • Front-Featured (8)
  • game-based learning (4)
  • global (1)
  • globalization (2)
  • goal setting (6)
  • goals (7)
  • high-potential talent (2)
  • hiring (6)
  • HR Training (2)
  • ILT (7)
  • influence (6)
  • informal learning (5)
  • Instructional Design (6)
  • Kirkpatrick (3)
  • knowledge economy (3)
  • Languages (191)
  • Leadership Training (224)
  • leadership training courses (2)
  • listening (1)
  • LMS (7)
  • Management (115)
  • Management & Leadership (54)
  • management courses (4)
  • management development (2)
  • management training (14)
  • management training courses (1)
  • manager (1)
  • managerial skills (16)
  • Marketing / Advertising (2)
  • measurement (12)
  • measuring impact (3)
  • microlearning (8)
  • Microsoft (546)
  • Microsoft Access training (3)
  • microsoft excel training (19)
  • Microsoft Outlook (7)
  • microsoft powerpoint training (17)
  • microsoft project course (4)
  • microsoft project training (4)
  • Microsoft Teams (5)
  • microsoft word course (2)
  • microsoft word training (16)
  • Military Training (1)
  • Millennials (18)
  • mindset (5)
  • Motivation / Mindset (28)
  • MS Outlook (1)
  • new hire training (5)
  • on-the-job training (6)
  • onboarding (9)
  • online prospecting (2)
  • Overcoming Obstacles (9)
  • performance improvement (9)
  • performance management (24)
  • performance reviews (5)
  • performance support (1)
  • personal branding (2)
  • personal development (15)
  • PMP course (1)
  • powerpoint course (3)
  • powerpoint presentations (4)
  • powerpoint training (14)
  • powerpoint training course (2)
  • presence (4)
  • presenting (3)
  • Prince2 training (1)
  • Professional Development (3,642)
  • Project Management (3,783)
  • project management certification (3)
  • project management courses (3)
  • project management professional (1)
  • project management training (7)
  • Prospecting (20)
  • Prospecting & Qualifying (4)
  • Psychology of Selling (2)
  • purpose (7)
  • questioning strategies (4)
  • Referrals (3)
  • reinforcement (4)
  • Relationship Management (14)
  • resilience (5)
  • retail training (1)
  • retention (3)
  • Routing & Switching (3,640)
  • sales coaching (19)
  • Sales Development (14)
  • Sales Management (37)
  • sales manager (1)
  • Sales Process (40)
  • sales strategies (4)
  • sales teamwork (1)
  • sales techniques (3)
  • salespeople (3)
  • Sandler Rules (1)
  • Sandler Success Stories (5)
  • sandler summit (7)
  • Self Development (8)
  • self-awareness (7)
  • self-efficacy (1)
  • selling in an economic downturn (1)
  • serious games (1)
  • social media profile (2)
  • strategic planning (7)
  • strategy (3)
  • Successful Selling Strategies (15)
  • sustainment (3)
  • talent development (4)
  • teacher training course (1)
  • team development (10)
  • team leadership courses (1)
  • team leadership skills (3)
  • team leadership training (1)
  • Team Selling (5)
  • teamwork skills (1)
  • technical training (4)
  • Technology (3,647)
  • thirty-second commercial (1)
  • Time Management (14)
    • Time Management (2)
  • train the trainer (5)
  • train the trainer course (2)
  • training delivery (8)
  • training evaluation (5)
  • Training in Business (3,695)
  • training management (12)
  • trust (6)
  • values (3)
  • well-being (7)
  • wellness (5)
  • word training (9)
  • word training course (2)
  • Wordpress Training (7)

Our Recent Posts

  • How to Use Excel’s New TAKE Function to Impress Your Boss and Colleagues How to Use Excel’s New TAKE Function to Impress Your Boss and Colleagues
  • Excel: Populate List Based on Cell Value | Populate Rows Based on Cell Value Excel: Populate List Based on Cell Value | Populate Rows Based on Cell Value
  • Make Pivot Table from Multiple Excel Sheets Make Pivot Table from Multiple Excel Sheets
  • Using the Excel Randarray Function Using the Excel Randarray Function
  • Learn Excel VBA to Automate Anything Learn Excel VBA to Automate Anything

Premier Digital Content Network
Brought to you by the Premier Content Network

Our Website – Site Map

Our Content Network – Content Channels